SQL & Relational Databases
SQL foundations, advanced queries, database design, PostgreSQL in depth, NoSQL & polyglot persistence, and a capstone data platform
100% Free · All lessons unlocked
Course Content
Foundations
Core concepts and groundwork
Relational model — tables, keys and constraints
Reading
SELECT, WHERE, ORDER BY and LIMIT
Reading
Aggregations — GROUP BY, HAVING, COUNT, SUM
Reading
JOINs — INNER, LEFT, RIGHT and FULL OUTER
Reading
Subqueries and CTEs
Reading
Practice — query a retail sales database
Exercise
Core Skills
Essential techniques and patterns
Window functions — ROW_NUMBER, RANK, DENSE_RANK
Reading
LAG, LEAD, FIRST_VALUE and LAST_VALUE
Reading
Date and time functions
Reading
String functions and pattern matching
Reading
Conditional logic — CASE, COALESCE, NULLIF and PIVOT patterns
Reading
Practice — advanced analytics on IPL data
Exercise
Applied Practice
Hands-on, real-world scenarios
Advanced Topics
Deeper, more complex material
Production & Scale
Building for the real world
Mastery & Capstone
Projects and final review
Practice — multi-model data access patterns
Exercise
Capstone brief — the CricketVerse data platform
Project
Exercise 1 — design the CricketVerse schema
Exercise
Exercise 2 — write the analytical queries
Exercise
Exercise 3 and final project — polyglot architecture and integration
Exercise
100% Free · All lessons unlocked
Topic Overview
What you'll learn
- Core concepts and fundamentals of SQL & Relational Databases
- Industry best practices and design patterns
- Hands-on exercises with real-world scenarios
- Performance optimization and advanced techniques
- Building production-ready applications