Book

Mastering PostgreSQL 13

Updated to include the new features introduced in PostgreSQL 13, this book shows you how to build better PostgreSQL applications and administer your PostgreSQL database efficiently. You’ll master the advanced features of PostgreSQL and develop the skills you need to build secure and highly available database solutions.

Offered byPackt Logo

Difficulty Level

Intermediate

Completion Time

15h52m

Language

English

About Book

Who Is This Book For?

This database administration book is for PostgreSQL developers and database administrators and professionals who want to implement advanced functionalities and master complex administrative tasks with PostgreSQL 13. Prior experience in PostgreSQL and familiarity with the basics of database administration will assist with understanding key concepts covered in the book.

Book content

chapters 15h52m total length

PostgreSQL 13 Overview

Understanding Transactions and Locking

Making Use of Indexes

Handling Advanced SQL

Log Files and System Statistics

Optimizing Queries for Good 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!

No credit card required