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 · 1 practice 0 of 3
Lesson 1 · 6:49What Is a Database? Installing PostgreSQL
Lesson 2 · 7:04Your First Queries
Practice · 0 of 25 questionsModule practice
Module practice
0 of 25 for the certificate
Answer 25 questions
This module has 50 questions; 25 count toward the certificate.
Practice →
2 Querying Data 2 lessons · 1 practice 0 of 3
Lesson 1 · 6:52Joining Tables Together
Lesson 2 · 7:03Summarizing Data with Aggregates
Practice · 0 of 25 questionsModule practice
Module practice
0 of 25 for the certificate
Answer 25 questions
This module has 50 questions; 25 count toward the certificate.
Practice →
3 Designing Tables & Data Types 2 lessons · 1 practice 0 of 3
Lesson 1 · 6:49Designing Tables & Choosing Data Types
Lesson 2 · 7:11Keys & Constraints That Protect Your Data
Practice · 0 of 25 questionsModule practice
Module practice
0 of 25 for the certificate
Answer 25 questions
This module has 50 questions; 25 count toward the certificate.
Practice →
4 Modifying Data & Transactions 2 lessons · 1 practice 0 of 3
Lesson 1 · 6:24Inserting, Updating & Deleting Data
Lesson 2 · 6:52Transactions & Staying Safe
Practice · 0 of 25 questionsModule practice
Module practice
0 of 25 for the certificate
Answer 25 questions
This module has 50 questions; 25 count toward the certificate.
Practice →
5 Indexes, Views & Admin Basics 2 lessons · 1 practice 0 of 3
Lesson 1 · 6:21Speeding Up Queries with Indexes
Lesson 2 · 6:40Views, Roles & Backups
Practice · 0 of 25 questionsModule practice
Module practice
0 of 25 for the certificate
Answer 25 questions
This module has 50 questions; 25 count toward the certificate.
Practice →
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