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
- Beginner friendly
AI-assisted coding help
Hands-on interactive lessons
Quizzes to test your knowledge
Free certificate of completion
Syllabus
Section 1
First Queries
Start sectionStartRead a catalog, filter rows, calculate useful fields and build a stock report. No programming or database experience required.Introduction
5 lessons515Filter the Catalog
5 lessons520Build Useful Results
5 lessons520Project: Catalog Report
3 lessons35Final Challenges
2 lessons2Section 2
SQL Foundations
Start sectionStartUse PostgreSQL types and calendar operations, summarize groups, and change data with RETURNING and transactions.Types and Casts
5 lessons520Dates and Time
5 lessons520Summarize Rows
5 lessons520Change Data Safely
5 lessons520Final Challenges
2 lessons2Section 3
Connected Data
Start sectionStartConnect customers and orders, organize multi-stage queries, analyze windows and extract JSONB into complete reports.Connect Tables
5 lessons520Queries in Stages
5 lessons520Window Calculations
5 lessons520Work with JSONB
5 lessons520Project: Customer Report
3 lessons35Final Challenges
2 lessons2
Learn by Doing
Write real code, query databases, build websites, and master AI prompts. Our interactive lessons cover every skill modern developers need.
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!
January 2026
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
Double or Nothing
Day 5 of 7
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!
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.
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.
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.
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 BYandLIMIT, filtering withWHERE,ANDandOR, missing values withNULL, searching text withILIKE, calculated columns,DISTINCT,CASEandCOALESCE, then a stock report for an online shop. - Then the PostgreSQL in PostgreSQL: casts with
::, exact division withnumeric, booleans, a table you create with types and constraints, dates and intervals,EXTRACTanddate_trunc,COUNT,SUMandAVGwithGROUP BYandHAVING. Changing data safely:INSERT,UPDATEandDELETEwithRETURNING, so you see exactly which rows changed, and a transaction you roll back withBEGINandROLLBACK. - The last section connects customers and orders:
JOINandLEFT JOIN, subqueries andEXISTS, queries in stages withWITH, window functions (ROW_NUMBER, ranks, running totals andLAG), 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?
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?
What is the difference between this course and the SQL course?
:: 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.