Neil Sainsbury
59 - Query optimization | Mastery with SQL
11:31
Neil Sainsbury
58 - Reading complex query plans | Mastery with SQL
10:18
Neil Sainsbury
57 - Indexes | Mastery with SQL
10:57
Neil Sainsbury
56 - Query plans with EXPLAIN | Mastery with SQL
11:31
Neil Sainsbury
55 - Writing functions with PLpgSQL | Mastery with SQL
10:16
Neil Sainsbury
54 - Writing functions with SQL | Mastery with SQL
8:25
Neil Sainsbury
53 - Functions | Mastery with SQL
2:28
Neil Sainsbury
52 - Materialized views | Mastery with SQL
5:45
Neil Sainsbury
51 - Views | Mastery with SQL
7:49
Neil Sainsbury
50 - Deleting data | Mastery with SQL
4:29
Neil Sainsbury
49 - Updating data | Mastery with SQL
8:59
Neil Sainsbury
48 - Using transactions and inserting data | Mastery with SQL
9:11
Neil Sainsbury
46 - CHECK, UNIQUE, and NOT NULL | Mastery with SQL
10:48
Neil Sainsbury
47 - Importing and exporting data | Mastery with SQL
10:29
Neil Sainsbury
45 - Foreign keys | Mastery with SQL
11:06
Neil Sainsbury
44 - Primary keys | Mastery with SQL
17:49
Neil Sainsbury
43 - Creating tables | Mastery with SQL
14:42
Neil Sainsbury
42 - EXCEPT | Mastery with SQL
7:02
Neil Sainsbury
41 - INTERSECT | Mastery with SQL
4:21
Neil Sainsbury
40 - UNION | Mastery with SQL
7:41
Neil Sainsbury
39 - A little bit of set theory | Mastery with SQL
3:11
Neil Sainsbury
38 - LAG and LEAD | Mastery with SQL
8:08
Neil Sainsbury
37 - Aggregate window functions | Mastery with SQL
12:40
Neil Sainsbury
36 - Ranking window functions | Mastery with SQL
8:57
Neil Sainsbury
35 - Common table expressions | Mastery with SQL
8:15
Neil Sainsbury
34 - Lateral subqueries | Mastery with SQL
4:41
Neil Sainsbury
33 - Table subqueries | Mastery with SQL
11:44
Neil Sainsbury
32 - Correlated subqueries | Mastery with SQL
13:13
Neil Sainsbury
31 - Uncorrelated subqueries | Mastery with SQL
11:01
Neil Sainsbury
29 - Outer joins | Mastery with SQL
16:34
Neil Sainsbury
30 - Advanced join topics | Mastery with SQL
8:54
Neil Sainsbury
28 - Inner joins | Mastery with SQL
12:27
Neil Sainsbury
27 - Cross joins | Mastery with SQL
8:41
Neil Sainsbury
26 - Introduction to joins | Mastery with SQL
2:58
Neil Sainsbury
25 - Date and time types | Mastery with SQL
19:40
Neil Sainsbury
24 - Number data types | Mastery with SQL
19:10
Neil Sainsbury
23 - Character data types | Mastery with SQL
11:52
Neil Sainsbury
22 - Introduction to data types | Mastery with SQL
14:04
Neil Sainsbury
21 - CASE expressions and aggregations | Mastery with SQL
10:47
Neil Sainsbury
20 - GROUP BY and HAVING | Mastery with SQL
11:46
Neil Sainsbury
19 - Common aggregate functions | Mastery with SQL
4:20
Neil Sainsbury
18 - CASE expressions | Mastery with SQL
7:32
Neil Sainsbury
17 - DISTINCT | Mastery with SQL
4:35
Neil Sainsbury
16 - LIMIT and OFFSET | Mastery with SQL
5:09
Neil Sainsbury
15 - SQL Order of execution | Mastery with SQL
5:26
Neil Sainsbury
14 - ORDER BY | Mastery with SQL
8:40
Neil Sainsbury
13 - IN, BETWEEN, and LIKE | Mastery with SQL
7:14
Neil Sainsbury
12 - NULL handling | Mastery with SQL
5:29
Neil Sainsbury
11 - AND, OR, and NOT | Mastery with SQL
5:10
Neil Sainsbury
10 - Filtering with WHERE | Mastery with SQL
10:30
Neil Sainsbury
09 - Derived Columns | Mastery with SQL
11:27
Neil Sainsbury
08 - SELECT FROM | Mastery with SQL
8:19
Neil Sainsbury
07 - Setting up the sample database | Mastery with SQL
6:06
Neil Sainsbury
06a - Several nice tweaks for DBeaver | Mastery with SQL
4:14
Neil Sainsbury
06 - Creating your first database and table | Mastery with SQL
19:31
Neil Sainsbury
05 - Installing PostgreSQL and DBeaver (Mac) | Mastery with SQL
4:47
Neil Sainsbury
04 - Installing PostgreSQL and DBeaver (Windows) | Mastery with SQL
4:30
Neil Sainsbury
03 - Tables and the Relational Model | Mastery with SQL
12:20
Neil Sainsbury
01 - Course introduction | Mastery with SQL
3:08
Neil Sainsbury
02 - Databases and SQL | Mastery with SQL
10:47