SQL & Databases¶
Database Concepts and SQL learning materials organized for fast review, practice, and hands-on schema work — taught primarily in PostgreSQL, with callouts comparing MySQL, SQL Server, SQLite, and Oracle syntax along the way.
Course Flow¶
- Read the topic notes for the current module.
- Work through the matching exercise.
- Test yourself in the quiz hub.
- Build a schema or query lab to prove the concept.
Modules¶
| Module | Focus | Start |
|---|---|---|
| 01 | Getting Started | Why Databases? |
| 02 | The Relational Model | Relations & Terminology |
| 03 | SQL Fundamentals | DDL: Tables & Data Types |
| 04 | Data Modeling & E-R Diagrams | Systems Analysis & DB Lifecycle |
| 05 | Database Design & Normalization | Transforming E-R Models into Tables |
| 06 | Database Administration | DBA Roles & Responsibilities |
| 07 | Data Warehousing, BI & Big Data | Data Warehouses & Marts |
| 08 | Advanced SQL | ALTER, MERGE & Views |