Introduction
  • An Introduction to the Course
  • Database Overview
  • Identities in database tables
  • Normalization
  • Relationships
  • Relationship Quiz
  • Relationship Types
  • Relationship Types Quiz
  • Database Management Systems
  • PostgreSQL features
  • PostgreSQL Windows Installation
Database Usage Basics
  • Connecting to Database Server with pgAdmin III
  • Configuring PostgreSQL to Accept External Connections
  • Creating Databases
  • Creating Tables
  • Inserting and viewing data in pgAdmin III
  • DataTypes Intro
  • Numeric DataTypes in PostgreSQL
  • Serial Datatypes For Row Ids
  • Character Types
  • The Date Datatype
  • The time datatype
  • Timestamps
  • The boolean datatype
  • NULL Values
  • Requirements
  • Car Repair Shop DB Requirements
  • Designing the repair shop database Pt1
  • Designing the repair shop database Pt2
  • Designing the repair shop database Pt3 - choosing datatypes
  • Car Repair Shop DB Table and Column Definitions
  • Building the Database - Part 1
  • Applying constraints to table columns
  • Creating relationships between tables in pgAdmin III
  • Creating the remaining tables
  • Users and Privileges
  • Backup and Restore in PostgreSQL with pgAdmin III
SQL in PostgreSQL
  • Introduction to SQL
  • The CREATE TABLE command
  • The CREATE TABLE command with constraints PT 1
  • The CREATE TABLE command with constraints pt.2
  • Script: First Two Create Table commands
  • The CREATE TABLE command with foreign keys PT 1
  • The CREATE TABLE command with foreign keys PT 2
  • Scripts: Create Tables with Foreign keys
  • CREATE TABLE quiz
  • Drop Table
  • The Alter Table command
  • Script: Drop And Alter Table commands
  • Insert Into SQL Command
  • Insert scripts used in the previous video
  • The Update Statement
  • Update Script file
  • The DELETE FROM Statement
  • Deletes with cascades
  • Script: Delete from commands for the previous videos
  • The TRUNCATE command
  • Truncate Script
  • Filling the database with data
  • Full Db Script
  • The SELECT command
  • pgAdmin III's Graphical Query Builder
  • The WHERE clause (PT I)
  • The WHERE clause (PT 2) - BETWEEN and IN
  • The WHERE clause (PT 3) - IS [NOT] NULL
  • The WHERE clause (PT 4) - LIKE and ILIKE
  • The WHERE clause - using the graphical query builder
  • The WHERE Clause Command Script
  • The LIMIT and OFFSET clauses
  • QUIZ - Limits and Offests
  • The ORDER BY clause
  • Order By commands
  • Aggregate functions - Count, Max, Min, Avg
  • Joins tables in a query through relationships