Up and Running With PostgreSQL 11

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome

Lecture 2: What is a database

Lecture 3: SQL and Relational Databases

Lecture 4: What is PostreSQL AKA Postrgres

Lecture 5: Postgres Installation (MAC OS)

Lecture 6: Postgres Installation (Windows)

Lecture 7: Setting up PSQL (MAC OS)

Lecture 8: Setting up PSQL (Windows)

Chapter 2: Creating databases and tables

Lecture 1: Creating a database

Lecture 2: Connecting to databases

Lecture 3: A very dangerous command

Lecture 4: Create table syntax + Datatypes

Lecture 5: Create Table Without Constraints

Lecture 6: Create Table With Constraints

Chapter 3: Insert and Querying records

Lecture 1: How to Insert Data (Keynote)

Lecture 2: Insert Into

Lecture 3: Select From

Lecture 4: Inserting One Thousand Records

Lecture 5: Sorting

Lecture 6: Removing Duplicates with Distinct Keyword

Chapter 4: Filtering Data

Lecture 1: Where and And

Lecture 2: Comparison Operators

Lecture 3: Limit, Offset and Fetch

Lecture 4: In keyword

Lecture 5: Between Keyword

Lecture 6: Like and ILike

Chapter 5: Grouping Data

Lecture 1: Group By

Lecture 2: Having

Lecture 3: Adding a second table

Lecture 4: Min, Max and Avg

Lecture 5: Sum

Chapter 6: Operators

Lecture 1: Arithmetic Operators

Lecture 2: Arithmetic Operators On Tables

Lecture 3: Aliases

Chapter 7: Handing Nulls

Lecture 1: Coalesce

Lecture 2: Handle Division by 0 with NULL IF

Chapter 8: Working with Dates

Lecture 1: Timestamp and Date

Lecture 2: Adding and Subtracting Dates With INTERVAL

Lecture 3: Extracting Fields From TIMESTAMP

Lecture 4: Age Function

Chapter 9: PostgreSQL Constraints

Lecture 1: Primary Keys

Lecture 2: Understanding primary keys and Dropping PK Constraint

Lecture 3: Adding Primary Constraint

Lecture 4: Unique Constraints

Lecture 5: Check Constraints

Chapter 10: Modifying Data

Lecture 1: Deleting Records

Lecture 2: Updating Records

Lecture 3: On Conflict Do Nothing

Lecture 4: Upsert (On Conflict Do Update)

Chapter 11: Relationships and Joins

Lecture 1: Relationships and Joins (Diagram)

Lecture 2: Adding Relationships (Foreign Key)

Lecture 3: Updating Foreign Key Columns

Lecture 4: Inner Join

Lecture 5: Left Join

Lecture 6: Deleting Records With Foreign Keys

Chapter 12: Sequences and Extensions

Lecture 1: Exporting Query Results To CSV

Lecture 2: Sequences

Lecture 3: PosgtreSQL Extensions

Lecture 4: Generating UUIDs

Lecture 5: Using UUID's as Primary Keys