Mastering PostgreSQL for Data Engineering and Cloud Deployment: Design, Optimize, and Manage PostgreSQL Databases for Data Engineering, High ... Engineering — SQL & PostgreSQL Path, Band 1) - Softcover

Buch 1 von 2: Database Engineering ? SQL & PostgreSQL Path

Fozao, Jaques Chiankem; AVA

 
9789349888388: Mastering PostgreSQL for Data Engineering and Cloud Deployment: Design, Optimize, and Manage PostgreSQL Databases for Data Engineering, High ... Engineering — SQL & PostgreSQL Path, Band 1)
Softcover
ISBN 10: 9349888386 ISBN 13: 9789349888388
Verlag: Orange Education Pvt Ltd, 2025

Inhaltsangabe

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

Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.

Verlag
Orange Education Pvt Ltd
Erscheinungsdatum
2025
Sprache
Englisch
ISBN 10 
9349888386
ISBN 13 
9789349888388
Einband
Taschenbuch
Anzahl der Seiten
415
Kontakt zum Hersteller
Manufactured by Amazon on behalf of the author
https://www.amazon.de/hz/contact-us

c/o Amazon Media EU S.à.r.l., 38 Avenue John F. Kennedy
Luxembourg
L-1855
Luxemburg