Learn PostgreSQL and SQL From Zero
Level 4: Data Foundations. Databases, SQL & Schema Design. Design data storage that still makes sense six months later.
- Relational databases
- SQL
- Schema design
- Indexes & performance
- MongoDB & Redis
What you can do by the end of the level
- Relational concepts and how to read an ERD
- SQL: filtering, joins, aggregation, window functions
- Normalising schemas and writing migrations safely
- Indexes and EXPLAIN ANALYZE for slow queries
- When MongoDB or Redis earns its place, and when it does not
Portfolio project for this level
Production-Ready Database Schema
A full design with migrations, seed data, and queries that answer product questions.
How do I move up to the next level?
Each level ends with an assessment. Pass it and you move up. If not, you repeat this level instead of being pushed forward. You also get one free step back a level.
How much does this level cost?
From Rp300.000 per level, plus a Rp500.000 commitment fee paid once on enrollment. The opening class of this level is free. Cost
Start with the free opening class
Join the first Level 1 class, see how we teach and meet the mentor. Then decide.