CF

Mastery with SQL

9h 15m 2s
English
Paid
Added to CourseFlix

Mastery with SQL is a 61-lesson 9 hours 15 minutes self-paced course by Mastery with SQL. Packed with high quality videos, practical examples, and interesting and challenging exercises to practice what you've learned.

Course facts

Lessons
61
Duration
9 hours 15 minutes
Language
English
Added to CourseFlix
April 2024
Instructor
Mastery with SQL
Price
Premium

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.


Who teaches Mastery with SQL? Mastery with SQL

Mastery with SQL thumbnail

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.

What lessons are included in Mastery with SQL?

This is a demo lesson (10:00 remaining)

Watch the first 10 minutes free. One payment unlocks all 61 lessons here and every other premium course. No auto-renew.

View Pricing
0:00
/
#1: Course introduction
All Course Lessons (61)
#Lesson TitleDurationAccess
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
Watch the other 60 lessons

One payment unlocks this course and every other premium course. No auto-renew.

See plans

What courses are similar to Mastery with SQL?

Frequently asked questions

What are the prerequisites for enrolling in this SQL course?
The course is designed to take students from beginner to mastery, so no prior knowledge of SQL is required. However, having a basic understanding of computer operations and general programming concepts can be beneficial. The course begins with foundational topics like databases and SQL, ensuring that newcomers can follow along.
What kind of projects or exercises will I work on during the course?
The course includes practical exercises that allow you to apply what you've learned. For example, you will create databases and tables, perform complex queries using joins and subqueries, and optimize query performance using indexes. These exercises are designed to help solidify your understanding of SQL concepts and apply them in real-world scenarios.
Who is the target audience for this SQL course?
This course is suitable for anyone looking to gain a deep understanding of SQL, from beginners to those seeking to master advanced SQL techniques. It is particularly beneficial for aspiring data analysts, database administrators, and developers who need to work with SQL databases like PostgreSQL in their roles.
How does the depth of this course compare to other SQL courses?
The course covers a wide range of topics, from basic database operations to advanced SQL concepts like window functions and query optimization. With 61 lessons, it offers both breadth and depth, aiming to provide a comprehensive understanding of SQL that goes beyond introductory courses.
What specific tools or platforms will I learn to use in this course?
The course involves working with PostgreSQL and DBeaver. You will learn how to install these tools on both Windows and Mac systems, configure the environment, and use DBeaver's features for database management and query execution. Mastery of these tools is critical for efficiently handling SQL databases.
What topics are not covered in this SQL course?
While the course is extensive, it does not cover database administration tasks such as backup and restore operations, security management, or database server tuning in depth. The focus is primarily on SQL query writing and optimization within the PostgreSQL environment.
How much time should I expect to commit to this course?
The course is designed to be completed at your own pace. With 61 lessons, including video lectures and practical exercises, students should plan to dedicate several weeks to fully absorb the material. The exact time commitment will depend on your prior experience and how deeply you wish to engage with the exercises.