PostgreSQL Playbook for Developer DBAs

Are you a Database Administrator looking to update your skills? Learn how to do different kinds of tasks in PostgreSQL that you'll need to know as a DBA.

Developers often inherit the job of Database Administrator as their companies grow, and the database needs someone to look after it. As a new DBA, you need to quickly understand how to secure your server, optimize performance, and safeguard your data. The modules of this course, PostgreSQL Playbook for Developer DBAs, stand alone and do not require you to go in order; each one will teach you how to do a different kind of task in PostgreSQL that you'll need to know as a DBA. You'll cover tasks in areas such as hardware and security, backing up and restoring your data, as well as fixing slow queries by adding indexes, and more. Finally, you'll learn about three hosted solutions for database management. By the end of this course, you will have gained several skills that you'll be able to use to perform everyday tasks on the job as a DBA.

• Course Overview 1min
• Introduction 4mins
• Optimizing Your Hardware 14mins
• Locking Things Down 19mins
• Backing up and Restoring 21mins
• Understanding Your Server 22mins
• Tuning Your Server 12mins
• Letting PostgreSQL Tell Us What's Wrong 13mins
• Fixing Slow Queries 15mins
• Optimizing Textual Queries 12mins
• Hosted Solutions 17mins