Mastering PostgreSQL 9.6
PostgreSQL is an open source database management tool used for handling large datasets (big data) and as a JSON document database. It also has applications in the software and web domains. This book will enable you to build better PostgreSQL applications and administer databases more efficiently.
Offered by
Difficulty Level
Intermediate
Completion Time
13h52m
Language
English
About Book
Who Is This Book For?
If you are a PostgreSQL data architect or an administrator who wants to understand how to implement advanced functionalities and master complex administrative tasks with PostgreSQL, then this book is perfect for you. Prior experience of administrating a PostgreSQL database and a working knowledge of SQL is required to make the best use of this book.
Mastering PostgreSQL 9.6
- About Book
- Who Is This Book For?
- Book Content
Book content
chapters • 13h52m total length
PostgreSQL Overview
Understanding Transactions and Locking
Making Use of Indexes
Handling Advanced SQL
Log Files and System Statistics
Optimizing for Good Query Performance
Writing Stored Procedures
Managing PostgreSQL security
Handling Backup and Recovery
Making Sense of Backups and Replication
Deciding on Useful Extensions
Troubleshooting PostgreSQL
Migrating to PostgreSQL
Related Resources
Access Ready-to-Use Books for Free!
Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!