PostgreSQL: SQL & PostgreSQL from Scratch
Master PostgreSQL from scratch — sql & postgresql from scratch.
What you'll learn
By the end you can confidently apply PostgreSQL at a beginner level: sql & postgresql from scratch, with real, working code.
Who it's for
Developers learning PostgreSQL at a beginner level.
Prerequisites
Basic SQL helps but not required.
A structured, hands-on beginner course on PostgreSQL, taking you from scratch by building a normalized schema for a store app.
Curriculum
- 1
Introduction to the Relational Model
4 min - 2
Setting Up Your PostgreSQL Environment
4 min - 3
Creating Your Store Database
3 min - 4
Designing the Products Table
4 min - 5
Building the Customers Table
4 min - 6
Introduction to SELECT Queries
4 min - 7
Filtering Data with WHERE
4 min - 8
Advanced Filtering Operators
4 min - 9
Sorting Query Results
4 min - 10
Limiting and Offsetting Results
3 min - 11
Understanding Primary Keys
4 min - 12
Implementing Foreign Keys
4 min - 13
Applying NOT NULL and UNIQUE Constraints
4 min - 14
Using CHECK Constraints
4 min - 15
Normalizing the Store Schema
4 min - 16
Inserting Records into Tables
4 min - 17
Updating Existing Records
4 min - 18
Deleting Records Safely
4 min - 19
Introduction to Transactions
4 min - 20
Advanced Transaction Management
4 min - 21
Understanding INNER JOIN
4 min - 22
Working with LEFT JOIN
4 min - 23
Introduction to Aggregate Functions
4 min - 24
Grouping Data with GROUP BY
4 min - 25
Filtering Groups with HAVING
3 min - 26
Using JSONB for Flexible Data
4 min - 27
Working with UUIDs
3 min - 28
Handling Timestamps
4 min - 29
Establishing Naming Conventions
4 min - 30
Database Documentation Standards
4 min - 31
Reviewing the Store Application
4 min - 32
String Manipulation Functions
4 min - 33
Working with Patterns and LIKE
4 min - 34
Boolean Logic in Queries
4 min - 35
COALESCE and Handling NULLs
4 min - 36
Subqueries in WHERE Clauses
4 min - 37
Introduction to Views
4 min - 38
Managing Table Schemas
4 min - 39
Understanding Indexes
3 min - 40
Advanced Indexing Strategies
4 min - 41
Using Sequences for IDs
5 min - 42
Exporting and Importing Data
4 min - 43
Database Security Basics
4 min - 44
Analyzing Query Plans
4 min - 45
Working with Schema Namespaces
3 min - 46
Using DISTINCT for Clean Data
4 min - 47
Common Table Expressions (CTEs)
4 min - 48
Advanced Window Functions
4 min - 49
Dealing with Time Zones
4 min - 50
Recursive Queries
4 min - 51
Database Constraints Refinement
3 min - 52
Performance Tuning Checklists
4 min - 53
Introduction to Stored Procedures
4 min - 54
Creating Triggers
4 min - 55
Working with Arrays
3 min - 56
Full-Text Search Basics
4 min - 57
Database Maintenance Tasks
4 min