SQL & Relational Database Fundamentals
BeginnerDatabases · 8 lessons · 1h
Query, join and reason about relational data with confidence — the skill every engineering role needs.
What this course covers
From SELECT to window functions: write correct, performant SQL, understand how a relational database actually executes your queries, and learn the indexing and normalization concepts that separate a fast query from a slow one.
Karthik Subramanian
Database & Backend Architect
Course outline
Module 1: Querying Relational Data
- 📄SELECT, WHERE and ORDER BY fundamentals6 min
- 📄JOINs: inner, left, and why they matter8 min
- 📄Aggregations, GROUP BY and window functions9 min
Module 2: Designing Schemas That Hold Up
- 📄Normalization: why we split tables apart8 min
- 📄Primary keys, foreign keys and constraints7 min
- 📄Indexes: what they are and when they help8 min
Module 3: Writing Queries That Perform
- 📄Reading an EXPLAIN plan7 min
- 📄Transactions and isolation basics7 min
📝 SQL Fundamentals Check(pass at 70%)
🔒 SQL & Databases — Final Exam(proctored · 30 min · pass at 70% · camera required)
Final proctored exam — the exam screen locks immediately if you switch tabs, exit fullscreen, or lose window focus. Passing it (plus finishing every lesson) is what unlocks your certificate.
Enroll to unlock the exam.
Hands-on labs for this course
Practice what you learn in real lab environments — book access any time.
PostgreSQL
PostgreSQL instance with sample schemas and extensions enabled.
Microsoft SQL Server
SQL Server instance with sample databases for T-SQL practice.
MongoDB
MongoDB instance with sample collections for document-database practice.
MySQL
MySQL server with sample schemas for query and admin practice.
Learning materials
Downloadable PDF references for this course, organized by topic.
SQL Quick Reference Guide
Databases · 2 KB