Back to roadmap Dashboard

IntermediateApplied6 weeks

Databases

Design relational databases, write efficient queries, and optimize data access for production workloads.

Topic 6 of 24

Prerequisites

Programming Fundamentals

Key Concepts & Skills

SQL
PostgreSQL
MySQL
Database Design
Normalization
Indexing
Query Optimization
Model relational data
Write SQL joins
Design indexes
Analyze query plans

Learning Outcomes

Understand the core principles of SQL
Configure and deploy PostgreSQL successfully
Troubleshoot common issues with MySQL
Understand the core principles of Database Design
Configure and deploy Normalization successfully
Troubleshoot common issues with Indexing
Understand the core principles of Query Optimization
Configure and deploy Model relational data successfully
Troubleshoot common issues with Write SQL joins
Understand the core principles of Design indexes
Configure and deploy Analyze query plans successfully

Resources

Official Docs

PostgreSQL docs

Practice

Video

Hussein Nasser: Database Engineering

Community

Use The Index, Luke

Practice Exercises

Design normalized tables for a blog.Write joins and aggregations.Use EXPLAIN on a slow query.

Project Task

Build a notes API backed by PostgreSQL.

Quiz

How does an index speed up reads and slow down writes?Explain the answer with one real-world example.List one mistake a beginner might make here.

Notes