Packed with high quality videos, practical examples, and interesting and challenging exercises to practice what you've learned. The course is broad and deep, taking you from beginner level to mastery with SQL and doing it in a way that creates a deep understanding of what you've learned. My goal is to give you the practical tools and skills you need to get your job done.
Mastery with SQL
9h 15m 2s
English
Paid
About the Author: Mastery with SQL
Mastery with SQL (masterywithsql.com) is a paid SQL course platform focused on building real working proficiency with SQL across the major dialects — the foundational data-querying skill that compounds across an engineering career.
The CourseFlix listing carries Mastery with SQL — a comprehensive SQL curriculum covering the language from fundamentals through advanced patterns: window functions, recursive CTEs, query optimisation, the joins-vs-subqueries decision-making, and the patterns that show up in real production SQL work.
Material is paid and aimed at developers and analysts ready to take SQL as a deliberate professional skill. For broader content, see CourseFlix's SQL category page.
Watch Online 61 lessons
0:00
/ #1: Course introduction
All Course Lessons (61)
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 1 | Course introduction Demo | 03:35 | |
| 2 | Databases and SQL | 10:47 | |
| 3 | Tables and the relational model | 12:20 | |
| 4 | Installing PostgreSQL and DBeaver (Windows) | 04:30 | |
| 5 | Installing PostgreSQL and DBeaver (Mac) | 04:47 | |
| 6 | Creating your first database and table | 19:31 | |
| 7 | Several nice tweaks for DBeaver | 04:14 | |
| 8 | Setting up the sample database | 06:06 | |
| 9 | SELECT FROM | 08:19 | |
| 10 | Derived columns | 11:27 | |
| 11 | Filtering with WHERE | 10:30 | |
| 12 | AND, OR, and NOT | 05:10 | |
| 13 | NULL handling | 05:29 | |
| 14 | IN, BETWEEN, and LIKE | 07:14 | |
| 15 | ORDER BY | 08:40 | |
| 16 | SQL Order of execution | 05:26 | |
| 17 | LIMIT and OFFSET | 05:09 | |
| 18 | DISTINCT | 04:35 | |
| 19 | CASE expressions | 07:32 | |
| 20 | Common aggregate functions | 04:20 | |
| 21 | GROUP BY and HAVING | 11:46 | |
| 22 | CASE expressions and aggregations | 10:47 | |
| 23 | Introduction to data types | 14:04 | |
| 24 | Character data types | 11:52 | |
| 25 | Number data types | 19:10 | |
| 26 | Date and time data types | 19:40 | |
| 27 | Introduction to joins | 02:58 | |
| 28 | Cross joins | 08:41 | |
| 29 | Inner joins | 12:27 | |
| 30 | Outer joins | 16:34 | |
| 31 | Advanced join topics | 08:54 | |
| 32 | Uncorrelated subqueries | 11:01 | |
| 33 | Correlated subqueries | 13:14 | |
| 34 | Table subqueries | 11:44 | |
| 35 | Lateral subqueries | 04:41 | |
| 36 | Common table expressions (CTEs) | 08:16 | |
| 37 | Ranking window functions | 08:57 | |
| 38 | Aggregate window functions | 12:40 | |
| 39 | LAG and LEAD | 08:08 | |
| 40 | A little bit of set theory | 03:11 | |
| 41 | UNION | 07:41 | |
| 42 | INTERSECT | 04:21 | |
| 43 | EXCEPT | 07:02 | |
| 44 | Creating tables | 14:42 | |
| 45 | Primary keys | 17:49 | |
| 46 | Foreign keys | 11:06 | |
| 47 | CHECK, UNIQUE, and NOT NULL constraints | 10:48 | |
| 48 | Importing and exporting data | 10:29 | |
| 49 | Using transactions and inserting data | 09:12 | |
| 50 | Updating data | 08:59 | |
| 51 | Deleting data | 04:29 | |
| 52 | Views | 00:57 | |
| 53 | Materialized views | 07:50 | |
| 54 | Functions | 05:45 | |
| 55 | Writing functions with SQL | 02:28 | |
| 56 | Writing functions with PL/pgSQL | 08:25 | |
| 57 | Query plans with EXPLAIN | 10:16 | |
| 58 | Indexes | 11:31 | |
| 59 | Reading complex query plans | 10:57 | |
| 60 | Query optimization | 10:18 | |
| 61 | Congratulations | 11:31 |
Unlock unlimited learning
Get instant access to all 60 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.
Learn more about subscriptionRelated courses
-
Updated 8mo agoDBMS
By: takeUforward (Striver)This course is dedicated to the study of Database Management Systems (DBMS) - technologies that allow for efficient storage, processing, and protection of data.21h 30m5/5 -
Updated 1y agoSQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL
By: UdemyAre you interested in a career in Data Science or Data Analytics? In that case, inevitably you are going to encounter databases in your work. But how do you int12h 32m -
Updated 2y agoZero To Shipped
By: Kitze (Kristijan Ristovski)Feeling intimidated by fullstack development? Wondering how can some developers ship a functional app in one day? This engaging video course demystifies and sim24h 38m
Frequently asked questions
What is Mastery with SQL about?
Packed with high quality videos, practical examples, and interesting and challenging exercises to practice what you've learned. The course is broad and deep, taking you from beginner level to mastery with SQL and doing it in a way that…
Who teaches this course?
It is taught by Mastery with SQL. You can find more courses by this instructor on the corresponding source page.
How long is the course?
It contains 61 lessons with a total runtime of 9 hours 15 minutes. Every lesson is available to watch online at your own pace.
Is it free to watch?
It is part of CourseFlix's premium catalog. A subscription unlocks the full video player; the course description, table of contents, and preview information are available to everyone.
Where can I watch it online?
The course is available to watch online on CourseFlix at https://courseflix.net/course/mastery-with-sql. The page hosts every lesson with the integrated video player; no download is required.