SQL & Database Engineering
Design reliable relational data systems, write efficient SQL, and operate production databases.
22h 30m total·6 sections·30 topics
Filter:
Sort:
Make this roadmap your plan
Sign in to save your routine, streaks, notes, and progress across devices.
0 of 30 topics completed(est. 22h 30m remaining)
0%
1
Relational Foundations
Build practical skill in relational foundations.
3h 45m0/5
0%
Relational thinking and schemas
beginner45mLearn relational thinking and schemas and apply it in a production-minded design.
Subtopics (0/2)
Core concepts
Applied practice
Relational thinking and schemas — official documentationRelational thinking and schemas — practical guideRelational thinking and schemas — hands-on exercise
Tables rows and constraints
beginner45mKeys and referential integrity
beginner45mNormalization trade-offs
beginner45mRelational algebra essentials
beginner45m2
SQL Querying
Build practical skill in sql querying.
3h 45m0/5
0%
SELECT filtering and projection
beginner45mJoins and join strategies
beginner45mAggregations and grouping
beginner45mSubqueries and common table expressions
beginner45mWindow functions
beginner45m3
Data Modeling
Build practical skill in data modeling.
3h 45m0/5
0%
Indexes and access paths
intermediate45mEntity relationship modeling
intermediate45mDimensional modeling
intermediate45mMigrations and schema evolution
intermediate45mData quality constraints
intermediate45m4
Performance & Transactions
Build practical skill in performance & transactions.
3h 45m0/5
0%
Query plans and EXPLAIN
intermediate45mComposite and covering indexes
intermediate45mTransactions and isolation
intermediate45mLocking and deadlocks
intermediate45mConcurrency control
intermediate45m5
Distributed Data
Build practical skill in distributed data.
3h 45m0/5
0%
Replication fundamentals
advanced45mPartitioning strategies
advanced45mSharding trade-offs
advanced45mCaching database reads
advanced45mChange data capture
advanced45m6
Database Operations
Build practical skill in database operations.
3h 45m0/5
0%