Learn SQL Using PostgreSQL: From Zero to Hero

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Installing PostgreSQL and pgAdmin

Lecture 1: Installing PostgreSQL on Mac

Lecture 2: Installing PostgreSQL on Windows

Lecture 3: Installing PostgreSQL on Ubuntu

Lecture 4: Install Northwind Database

Lecture 5: Install Some Additional Databases.

Chapter 3: Simple Selection of All Records

Lecture 1: Selecting All Data From a Table

Lecture 2: Selecting Specific Fields

Lecture 3: Selecting Distinct Values

Lecture 4: Counting Results

Lecture 5: Combining Fields in SELECT

Lecture 6: Practice What You've Learned

Chapter 4: Using WHERE to Select Records

Lecture 1: What If You Don't Want All Records

Lecture 2: Searching For Specific Text

Lecture 3: Searching Numeric Fields

Lecture 4: Searching Date Fields

Lecture 5: WHERE Using Logical AND Operator

Lecture 6: WHERE Using Logical OR Operator

Lecture 7: WHERE Using Logical NOT Operator

Lecture 8: WHERE Combining AND, OR, and NOT

Lecture 9: Using BETWEEN

Lecture 10: Using IN

Lecture 11: Practice What You've Learned

Chapter 5: Schemas

Lecture 1: Schema Basics

Chapter 6: Using psql To Connect To Postgres

Lecture 1: Connecting With psql

Lecture 2: Eliminate Typing Connection Parameters

Lecture 3: Databases In psql

Lecture 4: Schemas In psql

Chapter 7: Intermediate SELECT Statements

Lecture 1: ORDER BY

Lecture 2: Using MIN and MAX Functions

Lecture 3: Using AVG and SUM

Lecture 4: LIKE to Match Patterns

Lecture 5: Renaming Columns With Alias

Lecture 6: LIMIT to Control Number of Records Returned

Lecture 7: NULL Values

Lecture 8: Practice What You've Learned

Chapter 8: Joining multiple tables together

Lecture 1: Diagramming Table Relationships

Lecture 2: Grabbing Information From Two Tables

Lecture 3: Grabbing Information From Multiple Tables

Lecture 4: Left Joins

Lecture 5: Right Joins

Lecture 6: Full Joins

Lecture 7: Self Joins

Lecture 8: USING To Reduce Typing

Lecture 9: Even Less Typing With NATURAL

Lecture 10: Practice What You've Learned

Chapter 9: Grouping and Aggregation Functions

Lecture 1: Group By

Lecture 2: Use HAVING to Filter Groups

Lecture 3: Grouping Sets

Lecture 4: Rollup

Lecture 5: Cube – Rollup On Steroids

Chapter 10: Combining Queries

Lecture 1: Union

Lecture 2: Intersect

Lecture 3: Except

Chapter 11: Subqueries

Lecture 1: Subquery Using EXISTS

Lecture 2: Subquery Using ANY and ALL

Lecture 3: IN Using Subquery

Chapter 12: Modifying Data In Tables: INSERT, UPDATE and DELETE

Lecture 1: INSERT INTO

Lecture 2: UPDATE

Lecture 3: DELETE

Lecture 4: SELECT INTO

Lecture 5: INSERT INTO SELECT

Lecture 6: Returning Data From Update, Delete, and Insert

Chapter 13: Indexes and Performance Tuning

Lecture 1: What Are Indexes?

Lecture 2: CREATE INDEX

Lecture 3: DROP INDEX

Lecture 4: How To Kill Runaway Queries

Lecture 5: Using Explain To See Query Plan

Lecture 6: Use Analyze To Update Table Statistics

Lecture 7: How Is Query Plan Cost Calculated

Lecture 8: Using Indexes On More Than One Field

Lecture 9: Expression Indexes

Lecture 10: Types Of Indexes

Lecture 11: Speeding Up Text Matching

Chapter 14: Database Design and Normalization

Lecture 1: Design Process Overview

Lecture 2: Database Terminology

Lecture 3: A Design Process

Lecture 4: Finding Mission Statement And Ojectives

Lecture 5: Analyzing Current Systems

Lecture 6: Create Table Structure

Lecture 7: Establishing Keys

Lecture 8: Specifying Fields

Lecture 9: Relationships Between Tables

Lecture 10: Business Rules

Lecture 11: Establish Needed Views

Lecture 12: Double Checking Data Integrity