PostgreSQL Cookbook

PostgreSQL Cookbook

English | 2015 | 286 Pages | ISBN: 1783555335 | EPUB | 2.6 MB

Over 90 hands-on recipes to effectively manage, administer, and design solutions using PostgreSQL

About This Book
- Implement a highly available PostgreSQL database server and perform administrative and development functions with PostgreSQL
- Perform database operations in PostgreSQL using Perl and Python
- Step-by-step recipes focusing on providing real-world Postgresql solutions
Who This Book Is For
If you are a system administrator, database administrator, architect, developer, or anyone with an interest in planning, managing, and designing database solutions using PostgreSQL, this is the book for you. This book is suited for you if you have some prior experience with any relational database or with the SQL language.
What You Will Learn

- Perform regular maintenance tasks to keep your database steady and achieve optimal performance

- Design and implement various high availability and replication features to provide redundancy, fault tolerance, and failover

- Diagnose and troubleshoot CPU, memory, and I/O related database performance issues

- Perform database operations using languages such as Perl and Python

- Discover the different backup and recovery strategies that can be implemented in PostgreSQL

- Implement connection pooling methods to achieve load balancing

In Detail
PostgreSQL is an open source database management system. It is used for a wide variety of development practices such as software and web design, as well as for handling large datasets (big data).
With the goal of teaching you the skills to master PostgreSQL, the book begins by giving you a glimpse of the unique features of PostgreSQL and how to utilize them to solve real-world problems. With the aid of practical examples, the book will then show you how to create and manage databases. You will learn how to secure PostgreSQL, perform administration and maintenance tasks, implement high availability features, and provide replication. The book will conclude by teaching you how to migrate information from other databases to PostgreSQL.


[Fast Download] PostgreSQL Cookbook

Related eBooks:
COMPUTER PROGRAMMING: 4 Books in 1: Data Science, Hacking with Kali Linux, Computer Networking for B
SQL: Beginner's Guide to Learn SQL for Database and Data Analysis
Python Programming For Beginners: The Beginner's Guide to Learning the Basics of Python. Tips and Tr
Beginning Ring Programming: From Novice to Professional
Introducing SQL Server
Data Science and Analytics
Oracle Database 12c Security Cookbook
Pro SQL Server Always On Availability Groups
Big Data Governance: Modern Data Management Principles for Hadoop, NoSQL & Big Data Analytics
Database and Expert Systems Applications
Apache Mahout Essentials
Data Analytics for Beginners: A Beginner's Guide to Learn and Master Data Analytics
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.