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

Make a Google search engine clone: JavaScript PHP and MySQL

Make a Google search engine clone: JavaScript PHP and MySQL

Sources: udemy
Do you want to become an expert in JavaScript, PHP and MySQL?Do you want to build a real search engine just like Google? If so, you’re in the right place!
5 hours 47 minutes 11 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
Complete SQL + Databases Bootcamp: Zero to Mastery

Complete SQL + Databases Bootcamp: Zero to Mastery

Sources: zerotomastery.io
With so many online resources available, it can be paralyzing not only figuring out where to start but more importantly which courses will actually teach you the skills you need...
24 hours 6 minutes 52 seconds
Zero To Shipped

Zero To Shipped

Sources: Kitze
Feeling intimidated by fullstack development? Wondering how can some developers ship a functional app in one day? This engaging video course demystifies and simplifies the proce...
24 hours 38 minutes 44 seconds