If you enjoyed this book, you may be interested in these other books by Packt:

PostgreSQL 11 Administration Cookbook
Simon Riggs,  Gianni Ciolli,  Sudheer Kumar Meesala

ISBN: 978-1-78953-758-1

• Troubleshoot open source PostgreSQL version 11 on various platforms
• Deploy best practices for planning and designing live databases
• Select and implement robust backup and recovery techniques in PostgreSQL 11
• Use pgAdmin or OmniDB to perform database administrator (DBA) tasks
• Adopt efficient replication and high availability techniques in PostgreSQL
• Improve the performance of your PostgreSQL solution

Learning PostgreSQL 11
Salahaldin Juba, Andrey Volkov

ISBN: 978-1-78953-546-4

• Understand the basics of relational databases, relational algebra, and data modeling
• Install a PostgreSQL server, create a database, and implement your data model
• Create tables and views, define indexes and stored procedures, and implement triggers
• Make use of advanced data types such as Arrays, hstore, and JSONB
• Connect your Python applications to PostgreSQL and work with data efficiently
• Identify bottlenecks to enhance reliability and performance of database applications