All you need to know about using PostgreSQL efficiently and reliably.
Key Features
- Learn the fundamentals of PostgreSQL, advanced statements, user management, database monitoring, replication, and security
- Enhance your learning journey with the provided Docker images for practical hands-on exercises
- Manage large databases with advanced techniques like partitioning to optimize your databases
- Purchase of the print or Kindle book includes a free PDF eBook
Book Description
The latest edition of this PostgreSQL- dedicated book guides you from the ground up in using this great and feature-rich relational database. Starting from absolute scratch, you will quickly learn the internal mechanics of PostgreSQL and how to use the SQL language to get the most out of your databases. The book presents ways to configure, manage, secure and exploit the rich set of features that PostgreSQL provides to you and your applications, including its rich and continuously growing ecosystem of tools and extensions. You will get PostgreSQL up and running at lightning speed. You'll become familiar with SQL for basic and advanced statements, including window functions, triggers, functions and procedures, and more. Managing large tables and databases through advanced techniques like table partitioning will be covered in detail. In this edition you will see also how to use PostgreSQL as a backbone for Artificial Intelligence systems. All the examples are presented through a set of Docker images, pre-built and freely available, to help you get comfortable with trying out and verifying new concepts. Moreover, every chapter includes a Q&A section to validate your new knowledge and important concepts. Thanks to this new edition, you will also learn how to deal with disaster recovery and database optimization.
What you will learn
- PostgreSQL internal mechanics, including MVCC, vacuum, transaction management and isolation, security and replication
- Choosing the right replication strategy
- Managing users and connections to improve database security
- Managing indexes and queries to get the most out of your database
- Using the PgVector extension to support AI-based applications
Who this book is for
Learn PostgresSQL book is for anyone interested in learning about the PostgreSQL database from scratch. Anyone looking to build robust data warehousing applications and scale the database for high-availability and performance using the latest features of PostgreSQL will also find this book useful. Although prior knowledge of PostgreSQL is not required, familiarity with databases is expected.
