Roadmap
-
1
Database concepts
- Tables, keys and relationships
- ER diagrams and normalization
- DBMS vs RDBMS
- ACID and transactions
-
2
SQL
- SELECT, WHERE, ORDER BY, GROUP BY
- JOINs and sub-queries
- Views, indexes and stored procedures
- Backup, restore and users
-
3
NoSQL & cloud
- MongoDB documents and aggregation
- Firebase Firestore and security rules
- Supabase / PostgreSQL with row-level security
- Redis caching
-
4
Data warehouse
- OLTP vs OLAP
- Star and snowflake schemas
- ETL pipelines
- BigQuery and reporting
Video lessons
All videos →New Databases (SQL & NoSQL) lessons are on the way
Subscribe to get them as soon as they are published.