Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Beginner's Guide to PostgreSQL
Introduction
An Introduction to the Course (2:19)
Database Overview (5:15)
Identities in database tables (2:45)
Normalization (4:10)
Relationships (7:00)
Relationship Quiz
Relationship Types (5:47)
Relationship Types Quiz
Database Management Systems (3:14)
PostgreSQL features (3:34)
PostgreSQL Windows Installation (5:40)
Database Usage Basics
Connecting to Database Server with pgAdmin III (3:30)
Configuring PostgreSQL to Accept External Connections (7:29)
Creating Databases (6:21)
Creating Tables (6:59)
Inserting and viewing data in pgAdmin III (9:46)
DataTypes Intro (1:19)
Numeric DataTypes in PostgreSQL (10:58)
Serial Datatypes For Row Ids (4:34)
Character Types (6:11)
The Date Datatype (5:05)
The time datatype (3:53)
Timestamps (7:28)
The boolean datatype (2:36)
NULL Values (5:05)
Requirements (2:23)
Car Repair Shop DB Requirements
Designing the repair shop database Pt1 (8:06)
Designing the repair shop database Pt2 (4:27)
Designing the repair shop database Pt3 - choosing datatypes (2:42)
Car Repair Shop DB Table and Column Definitions
Building the Database - Part 1 (7:25)
Applying constraints to table columns (8:03)
Creating relationships between tables in pgAdmin III (5:08)
Creating the remaining tables (12:34)
Users and Privileges (14:10)
Backup and Restore in PostgreSQL with pgAdmin III (9:06)
SQL in PostgreSQL
Introduction to SQL (2:49)
The CREATE TABLE command (5:48)
The CREATE TABLE command with constraints PT 1 (6:29)
The CREATE TABLE command with constraints pt.2 (3:56)
Script: First Two Create Table commands
The CREATE TABLE command with foreign keys PT 1 (4:01)
The CREATE TABLE command with foreign keys PT 2 (5:18)
Scripts: Create Tables with Foreign keys
CREATE TABLE quiz
Drop Table (4:22)
The Alter Table command (12:48)
Script: Drop And Alter Table commands
Insert Into SQL Command (9:30)
Insert scripts used in the previous video
The Update Statement (15:30)
Update Script file
The DELETE FROM Statement (5:09)
Deletes with cascades (8:02)
Script: Delete from commands for the previous videos
The TRUNCATE command (5:08)
Truncate Script
Filling the database with data (4:04)
Full Db Script
The SELECT command (3:30)
pgAdmin III's Graphical Query Builder (2:39)
The WHERE clause (PT I) (4:57)
The WHERE clause (PT 2) - BETWEEN and IN (4:36)
The WHERE clause (PT 3) - IS [NOT] NULL (3:15)
The WHERE clause (PT 4) - LIKE and ILIKE (9:32)
The WHERE clause - using the graphical query builder (10:38)
The WHERE Clause Command Script
The LIMIT and OFFSET clauses (5:23)
QUIZ - Limits and Offests
The ORDER BY clause (6:57)
Order By commands
Aggregate functions - Count, Max, Min, Avg (11:10)
Joins tables in a query through relationships
Script: Delete from commands for the previous videos
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock