Edition |
3rd ed. |
Description |
1 online resource (455 pages) |
Summary |
This book includes the newly introduced features in PostgreSQL 12, and shows you how to build better PostgreSQL applications, and administer your database efficiently. You will master the advanced features of PostgreSQL and acquire the necessary skills to build secured and fault-tolerant database solutions. |
Contents |
Mastering PostgreSQL 12 : advanced techniques to build and administer scalable and reliable PostgreSQL database applications, 3rd edition -- Contributors -- Table of Contents -- Preface -- Section 1: Basic Overview -- Chapter 1: PostgreSQL 12 Overview -- Chapter 2: Understanding Transactions and Locking -- Section 2: Advanced Concepts -- Chapter 3: Making Use of Indexes -- Chapter 4: Handling Advanced SQL -- Chapter 5: Log Files and System Statistics -- Chapter 6: Optimizing Queries for Good Performance -- Chapter 7: Writing Stored Procedures -- Chapter 8: Managing PostgreSQL Security -- Chapter 9: Handling Backup and Recovery -- Chapter 10: Making Sense of Backups and Replication -- Chapter 11: Deciding on Useful Extensions -- Chapter 12: Troubleshooting PostgreSQL -- Chapter 13: Migrating to PostgreSQL -- Assessment -- Other Books You May Enjoy -- Index. |
Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
Subject |
PostgreSQL.
|
|
PostgreSQL |
|
SQL (Computer program language)
|
|
Servers. |
|
Databases. |
|
Database design & theory. |
|
Information architecture. |
|
Computers -- Database Management -- General. |
|
Computers -- Data Modeling & Design. |
|
SQL (Computer program language) |
Other Form: |
Print version: Schönig, Hans-Jürgen. Mastering PostgreSQL 12 : Advanced Techniques to Build and Administer Scalable and Reliable PostgreSQL Database Applications, 3rd Edition. Birmingham : Packt Publishing, Limited, ©2019 9781838988821 |
ISBN |
1838985271 |
|
9781838985271 (electronic bk.) |
|