Section 1 : Course Introduction

Lecture 1 Welcome Message Text
Lecture 2 Introduction 2:5
Lecture 3 Course Curriculum Overview 1:41
Lecture 4 Overview of Databases 7:37
Lecture 5 Course FAQs Text
Lecture 6 Time to get your Computer Set-Up Text
Lecture 7 Windows Installation - PostGreSQL and PgAdmin with 19:38
Lecture 8 MacOS Installation - PostgreSQL and PgAdmin with F 21:54
Lecture 9 pgAdmin Overview 9:38

Section 2 : SQL Statement Fundamentals

Lecture 10 Overview of Challenges 1:36
Lecture 11 SQL Cheat Sheet Text
Lecture 12 SQL Statement Fundamentals 0:42
Lecture 13 SELECT Statement 8:35
Lecture 14 Challenge SELECT 4:24
Lecture 15 SELECT DISTINCT
Lecture 16 Challenge SELECT DISTINCT 1:48
Lecture 17 COUNT 7:14
Lecture 18 SELECT WHERE - Part One 4:25
Lecture 19 SELECT WHERE - Part Two 6:59
Lecture 20 Challenge SELECT WHERE 5:28
Lecture 21 ORDER BY 8:5
Lecture 22 LIMIT 4:59
Lecture 23 Challenge ORDER BY 4:55
Lecture 24 BETWEEN 6:49
Lecture 25 IN 4:49
Lecture 26 LIKE and ILIKE. 9:30
Lecture 27 General Challenge 9:53

Section 3 : GROUP BY Statements

Lecture 28 Introduction to GROUP BY. 0:50
Lecture 29 Aggregation Functions 7:51
Lecture 30 GROUP BY - Part One. 7:38
Lecture 31 GROUP BY - Part Two 10:37
Lecture 32 GROUP BY - Challenge 3:55
Lecture 33 HAVING 6:17
Lecture 34 HAVING - Challenge Tasks. 2:42

Section 4 : Assessment Test 1

Lecture 35 Overview of Assessment Test 1:8
Lecture 36 Assessment Test 1 Text
Lecture 37 Solutions to Assessment Test 1 Text

Section 5 : JOINS

Lecture 38 Overview of JOINS Text
Lecture 39 Introduction to JOINs 1:8
Lecture 40 AS Statement 7:41
Lecture 41 Inner Joins
Lecture 42 Full Outer Joins 14:16
Lecture 43 Left Outer Join
Lecture 44 Right Joins. 4:9
Lecture 45 UNION 2:21
Lecture 46 JOIN Challenge Tasks 12:8

Section 6 : Advanced SQL Commands

Lecture 47 Overview of Advanced SQL Commands 0:40
Lecture 48 Timestamps and Extract - Part One. 7:31
Lecture 49 Timestamps and Extract - Part Two 9:56
Lecture 50 Quick Note on TO_CHAR Text
Lecture 51 Timestamps and Extract - Challenge Tasks 3:29
Lecture 52 athematical Functions and Operators 4:53
Lecture 53 String Functions and Operators
Lecture 54 SubQuery.mp4 15:1
Lecture 55 Self-Join 10:48

Section 7 : Assessment Test 2

Lecture 56 READ ME FIRST PLEASE Text
Lecture 57 Setting up New Database for Assessment Exercises 7:16
Lecture 58 Assessment Test 2 Text
Lecture 59 Solutions to Assessment 23:36

Section 8 : Creating Databases and Tables

Lecture 60 Introduction to Section 1:5
Lecture 61 Data Types 6:18
Lecture 62 Primary Keys and Foreign Keys 8:51
Lecture 63 Constraints 5:4
Lecture 64 CREATE Table 18:14
Lecture 65 INSERT 8:56
Lecture 66 UPDATE 7:50
Lecture 67 DELETE 3:6
Lecture 68 ALTER Table 6:40
Lecture 69 DROP Table 3:9
Lecture 70 CHECK Constraint 7:4

Section 9 : Assessment Test 3

Lecture 71 Assessment Test 3 Text
Lecture 72 Solutions to Assessment Test 3 Text

Section 10 : Conditional Expressions and Procedures

Lecture 73 Conditional Expressions and Procedures Introduct 0:36
Lecture 74 CASE 22:34
Lecture 75 CASE - Challenge Task 3:3
Lecture 76 COALESCE 5:28
Lecture 77 CAST 7:1
Lecture 78 NULLIF
Lecture 79 Views 6:59
Lecture 80 Import and Export 13:22

Section 11 : Extra PostGreSQL with Python

Lecture 81 Overview of Python and PostgreSQL Text
Lecture 82 Psycopg2 Example Usage 10:24
Lecture 83 Psycopg2 Resources Text