Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Mastering PostgreSQL 11: Expert techniques to build scalable, reliable, and fault-tolerant database applications, 2nd Edition

Buy

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

Key Features

  • Master advanced concepts of PostgreSQL 11 with real-world datasets and examples
  • Explore query parallelism, data replication, and database performance while working with larger datasets
  • Extend the functionalities of your PostgreSQL instance to suit your organization's needs with minimal effort

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.

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

Who this book is for

This book is for data and database professionals wanting to implement advanced functionalities and master complex administrative tasks with PostgreSQL 11. Prior experience of database administration with PostgreSQL database will aid in understanding the concepts covered in this book.

Table of Contents

  1. PostgreSQL Overview
  2. Understanding Transactions and Locking
  3. Making Use of Indexes
  4. Handling Advanced SQL
  5. Log Files and System Statistics
  6. Optimizing Queries for Good Performance
  7. Writing Stored Procedures
  8. Managing PostgreSQL Security
  9. Handling Backup and Recovery
  10. Making Sense of Backups and Replication
  11. Deciding on Useful Extensions
  12. Troubleshooting PostgreSQL
  13. Migrating to PostgreSQL
(HTML tags aren't allowed.)

Quicken 2009 The Official Guide (Quicken Press)
Quicken 2009 The Official Guide (Quicken Press)
The Only Official Guide to the #1 Personal Finance Software

Now you can manage your finances and assets with ease! Quicken 2009: The Official Guide is filled with insider tips and expert techniques for tracking your income, expenses, savings, transactions, investments, and much more.

Fully endorsed by Intuit,...

Pop Song Piracy: Disobedient Music Distribution since 1929
Pop Song Piracy: Disobedient Music Distribution since 1929


The music industry’s ongoing battle against digital piracy is just the latest skirmish in a long conflict over who has the right to distribute music. Starting with music publishers’ efforts to stamp out bootleg compilations of lyric sheets in 1929, Barry Kernfeld’s Pop Song Piracy details nearly a...
Internet Forensics
Internet Forensics

Because it's so large and unregulated, the Internet is a fertile breeding ground for all kinds of scams and schemes. Usually it's your credit card number they're after, and they won't stop there. Not just mere annoyances, these scams are real crimes, with real victims. Now, thanks to ...


openFrameworks Essentials
openFrameworks Essentials

Create stunning, interactive openFrameworks-based applications with this fast-paced guide

About This Book

  • Generate 2D and 3D graphics with openFrameworks
  • Create a video synthesizer project and run it on multi-platform devices
  • Use networking and Arduino to control your...
Health Measurement Scales: A Practical Guide to Their Development and Use (Oxford Medical Publications)
Health Measurement Scales: A Practical Guide to Their Development and Use (Oxford Medical Publications)

This is the new edition of the highly successful practical guide for clinicians developing tools to measure subjective states, attitudes or non-tangible outcomes in their patients. It is widely used by people from many disciplines, who have only a limited knowledge of statistics.

This thoroughly updated edition of Health
...

Rhodes Framework for Android(TM) Platform and BlackBerry® Smartphones (SpringerBriefs in Computer Science)
Rhodes Framework for Android(TM) Platform and BlackBerry® Smartphones (SpringerBriefs in Computer Science)

The Rhodes framework offers several advantages over other mobile frameworks. Some of the unique features of the Rhodes frameworks are as follows:

- The only smartphone framework to offer support for the Model View Controller pattern

- The only smartphone framework to offer support for the Object-Relational manager

...
©2021 LearnIT (support@pdfchm.net) - Privacy Policy