Overlabs

PostgreSQL Fundamentals

PostgreSQL Fundamentals

Beginner

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 tracks ❓ 250 questions 💡 20 tips 🎬 10 videos ⏱ ~6h

▶ Start watching

PostgreSQL Fundamentals

PostgreSQL Fundamentals

Beginner

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 tracks ❓ 250 questions 💡 20 tips 🎬 10 videos ⏱ ~6h

▶ Start watching

Course content

What Is a Database? Installing PostgreSQL

What Is a Database? Installing PostgreSQL

⏱ 6:49

Your First Queries

Your First Queries

⏱ 7:04

Practice questions

0/50 answered

Start

Joining Tables Together

Joining Tables Together

⏱ 6:52

Summarizing Data with Aggregates

Summarizing Data with Aggregates

⏱ 7:03

Practice questions

0/50 answered

Start

Designing Tables & Choosing Data Types

Designing Tables & Choosing Data Types

⏱ 6:49

Keys & Constraints That Protect Your Data

Keys & Constraints That Protect Your Data

⏱ 7:11

Practice questions

0/50 answered

Start

Inserting, Updating & Deleting Data

Inserting, Updating & Deleting Data

⏱ 6:24

Transactions & Staying Safe

Transactions & Staying Safe

⏱ 6:52

Practice questions

0/50 answered

Start

Speeding Up Queries with Indexes

Speeding Up Queries with Indexes

⏱ 6:21

Views, Roles & Backups

Views, Roles & Backups

⏱ 6:40

Practice questions

0/50 answered

Start

Certification Exam

✦

🏆

Certification Exam

PostgreSQL Fundamentals

❓ 30

Questions

⏱ 45m

Time Limit

% 70%

To Pass

🔒 Unlock the exam

🎬 Watch 80% of the videos 0% / 80%

❓ Answer 80% of the practice questions 0% / 80%

Complete the requirements above to unlock the exam

🏆

Certification Exam

PostgreSQL Fundamentals

#

30 Questions

All difficulty levels

⏱

45 Minutes

Auto-submits when time expires

%

70% to Pass

Earn your certification badge

→

No Going Back

Once you answer, you move forward

Tips

See all

Aggregates Intermediate

WHERE Filters Rows, HAVING Filters Groups

Know which runs before grouping

Data Types Beginner

Never Store Money as FLOAT

Use NUMERIC for exact decimals

Primary Keys Identify, Foreign Keys Connect

The backbone of relational design

Schema Design Intermediate

Prefer GENERATED AS IDENTITY Over SERIAL

The modern standard for auto IDs