Learn PostgreSQL. Use, manage, and build secure and scalable databases with PostgreSQL 18 or higher - Third Edition

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.