// intermediate/sql-databases.course
SQL Databases
Model schemas, write joins and queries, design a database for production.
12 lessons
12 hours
Certificate included
4.8/5 0 reviews
// what you'll actually build
Project: design a small course-platform schema
Design and create tables for a simplified version of a course platform like this one. Requirements users (id, name, email) courses (id, title, level, price_cents) enrollments linking users to courses, with a…
🔒 Unlocks after the free preview — this is lesson 11 of 12.
Curriculum
1
Welcome to SQL Databases
2
SELECT, WHERE, and ORDER BY
3
JOINs
4
NULL values and CASE expressions
5
Aggregate functions and GROUP BY
6
Subqueries
7
INSERT, UPDATE, and DELETE
8
Transactions: BEGIN, COMMIT, and ROLLBACK
9
Schema design and keys
10
Indexes and query performance
11
Project: design a small course-platform schema
12
Wrap-up and what's next
What's included
- 12 lessons, 12 hours of content
- Hands-on exercises after every module
- Real-world practice projects
- Completion certificate
Reviews
No reviews yet.