PostgreSQL for Data Architects Book PDF, ePub eBook

Join our eBook service for unlimited books & audiobooks. Get a free 7 day subscription! ↓↓↓↓↓


Book Descriptions:

Discover how to design, develop, and maintain your database application effectively with PostgreSQL

About This Book

• Understand how to utilize the most frequently used PostgreSQL ecosystem-related tools and technologies
• A hands-on guide focused primarily on providing a practical approach to learning about architecture and design considerations for database architects
• The book covers PostgreSQL from a data architect's perspective – covering topics from installation from source to designing tables using SQL Power Architect, as well as deciding replication and failover strategies.

Who This Book Is For

This book is for developers and data architects who have some exposure to databases. It is assumed that you understand the basic concepts of tables and common database objects, including privileges and security.

What You Will Learn

• Compile PostgreSQL from source and understand the PostgreSQL architecture
• Configure parameters and change default settings for a PostgreSQL server
• Leverage the logging mechanism to identify errors and suboptimal queries
• Use replication to scale horizontally
• Set up backup and recovery processes
• Tweak parameters to optimize queries and processes
• Troubleshoot connection errors
• Use indexes and rewrite queries to improve performance
• Install and use PostgreSQL extensions
• Learn how to leverage the command-line client (psql)

In Detail

PostgreSQL is an incredibly flexible and dependable open source relational database. Harnessing its power will make your applications more reliable and extensible without increasing costs. Using PostgreSQL's advanced features will save you work and increase performance, once you've discovered how to set it up.

PostgreSQL for Data Architects will teach you everything you need to learn in order to get a scalable and optimized PostgreSQL server up and running.

The book starts with basic concepts like installing PostgreSQL from source and covers theoretical aspects such as concurrency and transaction management. After this, you'll learn how to set up replication, use load balancing to scale horizontally, and troubleshoot errors.

Finally, you will get acquainted with useful tools available in the PostgreSQL ecosystem used for analyzing PostgreSQL logs, setting up load balancing, and recovery.

PostgreSQL for Data Architects by Jayadevan Maymala

From reader reviews:

Dorothy Trimm:

Book will be written, printed, or illustrated for everything. You can understand everything you want by a e-book. Book has a different type. As you may know that book is important factor to bring us around the world. Close to that you can your reading ability was fluently. A reserve PostgreSQL for Data Architects will make you to possibly be smarter. You can feel a lot more confidence if you can know about every thing. But some of you think that will open or reading a new book make you bored. It is far from make you fun. Why they are often thought like that? Have you searching for best book or ideal book with you?

Debbie Jackson:

The e-book with title PostgreSQL for Data Architects has lot of information that you can understand it. You can get a lot of profit after read this book. This specific book exist new expertise the information that exist in this publication represented the condition of the world now. That is important to yo7u to know how the improvement of the world. This book will bring you inside new era of the syndication. You can read the e-book on your own smart phone, so you can read the item anywhere you want.

James Hall:

A lot of people always spent their particular free time to vacation or go to the outside with them family or their friend. Do you realize? Many a lot of people spent many people free time just watching TV, or maybe playing video games all day long. If you would like try to find a new activity this is look different you can read some sort of book. It is really fun to suit your needs. If you enjoy the book that you read you can spent the whole day to reading a book. The book PostgreSQL for Data Architects it is rather good to read. There are a lot of people who recommended this book. We were holding enjoying reading this book. When you did not have enough space bringing this book you can buy the e-book. You can m0ore easily to read this book from the smart phone. The price is not too expensive but this book provides high quality.

Joseph Dolezal:

A lot of reserve has printed but it takes a different approach. You can get it by web on social media. You can choose the most effective book for you, science, comedian, novel, or whatever by searching from it. It is known as of book PostgreSQL for Data Architects. You'll be able to your knowledge by it. Without causing the printed book, it could possibly add your knowledge and make a person happier to read. It is most significant that, you must aware about publication. It can bring you from one location to other place.