PostgreSQL for Data Architects by Jayadevan Maymala
PostgreSQL for Data Architects by Jayadevan Maymala PDF, ePub eBook D0wnl0ad
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.
From reader reviews:
Ruth McMillian:
Here thing why that PostgreSQL for Data Architects are different and dependable to be yours. First of all reading a book is good nonetheless it depends in the content from it which is the content is as delightful as food or not. PostgreSQL for Data Architects giving you information deeper including different ways, you can find any publication out there but there is no book that similar with PostgreSQL for Data Architects. It gives you thrill looking at journey, its open up your personal eyes about the thing in which happened in the world which is perhaps can be happened around you. You can actually bring everywhere like in recreation area, café, or even in your means home by train. For anyone who is having difficulties in bringing the branded book maybe the form of PostgreSQL for Data Architects in e-book can be your alternative.
Susan Crowell:
Information is provisions for individuals to get better life, information these days can get by anyone with everywhere. The information can be a expertise or any news even an issue. What people must be consider any time those information which is within the former life are challenging be find than now's taking seriously which one works to believe or which one the resource are convinced. If you have the unstable resource then you obtain it as your main information you will see huge disadvantage for you. All of those possibilities will not happen within you if you take PostgreSQL for Data Architects as your daily resource information.
Matthew Russell:
Playing with family in the park, coming to see the sea world or hanging out with good friends is thing that usually you will have done when you have spare time, subsequently why you don't try issue that really opposite from that. Just one activity that make you not feeling tired but still relaxing, trilling like on roller coaster you are ride on and with addition associated with. Even you love PostgreSQL for Data Architects, you may enjoy both. It is good combination right, you still desire to miss it? What kind of hangout type is it? Oh come on its mind hangout folks. What? Still don't buy it, oh come on its referred to as reading friends.
Read PostgreSQL for Data Architects by Jayadevan Maymala for online ebook
PostgreSQL for Data Architects by Jayadevan Maymala Free PDF d0wnl0ad, audio books, books to read, good books to read, cheap books, good books, online books, books online, book reviews epub, read books online, books to read online, online library, greatbooks to read, PDF best books to read, top books to read PostgreSQL for Data Architects by Jayadevan Maymala books to read online.
Tidak ada komentar:
Posting Komentar