What is SQL And Relational Database
What is PostreSQL AKA Postrgres
PostgreSQL Installation (Mac OS)
PostgreSQL Installation (Windows)
GUI Clients vs Terminal/CMD Clients
Setup PSQL (MAC OS)
Setup PSQL (Windows)
How to Create Database
How to Connect to Databases
A Very Dangerous Command
How To Create Tables
Creating Tables Without Constraints
Creating Tables with Constraints
Insert Into
Insert Into Example
Generate 1000 Rows with Mockaroo
Select From
Order By
Distinct
Where Clause and AND
Comparison Operators
Limit, Offset & Fetch
IN
Between
Like And iLike
Group By
Group By Having
Adding New Table And Data Using Mockaroo
Calculating Min, Max & Average
Sum
Basics of Arithmetic Operators
Arithmetic Operators (ROUND)
Alias
Coalesce
NULLIF
Timestamps And Dates Course
Adding And Subtracting With Dates
Age Function
What Are Primary Keys
Understanding Primary Keys
Adding Primary Key
Unique Constraints
Check Constraints
How to Delete Records
How to Update Records
On Conflict Do Nothing
Upsert
What Is A Relationship/Foreign Keys
Adding Relationship Between Tables
Updating Foreign Keys Columns
Inner Joins
Left Joins
Deleting Records With Foreign Keys
Exporting Query Results to CSV
Serial & Sequences
Extensions
Understanding UUID Data Type
UUID As Primary Keys
Conclusion
