PostgreSQL For Data Architects(1st Edition)
Authors:
Jayadevan Maymala
In Stock
Include with your book
Free shipping: April 04, 2024Popular items with books
Total Price:
$0
Book details
ISBN: 1783288604, 978-1783288601
Book publisher: Packt Publishing (March 30, 2015)
PostgreSQL For Data Architects 1st Edition Summary: Discover how to design, develop, and maintain your database application effectively with PostgreSQLAbout This BookUnderstand how to utilize the most frequently used PostgreSQL ecosystem-related tools and technologiesA hands-on guide focused primarily on providing a practical approach to learning about architecture and design considerations for database architectsThe 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 ForThis 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 LearnCompile PostgreSQL from source and understand the PostgreSQL architectureConfigure parameters and change default settings for a PostgreSQL serverLeverage the logging mechanism to identify errors and suboptimal queriesUse replication to scale horizontallySet up backup and recovery processesTweak parameters to optimize queries and processesTroubleshoot connection errorsUse indexes and rewrite queries to improve performanceInstall and use PostgreSQL extensionsLearn how to leverage the command-line client (psql)In DetailPostgreSQL 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.
Customers also bought these books
Taxes For Small Business A Comprehensive Beginner S Guide To Learn And Understand The Realms Of Taxes For Small Business From A Z -
Gregory Becker
ISBN: 979-8643506652
$0 $20.39Frequently Bought Together
Startup Sales Field Notes How To Build Enterprise Sales From Scratch To Scale Practical Sales Methodology And Execution Skills For Founders And Their Teams - 1st Edition
Kent Jamison Summers
ISBN: 979-8373956864
$0 $36.95
Death Dying And Bereavement Contemporary Perspectives Institutions And Practices - 1st Edition
Judith Stillion Phd Ct
ISBN: 0826171419, 978-0826171412
$0 $62.24
Economic Issues and Policy - 6th edition
Jacqueline murray brux
ISBN: 9781337001977, 1285448774, 133700197X, 978-1285448770
$0 $324.95
A Guide To The Engineering Management Body Of Knowledge - 3rd Edition
Hiral Shah
ISBN: 0983100535, 978-0983100539
$0 $51.00
The Craft Of Dying 40th The Modern Face Of Death - 1st Edition
Lyn H Lofland
ISBN: 0262537346 , 978-0262537346
$0 $12.40
Sales Management Concepts Practices And Cases - 2nd Edition
Johnson
ISBN: 0071134026, 9780071134026
$0 $34.00
Timely Wealth And Strategies To Be Successful In Todays World How To Make Your First $100 - 1st Edition
James Ade
ISBN: 979-8862682557
$0 $7.99Top Reviews for Books
