Mastery with SQL

9h 15m 2s
English
Paid

Course description

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.


Watch Online

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 61 lessons in this course and access 10,000+ hours of premium content across all courses.

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

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 subscription

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

Database Mastery: SQL to Prisma

Database Mastery: SQL to Prisma

Sources: jsmastery.pro, Adrian Hajdin
Master key technologies with a practical approach! You will gain applied knowledge, clear explanations, and all the necessary tools to confidently master...
16 minutes 3 seconds
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL

SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL

Sources: udemy
Are 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 int
12 hours 32 minutes 7 seconds
Learn Database Design with MySQL

Learn Database Design with MySQL

Sources: oreillymedia
Good course for starting up & covers quickly the important topics and shows for beginners what MySQL can be used for. Database design is one of the most importa
6 hours 14 minutes 51 seconds
Ludicrous Speed Postgres

Ludicrous Speed Postgres

Sources: Creston Jamison
This course is dedicated to optimizing PostgreSQL performance with a focus on proper schema design and efficient database usage. It is designed for those...
12 hours 27 minutes 44 seconds
Effective Database Design

Effective Database Design

Sources: Ben Brumm
The course "Effective Database Design" will provide you with an action plan, examples, and instructions for creating a well-designed database.
1 hour 3 minutes 56 seconds