Beginner's Guide to PostgreSQL

Course Curriculum

Chapter 1: Introduction

Lecture 1: An Introduction to the Course

Lecture 2: Database Overview

Lecture 3: Identities in database tables

Lecture 4: Normalization

Lecture 5: Relationships

Lecture 6: Relationship Types

Lecture 7: Database Management Systems

Lecture 8: PostgreSQL features

Lecture 9: PostgreSQL Windows Installation

Chapter 2: Database Usage Basics

Lecture 1: Connecting to Database Server with pgAdmin III

Lecture 2: Configuring PostgreSQL to Accept External Connections

Lecture 3: Creating Databases

Lecture 4: Creating Tables

Lecture 5: Inserting and viewing data in pgAdmin III

Lecture 6: DataTypes Intro

Lecture 7: Numeric DataTypes in PostgreSQL

Lecture 8: Serial Datatypes For Row Ids

Lecture 9: Character Types

Lecture 10: The Date Datatype

Lecture 11: The time datatype

Lecture 12: Timestamps

Lecture 13: The boolean datatype

Lecture 14: NULL Values

Lecture 15: Requirements

Lecture 16: Car Repair Shop DB Requirements

Lecture 17: Designing the repair shop database Pt1

Lecture 18: Designing the repair shop database Pt2

Lecture 19: Designing the repair shop database Pt3 – choosing datatypes

Lecture 20: Car Repair Shop DB Table and Column Definitions

Lecture 21: Building the Database – Part 1

Lecture 22: Applying constraints to table columns

Lecture 23: Creating relationships between tables in pgAdmin III

Lecture 24: Creating the remaining tables

Lecture 25: Users and Privileges

Lecture 26: Backup and Restore in PostgreSQL with pgAdmin III

Chapter 3: SQL in PostgreSQL

Lecture 1: Introduction to SQL

Lecture 2: The CREATE TABLE command

Lecture 3: The CREATE TABLE command with constraints PT 1

Lecture 4: The CREATE TABLE command with constraints pt.2

Lecture 5: Script: First Two Create Table commands

Lecture 6: The CREATE TABLE command with foreign keys PT 1

Lecture 7: The CREATE TABLE command with foreign keys PT 2

Lecture 8: Scripts: Create Tables with Foreign keys

Lecture 9: Drop Table

Lecture 10: The Alter Table command

Lecture 11: Script: Drop And Alter Table commands

Lecture 12: Insert Into SQL Command

Lecture 13: Insert scripts used in the previous video

Lecture 14: The Update Statement

Lecture 15: Update Script file

Lecture 16: The DELETE FROM Statement

Lecture 17: Deletes with cascades

Lecture 18: Script: Delete from commands for the previous videos

Lecture 19: The TRUNCATE command

Lecture 20: Truncate Script

Lecture 21: Filling the database with data

Lecture 22: Full Db Script

Lecture 23: The SELECT command

Lecture 24: pgAdmin III's Graphical Query Builder

Lecture 25: The WHERE clause (PT I)

Lecture 26: The WHERE clause (PT 2) – BETWEEN and IN

Lecture 27: The WHERE clause (PT 3) – IS [NOT] NULL

Lecture 28: The WHERE clause (PT 4) – LIKE and ILIKE

Lecture 29: The WHERE clause – using the graphical query builder

Lecture 30: The WHERE Clause Command Script

Lecture 31: The LIMIT and OFFSET clauses

Lecture 32: The ORDER BY clause

Lecture 33: Order By commands

Lecture 34: Aggregate functions – Count, Max, Min, Avg

Lecture 35: Joins tables in a query through relationships