part one
In this part of the book, we explore core Postgres capabilities that define it as a relational database management system. These are the capabilities that most people are aware of and that have been used for decades.
We start with an introduction to Postgres and learn how to run it in Docker on our machine. From there, we explore its core relational capabilities by designing a database structure and manipulating data. Finally, we dive into modern SQL features and learn how to optimize query performance using different Postgres index types. After completing the first part of the book, we’ll be ready to use Postgres as a relational database for designing and building applications for transactional and other types of workloads.