The Complete SQL Bootcamp: Go from Zero to Hero

Course Curriculum

Chapter 1: Course Introduction

Lecture 1: Welcome Message

Lecture 2: Introduction

Lecture 3: Course Curriculum Overview

Lecture 4: Overview of Databases

Lecture 5: Course FAQs

Lecture 6: Windows Installation – PostGreSQL and PgAdmin with Database Setup

Lecture 7: MacOS Installation – PostgreSQL and PgAdmin with First Query

Lecture 8: pgAdmin Overview

Chapter 2: SQL Statement Fundamentals

Lecture 1: Overview of Challenges!

Lecture 2: SQL Cheat Sheet

Lecture 3: SQL Statement Fundamentals

Lecture 4: SELECT Statement

Lecture 5: Challenge: SELECT

Lecture 6: SELECT DISTINCT

Lecture 7: Challenge: SELECT DISTINCT

Lecture 8: COUNT

Lecture 9: SELECT WHERE – Part One

Lecture 10: SELECT WHERE – Part Two

Lecture 11: Challenge: SELECT WHERE

Lecture 12: ORDER BY

Lecture 13: LIMIT

Lecture 14: Challenge: ORDER BY

Lecture 15: BETWEEN

Lecture 16: IN

Lecture 17: LIKE and ILIKE

Lecture 18: General Challenge 1

Chapter 3: GROUP BY Statements

Lecture 1: Introduction to GROUP BY

Lecture 2: Aggregation Functions

Lecture 3: GROUP BY – Part One

Lecture 4: GROUP BY – Part Two

Lecture 5: GROUP BY – Challenge

Lecture 6: HAVING

Lecture 7: HAVING – Challenge Tasks

Chapter 4: Assessment Test 1

Lecture 1: Overview of Assessment Test 1

Lecture 2: Assessment Test 1

Lecture 3: Solutions to Assessment Test 1

Chapter 5: JOINS

Lecture 1: Overview of JOINS

Lecture 2: Introduction to JOINs

Lecture 3: AS Statement

Lecture 4: Inner Joins

Lecture 5: Full Outer Joins

Lecture 6: Left Outer Join

Lecture 7: Right Joins

Lecture 8: UNION

Lecture 9: JOIN Challenge Tasks

Chapter 6: Advanced SQL Commands

Lecture 1: Overview of Advanced SQL Commands

Lecture 2: Timestamps and Extract – Part One

Lecture 3: Timestamps and Extract – Part Two

Lecture 4: Quick Note on TO_CHAR

Lecture 5: Timestamps and Extract – Challenge Tasks

Lecture 6: Mathematical Functions and Operators

Lecture 7: String Functions and Operators

Lecture 8: SubQuery

Lecture 9: Self-Join

Chapter 7: Assessment Test 2

Lecture 1: READ ME FIRST PLEASE

Lecture 2: Setting up New Database for Assessment Exercises

Lecture 3: Assessment Test 2

Lecture 4: Solutions to Assessment Test 2

Chapter 8: Creating Databases and Tables

Lecture 1: Introduction to Section

Lecture 2: Data Types

Lecture 3: Primary Keys and Foreign Keys

Lecture 4: Constraints

Lecture 5: CREATE Table

Lecture 6: INSERT

Lecture 7: UPDATE

Lecture 8: DELETE

Lecture 9: ALTER Table

Lecture 10: DROP Table

Lecture 11: CHECK Constraint

Chapter 9: Assessment Test 3

Lecture 1: Assessment Test 3

Lecture 2: Solutions to Assessment Test 3

Chapter 10: Conditional Expressions and Procedures

Lecture 1: Conditional Expressions and Procedures Introduction

Lecture 2: CASE

Lecture 3: CASE – Challenge Task

Lecture 4: COALESCE

Lecture 5: CAST

Lecture 6: NULLIF

Lecture 7: Views

Lecture 8: Import and Export

Chapter 11: Extra: PostGreSQL with Python

Lecture 1: Overview of Python and PostgreSQL

Lecture 2: Psycopg2 Example Usage

Lecture 3: Psycopg2 Resources

Chapter 12: BONUS SECTION: THANK YOU!

Lecture 1: Bonus Lecture