What you’re going to be learning
1. Introduction to databases and the relational model
3 videos 
26 minutes
1. Course introduction (3:34)
2. Databases and SQL (10:46)
3. Tables and the relational model (12:19)
2. Getting setup
5 videos 39 minutes
4. Installing PostgreSQL and DBeaver (Windows) (4:29)
5. Installing PostgreSQL and DBeaver (Mac) (4:46)
6. Creating your first database and table (19:30)
7. Several nice tweaks for DBeaver (4:13)
8. Setting up the sample database (6:05)
3. Query fundamentals
11 videos 79 minutes 
43 exercises
9. SELECT FROM (8:18)
10. Derived Columns (11:26)
11. Filtering with WHERE (10:29)
12. AND, OR, and NOT (5:09)
13. NULL handling (5:28)
14. IN, BETWEEN, and LIKE (7:13)
15. ORDER BY (8:39)
16. SQL Order of execution (5:25)
17. LIMIT and OFFSET (5:08)
18. DISTINCT (4:34)
19. CASE expressions (7:31)
4. Aggregate functions and grouping
3 videos 27 minutes 14 exercises
20. Common aggregate functions (4:19)
21. GROUP BY and HAVING (11:45)
22. CASE expressions and aggregations (10:46)
5. Understanding data types
4 videos 65 minutes 14 exercises
23. Introduction to data types (14:03)
24. Character data types (11:51)
25. Number data types (19:09)
26. Date and time data types (19:39)
6. Joining data from multiple tables
5 videos 49 minutes 11 exercises
27. Introduction to joins (2:57)
28. Cross joins (8:40)
29. Inner joins (12:26)
30. Outer joins (16:33)
31. Advanced join topics (8:53)
7. Subqueries
5 videos 49 minutes 16 exercises
32. Uncorrelated subqueries (11:00)
33. Correlated subqueries (13:12)
34. Table subqueries (11:43)
35. Lateral subqueries (4:40)
36. Common table expressions (8:14)
8. Window functions
3 videos 30 minutes 8 exercises
37. Ranking window functions (8:56)
38. Aggregate window functions (12:39)
39. LAG and LEAD (8:07)
9. Working with sets
4 videos 22 minutes 8 exercises
40. A little bit of set theory (3:10)
41. UNION (7:40)
42. INTERSECT (4:20)
43. EXCEPT (7:01)
10. Creating tables and constraints
4 videos 54 minutes 14 exercises
44. Creating tables (14:41)
45. Primary keys (17:48)
46. Foreign keys (11:05)
47. CHECK, UNIQUE, and NOT NULL constraints (10:47)
11. Inserting, updating, and deleting data
4 videos 33 minutes 14 exercises
48. Importing and exporting data (10:28)
49. Using transactions and inserting data (9:10)
50. Updating data (8:58)
51. Deleting data (4:28)
12. Views and functions
5 videos 35 minutes 10 exercises
52. Views (7:48)
53. Materialized views (5:44)
54. Functions (2:27)
55. Writing functions with SQL (8:24)
56. Writing functions with PL/pgSQL (10:15)
