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

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
Node, SQL, & PostgreSQL - Mastering Backend Web Development

Node, SQL, & PostgreSQL - Mastering Backend Web Development

Sources: udemy
Become an in demand software engineer by taking this course on Node, SQL, PostgreSQL, and backend web development. As one of the most popular web development st
4 hours 59 minutes 41 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
SQL - MySQL for Data Analytics and Business Intelligence

SQL - MySQL for Data Analytics and Business Intelligence

Sources: udemy
Well, when you can work with SQL, it means you don’t have to rely on others sending you data and executing queries for you. You can do that on your own. This al
9 hours 22 minutes 55 seconds