PostgreSQL
Course Index
45 Lessons · 4 Levels
Complete PostgreSQL roadmap — from database fundamentals to advanced SQL, indexes, transactions, JSON, stored procedures and PostgreSQL on AWS RDS.
45Lessons
4Levels
1Project
FreeAccess
Level I
Foundations Level
Lessons 1–12
Lesson 01
Introduction to Databases
Lesson 02
SQL vs NoSQL Databases
Lesson 03
What is PostgreSQL
Lesson 04
PostgreSQL Features & Advantages
Lesson 05
Installing PostgreSQL
Lesson 06
PostgreSQL Architecture
Lesson 07
PostgreSQL Tools (psql & pgAdmin)
Lesson 08
Creating Databases & Schemas
Lesson 09
PostgreSQL Data Types
Lesson 10
Creating Tables
Lesson 11
Constraints & Keys
Lesson 12
NOT NULL, DEFAULT & CHECK
Level II
Core SQL Level
Lessons 13–26
Lesson 13
Altering Tables
Lesson 14
Drop & Truncate Tables
Lesson 15
Identity Columns & Sequences
Lesson 16
INSERT Data
Lesson 17
SELECT Queries
Lesson 18
WHERE & Filtering
Lesson 19
ORDER BY, LIMIT & OFFSET
Lesson 20
UPDATE Data
Lesson 21
DELETE Data
Lesson 22
RETURNING Clause
Lesson 23
Aggregate Functions
Lesson 24
GROUP BY
Lesson 25
HAVING Clause
Lesson 26
NULL Handling
Level III
Advanced SQL & Performance
Lessons 27–38
Lesson 27
Table Relationships
Lesson 28
INNER JOIN
Lesson 29
LEFT, RIGHT & FULL JOIN
Lesson 30
Subqueries
Lesson 31
Views
Lesson 32
Materialized Views
Lesson 33
String Functions
Lesson 34
Date & Time Functions
Lesson 35
CASE Expressions
Lesson 36
Indexes
Lesson 37
Transactions & ACID
Lesson 38
Locks & Concurrency
Level IV
Enterprise & Cloud Level
Lessons 39–45