Module 01 of 10

Getting Started with PostgreSQL

Lessons

About This Module

Before you write a single query, it helps to know what you are working with. PostgreSQL is a free, open-source relational database that has been in active development for decades, and it is trusted by startups and large companies alike for its reliability and its long list of features.

You'll start with a quick overview of what PostgreSQL is and where it fits among other databases, then see how far it can stretch beyond plain tables, from JSON storage to search and queues. Finally you'll follow a hands-on walkthrough that covers installing the server, connecting with psql and pgAdmin, and running your first commands.

Once your setup is working, you'll be ready for the next module, Querying Data with SQL, where you start reading and changing data with SELECT, INSERT, UPDATE, and DELETE.

Lessons

3 videos
01

PostgreSQL in 100 Seconds

A fast introduction to PostgreSQL: what a relational database is, how Postgres stores and queries data, and why it became one of the most popular databases in the world.

02

I replaced my entire tech stack with Postgres

A tour of the unusual things PostgreSQL can do beyond storing rows, showing how far a single database can go when building a full-stack application.

03

Learn PostgreSQL Tutorial: Full Course for Beginners

A complete beginner course from freeCodeCamp. Start with the opening sections on installing PostgreSQL and using the command line, then keep going as you move through the next modules.