SQL
SQL and Relational Databases
Learn relational data modeling and SQL from first SELECT statements through joins, aggregation, transactions, and indexes.
This is one technology path. Learn React, Next.js, Node.js, JavaScript basics, and future tracks separately at your own pace.
coverage.map
Topics this track covers
relational modelingtablesrows and columnsprimary keysforeign keysSELECTWHEREORDER BYINSERTUPDATEDELETEINNER JOINLEFT JOINGROUP BYaggregate functionsconstraintstransactionsindexesquery plansparameterized queries
1
Tables and First Queries
Understand relational tables and retrieve exactly the rows and columns you need.
- Relational tables - 8 min
- SELECT, WHERE, and ORDER BY - 8 min
- INSERT, UPDATE, and DELETE - 8 min
2
Relationships and Analysis
Connect tables and summarize data without duplicating it.
- Primary and foreign keys - 8 min
- INNER and LEFT JOIN - 8 min
- GROUP BY and aggregates - 8 min
3
Reliable and Fast SQL
Protect multi-step changes and understand how databases find data efficiently.
- Transactions and constraints - 8 min
- Indexes and query plans - 8 min
- Safe application queries - 8 min