Free Self-Paced Course
Database Fundamentals
8 Weeks · 302 Sections · Computer Science — Databases
This free, self-paced course provides a structured 8-week syllabus for learning Database Fundamentals. Each module builds on the previous one, guiding you from foundational concepts through advanced topics with 302 pages of in-depth reading material. All content is drawn from our comprehensive Database Fundamentals textbook, organized into a clear weekly schedule that you can follow at your own pace.
Weekly Syllabus
- Part II — SQL Mastery
- Chapter 5: SELECT, FROM, WHERE — Your First Queries
- Chapter 6: JOINs — Connecting Tables, the Most Important SQL Skill
- Chapter 7: Aggregation — GROUP BY, HAVING, and Summarizing Data
- Chapter 8: Built-in Functions — Strings, Numbers, Dates, and Type Conversion
- Chapter 9: Subqueries — Queries Inside Queries
- Chapter 10: Set Operations — UNION, INTERSECT, EXCEPT
- Chapter 11: Common Table Expressions and Recursive Queries
- Chapter 12: Window Functions — Analytics Without Losing Row Detail
- Chapter 13: Data Modification — INSERT, UPDATE, DELETE, and UPSERT
- Chapter 14: Data Definition — CREATE, ALTER, DROP, and Building Your Schema
- Chapter 15: Views, Materialized Views, and Functions — Reusable SQL Objects
- Chapter 16: Advanced SQL — JSON, Full-Text Search, Arrays, and PostgreSQL Superpowers
How to Use This Syllabus
- Read at your own pace. Each module is designed for roughly one week of study, but there are no deadlines. Spend as much time as you need on each topic.
- Follow in order or jump around. The modules are arranged sequentially for a structured learning path, but feel free to skip to any topic that interests you most.
- No sign-up needed. Every page in this syllabus links directly to free, open-access content. Just click a topic and start reading immediately.
Ready to Start Learning?
Access the full Database Fundamentals textbook with all chapters, examples, and exercises.
Open the Full Textbook