If you enjoyed this book, you may be interested in these other books by Packt:
Mastering PostgreSQL 10
Hans-Jürgen Schönig
ISBN: 978-1-78847-229-6
- Get to grips with the advanced features of PostgreSQL 10 and handle advanced SQL
- Make use of the indexing features in PostgreSQL and fine-tune the performance of your queries
- Work with stored procedures and manage backup and recovery
- Master replication and failover techniques
- Troubleshoot your PostgreSQL instance for solutions to common and not-so-common problems
- Learn how to migrate your database from MySQL and Oracle to PostgreSQL without any hassle
Learning PostgreSQL 10 - Second Edition
Salahaldin Juba, Andrey Volkov
ISBN: 978-1-78839-201-3
- Understand the fundamentals of relational databases, relational algebra, and data modeling
- Install a PostgreSQL cluster, create a database, and implement your data model
- Create tables and views, define indexes, and implement triggers, stored procedures, and other schema objects
- Use the Structured Query Language (SQL) to manipulate data in the database
- Implement business logic on the server side with triggers and stored procedures using PL/pgSQL
- Make use of advanced data types supported by PostgreSQL 10: Arrays, hstore, JSONB, and others
- Develop OLAP database solutions using the most recent features of PostgreSQL 10
- Connect your Python applications to a PostgreSQL database and work with the data efficiently
- Test your database code, find bottlenecks, improve performance, and enhance the reliability of the database applications