Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Relational Database and SQL Essentials
Getting Started
Join the Community
Before we start (1:16)
Newsletter
Exercise Files
What is a Database (3:47)
SQL - Structured Query Language (1:24)
SQL And Relational Databases (3:53)
Postgres (2:26)
Setup
Download Postgres (MAC OS) (3:31)
Download Postgres (Windows) (3:20)
GUI Client vs Terminal/CMD Client (4:05)
Set PSQL (Mac) (3:42)
Learn SQL the right way (1:17)
Creating Database
Creating a database (3:23)
Connecting to databases (4:38)
A very dangerous command (3:28)
Creating Tables
Create Table Syntax & Datatypes (4:13)
Create Table Without Constraints (3:35)
Create Table With Constraints (6:54)
Inserting & Querying Data
How to insert (Keynote) (3:15)
Inserting Data (3:26)
Retrieving Data (2:54)
Adding One Thousand Records (9:56)
Sorting Data (4:37)
Distinct keyword (2:09)
Filtering Data
Where Clause & AND (3:32)
Comparison Operators (4:02)
Limit, Offset & Fetch (3:15)
In (3:01)
Between (2:06)
LIKE/ILIKE (5:38)
Grouping Data
Group By (3:31)
Having (5:31)
Creating New Table (3:38)
Min Max Avg (4:13)
Sum (2:07)
Operators
The Basics of Arithmetic Operators (4:08)
Arithmetic Operations On Tables (3:44)
Aliases (2:52)
Handling Nulls
Coalesce (3:44)
Division By Zero with NULLIF (4:10)
Working With Dates
Timestamps & Dates (3:07)
Adding and Subtracting Dates With Interval (2:43)
Extracting Fields From Timestamp (1:30)
Age Function (2:01)
Understanding PostgreSQL Constraints
What Are Primary Keys (2:05)
Working With Primary Keys (5:10)
Adding Primary Key Constraint (4:36)
Unique Constraints (8:20)
Check Constraints (5:33)
Modifying Data
Deleting Records (6:51)
Updating Records (4:23)
Handling Conflicts (5:16)
Upsert with ON CONFLICT DO UPDATE (5:38)
Relationships
Understanding Foreign Keys / Relationships (3:12)
Adding Relationship (FOREIGN KEY) (5:25)
Updating Foreign Key Columns (4:38)
Inner Joins (5:50)
Left Joins (5:43)
Deleting Records With Foreign Key (6:44)
Exporting to CSV
Exporting Query Results to CSV (3:18)
Sequences, Extensions & UUID
Understanding Sequences (6:39)
PosgtreSQL Extensions (2:20)
Generating UUIDs (6:26)
Using UUID's (10:44)
Next steps
Next steps (2:38)
Database Design Course Promo (1:49)
Before we start
Download
Complete and Continue
1 - Follow us on
LinkedIn
2 - Subscribe to our Newsletter