📘 01 Notes¶
Topic-based SQL & Databases study notes organized into 8 modules, taught primarily in PostgreSQL with comparison callouts for MySQL, SQL Server, SQLite, and Oracle. Each page is designed to stand alone, with quick links back to the course flow and a matching practice set.
🧭 Module Dashboard¶
| Module | Focus | Lessons | Start | Practice |
|---|---|---|---|---|
| 01 | Getting Started | 4 | Start | Practice |
| 02 | The Relational Model | 4 | Start | Practice |
| 03 | SQL Fundamentals | 5 | Start | Practice |
| 04 | Data Modeling & E-R Diagrams | 5 | Start | Practice |
| 05 | Database Design & Normalization | 4 | Start | Practice |
| 06 | Database Administration | 4 | Start | Practice |
| 07 | Data Warehousing, BI & Big Data | 4 | Start | Practice |
| 08 | Advanced SQL | 4 | Start | Practice |
📚 Full Lesson Index¶
Module 01: Getting Started
- [01-01: Why Databases?](01-01-why-databases.md) - [01-02: Relational Tables & Database Systems](01-02-relational-tables-and-db-systems.md) - [01-03: The DBMS Landscape](01-03-dbms-landscape.md) - [01-04: Web Apps, Warehouses, Big Data & Cloud](01-04-web-warehouses-big-data-cloud.md)Module 02: The Relational Model
- [02-01: Relations & Terminology](02-01-relations-and-terminology.md) - [02-02: Characteristics of Relations](02-02-characteristics-of-relations.md) - [02-03: Keys](02-03-keys.md) - [02-04: Functional Dependencies](02-04-functional-dependencies.md)Module 03: SQL Fundamentals
- [03-01: DDL — Tables & Data Types](03-01-ddl-tables-and-datatypes.md) - [03-02: DML — Insert, Update, Delete](03-02-dml-insert-update-delete.md) - [03-03: SELECT — Filtering & Sorting](03-03-select-filtering-sorting.md) - [03-04: Joins](03-04-joins.md) - [03-05: Subqueries & Aggregation](03-05-subqueries-and-aggregation.md)Module 04: Data Modeling & E-R Diagrams
- [04-01: Systems Analysis & Database Lifecycle](04-01-systems-analysis-and-db-lifecycle.md) - [04-02: E-R Diagram Notation](04-02-er-diagram-notation.md) - [04-03: Relationship Types](04-03-relationship-types.md) - [04-04: Relationship Degree](04-04-relationship-degree.md) - [04-05: Context-Dependent Design](04-05-context-dependent-design.md)Module 05: Database Design & Normalization
- [05-01: Transforming E-R Models into Tables](05-01-transforming-er-to-tables.md) - [05-02: Representing Relationships in SQL](05-02-representing-relationships-in-sql.md) - [05-03: Normalization](05-03-normalization.md) - [05-04: Joins over Recursive Relationships](05-04-joins-over-recursive-relationships.md)Module 06: Database Administration
- [06-01: DBA Roles & Responsibilities](06-01-dba-roles.md) - [06-02: Concurrency & Locking](06-02-concurrency-and-locking.md) - [06-03: Transactions & ACID](06-03-transactions-and-acid.md) - [06-04: Security, Backup & Recovery](06-04-security-backup-recovery.md)Module 07: Data Warehousing, BI & Big Data
- [07-01: Data Warehouses & Marts](07-01-data-warehouses-and-marts.md) - [07-02: OLAP vs OLTP & BI](07-02-olap-vs-oltp-and-bi.md) - [07-03: Cloud & Virtualization](07-03-cloud-and-virtualization.md) - [07-04: Big Data & NoSQL](07-04-big-data-and-nosql.md)Module 08: Advanced SQL
- [08-01: ALTER, MERGE & Views](08-01-alter-merge-and-views.md) - [08-02: Outer Joins & Correlated Subqueries](08-02-outer-joins-and-correlated-subqueries.md) - [08-03: Recursive Queries & Set Operators](08-03-recursive-queries-and-set-operators.md) - [08-04: Window Functions & User-Defined Functions](08-04-window-functions-and-udfs.md)🛣 Recommended Flow¶
- Read the module notes in order.
- Complete the matching exercise set.
- Use the quiz hub for recall practice.
- Build a project when the concept needs hands-on reinforcement.