Hands-On Introduction to SQL with PostgreSQL, A beginner-friendly introduction to databases, tables, queries, and data analysis with PostgreSQL.
Course Description
Welcome to Hands-On Introduction to SQL with PostgreSQL. I’m Lucas, a tech lead working in an international team with a passion for helping beginners start their tech journey in a simple and practical way.
In this course, we’ll take the mystery out of SQL — the language of data — using one of the most powerful and widely-used relational databases out there: PostgreSQL. Whether you’re looking to become a developer, work with data, or just understand how modern applications store and access information, this course is your perfect starting point.
We’ll begin with the absolute basics: what SQL is, how relational databases work, and why PostgreSQL is such a great tool for both beginners and professionals.
From there, we’ll build a mini bookstore project and get hands-on with essential SQL concepts:
- How to install and set up PostgreSQL on any operating system
- How to create tables and define your own schema
- How to insert, update, and delete data
- How to run powerful SELECT queries with filtering, sorting, and limits
- How to connect tables with relationships and foreign keys
- How to use joins to combine data across tables
- How to analyze data with GROUP BY, COUNT, SUM, and other aggregate functions
By the end of this course, you won’t just understand SQL—you’ll feel confident creating and querying your own databases, ready to expand into projects, applications, or deeper data analysis.
So no matter if you’re learning to code, working with data, or switching careers—you’re in the right place.
Let’s make SQL simple, practical, and rewarding!
