Course Introduction
- Course Introduction
- A Few Notes on this Course
Introduction to Databases, SQL and PostgreSQL
- What is a Database?
- Relational Databases and SQL
- Installing PostgreSQL for Mac
- Installing PostgreSQL for Windows
SQL & PostgreSQL : Data Definition Language - Creating Our Movie Database
- Section Introduction
- Database Tables
- Data Types Explained
- Primary Keys and Foreign Keys
- Unique, Not Null and Check Constraints
- Creating Our First Table
- Creating the Actors Table
- Creating a Table with a Foreign Key
- Creating the Movie Revenues Table
- Creating a Junction Table
- Modifying Tables Part 1: Adding Columns
- Modifying Tables Part 2: Changing a Columns Data Type
- Deleting Tables from a Database
- Challenge: Data Definition Language
- Solution: Data Definition Language
- Section Summary
SQL & PostgreSQL: Data Manipulation Language
- Section Introduction
- Inserting Data into a Table
- Updating Data in a Table
- Deleting Data from a Table
- Inserting Data into Our Movie Data Database
- Challenge: Data Manipulation Language
- Solution: Data Manipulation Language
- Section Summary
SQL & PostgreSQL : Retrieving Data from a Table - Select Queries
- Section Introduction
- Select Queries
- Where Clauses
- Logical Operators
- Challenge 1: Select Queries
- Solution 1: Select Queries
- In, Not In
- Like
- Between
- Challenge 2: Select Queries
- Solution 2: Select Queries
- Order By
- Limiting the Number of Results
- Fetch
- Distinct Values
- Challenge 3: Select Queries
- Solution 3: Select Queries
- Null Values
- Setting a Column Name Alias
- Concatenation
- Challenge 4: Select Queries
- Solution 4: Select Queries
- Section Summary
SQL & PostgreSQL : Aggregate Functions and Grouping Data
- Section Introduction
- Aggregate Functions Explained
- Count Aggregate Functions
- Sum Aggregate Function
- Min and Max Aggregate Functions
- Average Aggregate Functions
- Challenge 1: Aggregate Functions
- Solution 1: Aggregate Functions
- Grouping Data
- Having Clauses
- Challenge 2: Aggregate Functions
- Solution 2: Aggregate Functions
- Mathematical Operators
- Section Summary
Database Relationships
- Section Introduction
- What Are Database Relationships?
- One to One Relationships
- One to Many Relationships
- Many to Many Relationships
- (Optional) Challenge: Database Relationships
- Solution: Database Relationships
- Section Summary
SQL & PostgreSQL: Joining Tables
- Section Introduction
- SQL Joins Explained
- Inner Joins Part 1
- Inner Joins Part 2
- Inner Joins Part 3
- Challenge 1: Joins
- Solution 1: Joins
- Left Joins
- Right Joins
- Full Joins
- Challenge 2: Joins
- Solutions 2: Joins
- Joining More Than Two Tables
- Challenge 3: Joins
- Solution 3: Joins
- Union
- Union All
