Mastering PostgreSQL for Data Engineering and Cloud Deployment: Design, Optimize, and Manage PostgreSQL...

— —

Jaques Chiankem Fozao

Mastering PostgreSQL for Data Engineering and Cloud Deployment

Design, Optimize, and Manage PostgreSQL Databases for Data Engineering, High Availability, and...

Jaques Chiankem Fozao

$122.95 $104.25

Undefined

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

Orange Education Pvt Ltd
12 August 2025

Summary
Details

Design, Optimize, and Scale PostgreSQL for Modern Data Pipelines. Book Description PostgreSQL is a leading open-source database, essential for modern data engineering tasks. Mastering PostgreSQL for Data Engineering and Cloud Deployment is your complete guide to unlocking PostgreSQL's full potential in data-centric environments.

Starting with installation and configuration, the book moves through foundational SQL, complex queries, and schema design. You will then deep dive into backup and restore, replication, high availability, and performance tuning strategies necessary for large-scale data workflows. The final chapters guide you through integrating PostgreSQL with AWS cloud services like RDS, EC2, and S3, enabling cloud-native data operations and migrations.

Packed with real-world use cases, this book helps data engineers streamline operations, optimize queries, and build resilient, high-performance database systems.

Hence, whether you are designing pipelines or managing production workloads, this is your roadmap to PostgreSQL mastery.

Table of Contents 1. Introduction to PostgreSQL 2. Installing and Initializing PostgreSQL 3. Subsets of SQL 4. Understanding the Database 5. PostgreSQL Configurations and File Permissions 6. Backup and Restore 7. Replication and High Availability 8. Upgrade 9. Performance Tuning 10. Functions in PostgreSQL 11. Demystifying Table Joints, Subqueries, CTE, and Views 12. Cloud Computing (AWS) 13. IAM Users and AWS Migration

Index

By: Jaques Chiankem Fozao
Imprint: Orange Education Pvt Ltd
Edition: New edition
ISBN: 9789349888388
ISBN 10: 9349888386
Pages: 416
Publication Date: 12 August 2025
Audience: Professional and scholarly , Undergraduate
Format: Undefined
Publisher's Status: Active