Mastering PostgreSQL 11 - Second Edition

Master the capabilities of PostgreSQL 11 to efficiently manage and maintain your database
Code Files

Mastering PostgreSQL 11 - Second Edition

Hans-Jürgen Schönig

Master the capabilities of PostgreSQL 11 to efficiently manage and maintain your database
Packt Subscription
FREE
$9.99/m after trial
eBook
$22.40
RRP $31.99
Save 29%
Print + eBook
$39.99
RRP $39.99
What do I get with a Packt subscription?
  • Exclusive monthly discount - no contract
  • Unlimited access to entire Packt library of 6500+ eBooks and Videos
  • 120 new titles added every month, on new and emerging tech
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$0.00
$22.40
$39.99
$9.99 p/m after trial
RRP $31.99
RRP $39.99
Subscription
eBook
Print + eBook
Start a FREE 10-day trial

Frequently bought together


Mastering PostgreSQL 11 - Second Edition Book Cover
Mastering PostgreSQL 11 - Second Edition
$ 31.99
$ 22.40
Mastering Docker - Third Edition Book Cover
Mastering Docker - Third Edition
$ 39.99
$ 28.00
Buy 2 for $50.40
Save $21.58
Add to Cart

Book Details

ISBN 139781789537819
Paperback450 pages

Book Description

This second edition of Mastering PostgreSQL 11 helps you build dynamic database solutions for enterprise applications using the latest release of PostgreSQL, which enables database analysts to design both the physical and technical aspects of the system architecture with ease.

This book begins with an introduction to the newly released features in PostgreSQL 11 to help you build efficient and fault-tolerant PostgreSQL applications. You’ll examine all of the advanced aspects of PostgreSQL in detail, including logical replication, database clusters, performance tuning, monitoring, and user management. You will also work with the PostgreSQL optimizer, configuring PostgreSQL for high speed, and see how to move from Oracle to PostgreSQL. As you progress through the chapters, you will cover transactions, locking, indexes, and optimizing queries to improve performance. Additionally, you’ll learn to manage network security and explore backups and replications, while understanding the useful extensions of PostgreSQL so that you can optimize the speed and performance of large databases.

By the end of this book, you will be able to use your database to its utmost capacity by implementing advanced administrative tasks with ease.

Table of Contents

What You Will Learn

  • Get to grips with advanced PostgreSQL 11 features and SQL functions
  • Make use of the indexing features in PostgreSQL and fine-tune the performance of your queries
  • Work with stored procedures and manage backup and recovery
  • Master replication and failover techniques
  • Troubleshoot your PostgreSQL instance for solutions to common and not-so-common problems
  • Perform database migration from MySQL and Oracle to PostgreSQL with ease

Authors

Table of Contents

Book Details

ISBN 139781789537819
Paperback450 pages
Read More

Read More Reviews

Recommended for You

Mastering Docker - Third Edition Book Cover
Mastering Docker - Third Edition
$ 39.99
$ 28.00
Architects of Intelligence Book Cover
Architects of Intelligence
$ 14.99
$ 10.50
Kubernetes Design Patterns and Extensions Book Cover
Kubernetes Design Patterns and Extensions
$ 19.99
$ 14.00
Android Programming for Beginners - Second Edition Book Cover
Android Programming for Beginners - Second Edition
$ 35.99
$ 25.20
Learning PostgreSQL 11 - Third Edition Book Cover
Learning PostgreSQL 11 - Third Edition
$ 31.99
$ 22.40
Learning PostgreSQL 10 - Second Edition Book Cover
Learning PostgreSQL 10 - Second Edition
$ 27.99
$ 19.60