[100% Off] Postgresql Fundamentals With Psql
Build a real database with tables, constraints, joins, and relationships | Learn PostgreSQL from the terminal
What you’ll learn
- Create a database from scratch.
- Connect to the created database.
- Add, change, and delete tables and rows.
- Query information from the database using SQL.
Requirements
- No SQL experience is needed.
- Some knowledge of the command line can be useful.
Description
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.
Author(s): Martijn Vissers
