PostgreSQL Fundamentals with psql

Course Description

Learn PostgreSQL the way many developers actually use it, directly from the terminal with psql.

In this hands-on course you will build a complete task tracking database using only the command line. Every lecture adds to the same  project, so you continuously practice connecting, inspecting, creating, querying, and relating data instead of jumping between disconnected examples like many bigger courses do.

You will start by spinning up PostgreSQL, connecting with psql, and learning the essentials. From there you create tables, insert and update rows, filter and sort results, add constraints, model one-to-many and many-to-many relationships, and write useful joins to view all related data. All while staying mostly inside the terminal.

What you’ll learn

• Connect to PostgreSQL with psql and use the most important meta-commands

• Create tables with primary keys, required columns, and useful defaults

• Insert, update, and delete data safely using WHERE, RETURNING, and TRANSACTIONs

• Filter, sort, limit, and count rows with built-in functions

• Add columns, constraints, and enforce data integrity

• Model one-to-many relationships

• Model many-to-many relationships with a proper junction table

• Write clear INNER JOIN and LEFT JOIN queries to combine related data

• And more practical terminal-first PostgreSQL skills you can use immediately

Who this course is for

• Beginners with no prior SQL or PostgreSQL experience

• Developers who want to learn SQL and PostgreSQL without relying on a GUI

• Anyone who prefers working in the command line

• Developers who want a practical, project-based introduction rather than a long theoretical course

Requirements

• A computer where you can install Docker (recommended, not necessary) or PostgreSQL + pgAdmin

• Willingness to type commands in the terminal to follow along

• No previous SQL, PostgreSQL, or Docker experience required

About the instructor

I create practical and quick courses focused on real terminal productivity and developer fundamentals. My existing courses cover tools commonly used in the terminal such as Vim, Bash, Tmux, and Grep/sed/awk. I try to design every course around a clear progressive project so you leave with working skills instead of just theory. If you like learning by doing and prefer the command line, you’re in the right place.

By the end of this course you will have built a fully working task database with projects, labels, constraints, and joins, and you will be comfortable using PostgreSQL from the terminal every day.