PostgreSQL for beginners

PostgreSQL for Beginners is a practical, exercise-driven tutorial that introduces SQL through the lens of PostgreSQL. It assumes you have PostgreSQL installed and gets straight to the work of creating tables, writing queries, and understanding how a relational database behaves.

What the Course Covers

• Chapter 1: Databases and SQL — core concepts and the relational model
• Chapter 2: Creating a working environment
• Chapter 3: Basic operations with tables
• Chapter 4: PostgreSQL data types — numeric, string, date/time, boolean, arrays, and JSON/JSONB
• Chapter 5: Basics of Data Definition Language — creating, altering, and dropping tables, views, and schemas
• Chapter 6: Queries — SELECT features, joins, aggregation, window functions, subqueries, and Common Table Expressions
• Chapter 7: Modifying data — inserts, updates, and deletes
• Chapter 8: Indexes
• Chapter 9: Transactions
• Chapter 10: Improving performance — reading EXPLAIN plans and query optimization

Learn by Doing with Exercises

Each chapter includes tasks, and some of the more demanding ones are marked with an asterisk. The material is designed so that a significant part of the learning happens as you complete these exercises, often with the PostgreSQL documentation at your side. The book uses a sample database called “Air transportation” to give the queries a realistic context.

From Simple SELECTs to Window Functions 💻

The progression is deliberate. You start with basic table operations and data types, then move into Data Definition Language, and only after that do you tackle the central chapter on queries. By the time you reach joins, aggregation, window functions, and Common Table Expressions, you have the table structures and sample data to make those concepts concrete. The final chapters on indexes, transactions, and performance tuning show how these pieces affect real query execution.

Who This PostgreSQL Guide Is For

This tutorial is written for students and self-learners who need practical SQL skills rather than a deep theoretical treatment. It was originally structured for university courses where databases are taught in the second or third year, but it works equally well for developers, analysts, or database administrators who want a guided, hands-on introduction to PostgreSQL. The book does not cover installation in detail; it assumes you already have access to a working PostgreSQL instance.

Why PostgreSQL? ⚙️

PostgreSQL is a free, open-source database management system known for its standards compliance and extensibility. This book takes advantage of those strengths, showing not just standard SQL but also PostgreSQL-specific features like arrays, JSON/JSONB types, and advanced query capabilities. That combination makes it a useful starting point for anyone who wants to learn SQL in a system they can continue using in production.

How the Material Is Organized

The ten chapters follow a logical teaching order, and the introduction suggests time allocations for each chapter depending on whether you have 36 or 54 hours of practical coursework. That structure can help instructors plan a semester, but it also gives independent learners a clear sense of how much time to invest in each topic. The emphasis throughout is on writing commands, observing results, and building the confidence to explore the documentation on your own.

Start Your PostgreSQL Journey

If you want a structured, exercise-led path into SQL and PostgreSQL, this tutorial provides the framework. It is a working manual: you will create tables, load data, write queries, and learn to read query plans. Add it to your digital library and begin with Chapter 1.