Beginner Databases
PostgreSQL Fundamentals
Learn PostgreSQL from zero, the world's most advanced open-source database. Install it, run your first queries with psql and pgAdmin, and master the SQL you need every day: SELECT and filtering, joins and aggregates, designing tables with the right data types and keys, modifying data safely with transactions, and speeding things up with indexes. No prior database experience required, by the end you can build and query a real PostgreSQL database with confidence.
5 modules 10 lessons 4 h 250 questions
Course content
1 Getting Started & SQL Basics 2 lessons · 14 min
2 Querying Data 2 lessons · 14 min
3 Designing Tables & Data Types 2 lessons · 14 min
4 Modifying Data & Transactions 2 lessons · 13 min
5 Indexes, Views & Admin Basics 2 lessons · 13 min
Tips
See all
Aggregates
WHERE Filters Rows, HAVING Filters Groups
Know which runs before grouping
Data Types
Never Store Money as FLOAT
Use NUMERIC for exact decimals
Keys
Primary Keys Identify, Foreign Keys Connect
The backbone of relational design
Schema Design
Prefer GENERATED AS IDENTITY Over SERIAL
The modern standard for auto IDs