🗄️ Database Essentials
Work with data: SQL and queries, data modeling, indexing and performance, transactions and concurrency, NoSQL and scaling, and operations.
0/9
1Free2🔒★🔒 Standard3🔒4🔒★🔒 Standard5🔒6🔒★🔒 Standard🎓🔒 Professional
SQL & Queries
Pull exactly the rows you need by pairing the right JOIN with GROUP BY, HAVING, subqueries, and window functions.
Data Modeling
Design schemas that stay honest: primary and foreign keys, junction tables for many-to-many, and normalization you denormalize on purpose.
Chapter review
Chapter 1 review — SQL & modeling
Lab: Model it and query it · 10-question check
Indexing & Performance
Turn slow scans into instant lookups by reading EXPLAIN plans and placing indexes that honor the leftmost-prefix rule.
Transactions & Concurrency
Keep concurrent writes correct with ACID transactions, choosing isolation levels that balance dirty and phantom reads against locking, deadlocks, and MVCC.
Chapter review
Chapter 2 review — Indexing & transactions
Lab: Make it fast and correct · 10-question check
NoSQL & Scaling
Match document, key-value, wide-column, or graph stores to your access pattern, then scale out with sharding, replication, and the CAP tradeoff.
Operations & Reliability
Sleep through incidents with point-in-time backups, replicas for failover and read scaling, and reversible migrations that dodge long locks.
Chapter review
Chapter 3 review — Scaling & operations
Lab: Scale and operate · 10-question check
Final exam
Database Essentials — comprehensive capstone
Hands-on capstone + course-wide exam · scored to a role level