Menu
CoddyTech
NewJourney

Learn PostgreSQL

A free, interactive PostgreSQL course for complete beginners. Write queries on a real PostgreSQL database, press Run and compare your result with the expected table, with AI hints and a certificate per section.

67 lessons67 challenges225 quiz questions

Syllabus

3 sections2 projects67 lessons67 challenges225 quiz questions
  1. Start sectionStartExpandCollapseRead a catalog, filter rows, calculate useful fields and build a stock report. No programming or database experience required.

    Introduction

    5 lessons515

    Filter the Catalog

    5 lessons520

    Build Useful Results

    5 lessons520

    Project: Catalog Report

    3 lessons35

    Final Challenges

    2 lessons2
  2. Start sectionStartExpandCollapseUse PostgreSQL types and calendar operations, summarize groups, and change data with RETURNING and transactions.

    Types and Casts

    5 lessons520

    Dates and Time

    5 lessons520

    Summarize Rows

    5 lessons520

    Change Data Safely

    5 lessons520

    Final Challenges

    2 lessons2
  3. Start sectionStartExpandCollapseConnect customers and orders, organize multi-stage queries, analyze windows and extract JSONB into complete reports.

    Connect Tables

    5 lessons520

    Queries in Stages

    5 lessons520

    Window Calculations

    5 lessons520

    Work with JSONB

    5 lessons520

    Project: Customer Report

    3 lessons35

    Final Challenges

    2 lessons2
What you get
Everything you'll use to learn to code

Learn by Doing

Write real code, query databases, build websites, and master AI prompts. Our interactive lessons cover every skill modern developers need.

playground.js
Code Editor
1const greeting = "Hello, Coddy!"
2function sayHi(name) {
3    return greeting + " " + name
4}
5
bottombar Collapse icon
Test #1test Case Success icon
Test #2test Case Success icon
Test #3test Case Failure icon
Input
"Alex"
Output
"Hello, Coddy! Alex"

Build Your Streak

Stay consistent and watch your progress grow! Track your daily coding habit, protect your streak with freeze days, and earn rewards for showing up every day.

12 days streak

Return tomorrow to keep your streak!

fire Filled icon
left icon

January 2026

right icon

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

21

22

23

24

25

26

27

28

29

30

product Double Or Nothing icon

Double or Nothing

Day 5 of 7

fire Freeze icon

Streak Freeze

2 left

You're Not Alone

Compete on global leaderboards, invite friends to earn rewards, and celebrate each other's wins. Coding is better with friends!

Challenger League
Challenger LeagueTop 7 advance
leaderboard First icon1
avatar 1 icon
fire Filled icon
Alex7+ Days
2840
leaderboard Second icon2
avatar 2 icon
fire Filled icon
Jordan7+ Days
2650
leaderboard Third icon3
avatar 3 icon
fire Filled icon
Sam7+ Days
2420
4
avatar 4 icon
Casey
2180
5
avatar placeholder icon
fire Filled icon
Morgan7+ Days
1950
leaderboard Arrow Up iconPromotion zoneleaderboard Arrow Up icon

Every way to learn

Read, listen, test yourself, ask the AI, or look up anything you've already covered. Every lesson meets you where you are.

Intro to Variables
Audio

A variable is a named container that stores a value you can reference later in your program.

In Python, you create one by writing the name, an equals sign, then the value you want to store.

The value can change over time. Reassigning the name simply points it to a new value.

1xSarah

Earn a Certificate

Earn certificates for every course you complete. Add them to your LinkedIn profile and resume to showcase your coding expertise to employers.

CoddyCertificate of Completion
This certifies thatJohn Doehas successfully completed
python iconPython Fundamentals
Verified
DateJan 2026
LinkedInAdd to LinkedIn

Why learn PostgreSQL with Coddy

  • Every query runs on a real PostgreSQL database. The input tables, your result and the expected result sit side by side, every run starts from fresh data, and a mistake shows PostgreSQL's own error message, the one you will meet at work. Nothing to install: no database server, no client, so a school Chromebook works. Each lesson ends with a challenge, the sections end with projects and final challenges, and Bugsy, the AI tutor, explains what went wrong without writing the query for you.
  • The first section needs no experience: SELECT, comments, ORDER BY and LIMIT, filtering with WHERE, AND and OR, missing values with NULL, searching text with ILIKE, calculated columns, DISTINCT, CASE and COALESCE, then a stock report for an online shop.
  • Then the PostgreSQL in PostgreSQL: casts with ::, exact division with numeric, booleans, a table you create with types and constraints, dates and intervals, EXTRACT and date_trunc, COUNT, SUM and AVG with GROUP BY and HAVING. Changing data safely: INSERT, UPDATE and DELETE with RETURNING, so you see exactly which rows changed, and a transaction you roll back with BEGIN and ROLLBACK.
  • The last section connects customers and orders: JOIN and LEFT JOIN, subqueries and EXISTS, queries in stages with WITH, window functions (ROW_NUMBER, ranks, running totals and LAG), and reading JSONB with ->, ->> and @>, ending in a customer report.

Frequently asked questions about learning PostgreSQL

Do I need to know SQL before learning PostgreSQL?

No. The first section starts from your first SELECT and needs no programming or database experience. If you already know SQL, the second section is where the PostgreSQL features begin.

Is this real PostgreSQL?

Yes. Your queries run on PostgreSQL 17 on Coddy's servers, and every run starts from fresh copies of the lesson's tables, so you can update and delete rows without breaking anything. The SQL you write is ordinary PostgreSQL.

Do I need to install PostgreSQL?

No. Everything runs in the browser, on a computer or a phone, on the website. The course is not in the Coddy mobile apps. To try queries outside a lesson, open the PostgreSQL playground.

What is the difference between this course and the SQL course?

The SQL course teaches standard SQL on SQLite. This course runs on PostgreSQL and teaches what PostgreSQL adds: :: casts, ILIKE, intervals and date_trunc, RETURNING, transactions and JSONB.

What will I learn in this PostgreSQL course?

Three sections, 67 lessons: First Queries (selecting, filtering, sorting and labels), SQL Foundations (types, dates, grouping and changing data) and Connected Data (joins, subqueries, CTEs, window functions and JSONB).

Is the PostgreSQL course free?

Yes. The lessons, the AI hints and the certificates are free. A free account works through a few lessons a day, and Pro removes the daily limit.

Do I get a certificate for the PostgreSQL course?

Yes. Each of the 3 sections gives you a free certificate of completion when you finish it, with its own page you can share or add to LinkedIn.

Coddy programming languages illustration

Learn PostgreSQL with Coddy

Get started