Course Introduction
- Welcome Message
- Introduction
- Course Curriculum Overview
- Overview of Databases
- Course FAQs
- Windows Installation - PostGreSQL and PgAdmin with Database Setup
- MacOS Installation - PostgreSQL and PgAdmin with First Query
- pgAdmin Overview
SQL Statement Fundamentals
- Overview of Challenges!
- SQL Cheat Sheet
- SQL Statement Fundamentals
- SELECT Statement
- Challenge: SELECT
- SELECT DISTINCT
- Challenge: SELECT DISTINCT
- COUNT
- SELECT WHERE - Part One
- SELECT WHERE - Part Two
- Challenge: SELECT WHERE
- ORDER BY
- LIMIT
- Challenge: ORDER BY
- BETWEEN
- IN
- LIKE and ILIKE
- General Challenge 1
GROUP BY Statements
- Introduction to GROUP BY
- Aggregation Functions
- GROUP BY - Part One
- GROUP BY - Part Two
- GROUP BY - Challenge
- HAVING
- HAVING - Challenge Tasks
Assessment Test 1
- Overview of Assessment Test 1
- Assessment Test 1
- Solutions to Assessment Test 1
JOINS
- Overview of JOINS
- Introduction to JOINs
- AS Statement
- Inner Joins
- Full Outer Joins
- Left Outer Join
- Right Joins
- UNION
- JOIN Challenge Tasks
Advanced SQL Commands
- Overview of Advanced SQL Commands
- Timestamps and Extract - Part One
- Timestamps and Extract - Part Two
- Quick Note on TO_CHAR
- Timestamps and Extract - Challenge Tasks
- Mathematical Functions and Operators
- String Functions and Operators
- SubQuery
- Self-Join
Assessment Test 2
- READ ME FIRST PLEASE
- Setting up New Database for Assessment Exercises
- Assessment Test 2
- Solutions to Assessment Test 2
Creating Databases and Tables
- Introduction to Section
- Data Types
- Primary Keys and Foreign Keys
- Constraints
- CREATE Table
- INSERT
- UPDATE
- DELETE
- ALTER Table
- DROP Table
- CHECK Constraint
Assessment Test 3
- Assessment Test 3
- Solutions to Assessment Test 3
Conditional Expressions and Procedures
- Conditional Expressions and Procedures Introduction
- CASE
- CASE - Challenge Task
- COALESCE
- CAST
- NULLIF
- Views
- Import and Export
Extra: PostGreSQL with Python
- Overview of Python and PostgreSQL
- Psycopg2 Example Usage
- Psycopg2 Resources
BONUS SECTION: THANK YOU!
- Bonus Lecture
