PostgreSQL
Learn PostgreSQL, one of the most popular open source relational database management systems

Join the AI Workshop to learn more about AI and how it can be applied to web development. Next cohort February 1st, 2026

The AI-first Web Development BOOTCAMP cohort starts February 24th, 2026. 10 weeks of intensive training and hands-on projects.

PostgreSQL is one of the most popular SQL database management systems (DBMS) ever.

It is Open Source, free for personal and commercial use, and it has a long history that started in 1996.

In this unit you’ll learn how to install PostgreSQL, create databases, manage users and permissions, and where to host your database.

Lessons in this unit:

0: ▶︎ Introduction
1: Introduction to PostgreSQL
2: How to install PostgreSQL on macOS
3: How to create a PostgreSQL database
4: Navigating Databases in PostgreSQL
5: PostgreSQL User Permissions
6: Tables and Data Types
7: Where to host a PostgreSQL database
8: PostgreSQL vs MySQL
9: Troubleshooting PostgreSQL
10: Vercel Postgres, no transactions?
11: Set up Lucia Auth for local Postgres DB vs Vercel Postgres
12: Connect to Postgres local vs Vercel Postgres with Kysely