Full-Stack Software EngineerIntermediate8 modules~4.0 hours hands-on3 learning modes
Database Engineering - Relational & NoSQL
Master relational database design, normalization, ACID properties, advanced SQL, indexing, and NoSQL trade-offs to make confident data storage decisions.
// What you'll be able to do- Tables, keys, relationships, and normalization
- Joins, aggregations, subqueries, and window functions
- Reliable data and SQL injection prevention
- B-trees, EXPLAIN ANALYZE, and optimization strategy
8 modules, built to run
Every module ships runnable code. Expand any one to see what's inside.
00IntroductionWhat problem databases solve and why it matters30 min
Questions this module answers
- What should you know about why databases exist and what problems they solve?
- How do you choose your learning path?
Start moduleFree preview
01The Relational ModelTables, keys, relationships, and normalization30 min
Questions this module answers
- What should you know about tables, primary keys, and foreign keys?
- How do you design normalized schemas in 1NF, 2NF, and 3NF?
02SQL MasteryJoins, aggregations, subqueries, and window functions30 min
Questions this module answers
- How do you write INNER, LEFT, RIGHT, and FULL OUTER JOINs?
- How do you use GROUP BY, HAVING, and aggregation functions?
03ACID, Transactions & SecurityReliable data and SQL injection prevention30 min
Questions this module answers
- What should you know about what each ACID property guarantees?
- How do you write transactions with COMMIT, ROLLBACK, and savepoints?
04Indexes & Query PerformanceB-trees, EXPLAIN ANALYZE, and optimization strategy30 min
Questions this module answers
- How B-tree indexes work internally?
- What should you know about when to add an index and when not to?
05NoSQL & the CAP TheoremDocument stores, key-value, and consistency trade-offs30 min
Questions this module answers
- What should you know about why NoSQL databases exist and what problem they solve?
- How do you use MongoDB document model and query operators?
06ORMs & MigrationsPrisma schema, type-safe queries, and versioned changes30 min
Questions this module answers
- What should you know about what ORMs do and what they abstract?
- How do you create and apply database migrations?
07Pattern SynthesisChoosing the right database for any scenario30 min
Questions this module answers
- How do you apply a decision framework to database selection problems?
- What should you know about what you know - and where to go deeper?
Ready to start Database Engineering - Relational & NoSQL?
Start with the free Module 0, then unlock the full course on a Pro plan.