PostgreSQL for Data Architects

PostgreSQL for Data Architects

English | Mar. 27, 2015 | ISBN: 1783288604 | 272 Pages | PDF | 5MB

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)


[Fast Download] PostgreSQL for Data Architects

Ebooks related to "PostgreSQL for Data Architects" :
SQL Server 2005 T-SQL Recipes
HBase: The Definitive Guide
Database Systems for Advanced Applications
High Performance MySQL
Getting Started with Couchbase Server
Sams Teach Yourself SQL in 24 Hours (4th Edition)
Beginning T-SQL 2012, 2 edition
Addison Wesley Practical Business Intelligence with SQL Server 2005 Aug 2006
Database Systems Concepts, 4 Edition
Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.