// mastery/sql-mastery.course
SQL Mastery
SQL from fundamentals through advanced query design and optimization.
12 lessons
45 hours
Certificate included
4.8/5 0 reviews
// what you'll actually build
Capstone project: a reporting query set
Using the schema from SQL Databases, write a set of reporting queries using this course's tools. Requirements A query ranking courses by revenue using a window function. A query wrapped in an explicit transaction that…
🔒 Unlocks after the free preview — this is lesson 11 of 12.
Curriculum
1
Welcome to SQL Mastery
2
Subqueries
3
Transactions
4
Indexes and performance
5
Window functions
6
Schema design patterns
7
Common table expressions (CTEs)
8
Joins in depth
9
Aggregate functions, GROUP BY, and HAVING
10
Views and constraints
11
Capstone project: a reporting query set
12
Wrap-up and certificate
13
Final exam
What's included
- 12 lessons, 45 hours of content
- Hands-on exercises after every module
- Beginner, Intermediate, and Advanced content bundled together
- Professional portfolio projects
- Final assessment
- Downloadable resources
- Lifetime updates
- Completion certificate
Reviews
No reviews yet.