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

MySQL High Performance Tuning Guide

MySQL High Performance Tuning Guide

Sources: udemy
Tips for Tuning MySQL like a Pro. Learn how to prevent MySQL performance problems. Understand how MySQL optimizes and executes queries.
2 hours 49 minutes 22 seconds
DBMS

DBMS

Sources: takeUforward
This course is dedicated to the study of Database Management Systems (DBMS) - technologies that allow for efficient storage, processing, and protection of data.
21 hours 30 minutes 50 seconds
The Complete SQL Bootcamp: Go from Zero to Hero

The Complete SQL Bootcamp: Go from Zero to Hero

Sources: udemy
You'll learn how to read and write complex queries to a database using one of the most in demand skills - PostgreSQL. These skills are also applicable to any ot
8 hours 45 minutes 49 seconds
The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

Sources: udemy
If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but compreh...
36 hours 35 minutes 57 seconds