Home/Courses/PostgreSQL/PostgreSQL Fundamentals

PostgreSQL Fundamentals🐘

Beginner→Intermediate

PostgreSQL 18

Master relational database concepts with PostgreSQL 18. From your first query to complex joins and aggregations, build a solid foundation in SQL and database design.

6

Sections

19

Lessons

19

Challenges

Start this free course

Start learning PostgreSQL Fundamentals

19 lessons and 19 challenges, all 100% free.

Start this course

What is PostgreSQL?

Installing PostgreSQL

PostgreSQL Architecture(Sign in required)

Beginner+10 Mana

Your First Database

Listing Tables(Sign in required)

Beginner+10 Mana

Auto-Incrementing Columns(Sign in required)

Beginner+10 Mana

PostgreSQL Data Types

Precise Decimal Storage(Sign in required)

Beginner+10 Mana

Querying Data with SELECT

Checking for NULL(Sign in required)

Beginner+10 Mana

Updating and Deleting Data

Safe UPDATE Practices(Sign in required)

Beginner+10 Mana

Getting Inserted ID(Sign in required)

Intermediate+20 Mana

Aggregate Functions

Grouping with GROUP BY

Counting Unique Values(Sign in required)

Beginner+10 Mana

DISTINCT and Expressions

WHERE vs HAVING(Sign in required)

Intermediate+20 Mana

Query Execution Order(Sign in required)

Intermediate+20 Mana

Primary and Foreign Keys

Choosing the Right JOIN(Sign in required)

Beginner+10 Mana

LEFT, RIGHT, and FULL OUTER JOINs

ON DELETE Actions(Sign in required)

Intermediate+20 Mana

INNER JOIN Result(Sign in required)

Intermediate+20 Mana

Common Table Expressions (CTEs)

CTE Syntax(Sign in required)

Beginner+10 Mana

Window Functions

Window Function Partitioning(Sign in required)

Intermediate+20 Mana

Window Functions Matching(Sign in required)

Intermediate+20 Mana

Creating and Using Views

Understanding Indexes

View Benefits(Sign in required)

Beginner+10 Mana

Query Analysis with EXPLAIN

Multi-Column Index Usage(Sign in required)

Intermediate+20 Mana

EXPLAIN Scan Types(Sign in required)

Intermediate+20 Mana

Ready to start this free course?

No credit card required.

Start this course now

Ready to start PostgreSQL Fundamentals?

19 interactive lessons and 19 hands-on challenges — learn in VS Code, Cursor, or the web.