Description
Course info
Level
Intermediate
Updated
Apr 5, 2016
Duration
2h 36m
Description

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.

About the author
About the author

Rob Conery co-founded Tekpub and created This Developer's Life. He is an author, speaker, and sometimes a little bit opinionated.

More from the author
Electron Playbook
Intermediate
1h 38m
Mar 2, 2016
More courses by Rob Conery
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Rob Conery and welcome to the PostgreSQL Playbook for Developer DBAs. Pluralsight's Playbook Series is a little bit different from typical courses that you find here at Pluralsight. Instead of focusing on concepts and progressively building up a demo, in this Playbook course we'll focus on individual tasks. Each module is designed to stand on its own but can also be watched as a whole. In this playbook you'll learn the essential tasks you'll need to know as a brand new database administrator otherwise known as a DBA. Being a DBA is one of the most rewarding jobs in the tech industry if you know some essential skills. Your boss and coworkers will think you're a miracle worker when you speed things up by orders of magnitude simply by applying some much needed, well targeted indexing. Perhaps you can save a few lines of code while at the same time securing your projects data by wrapping a few commands into a function. This job can be exceedingly fun. You just need to learn a few skills first. That's where this course comes in. We'll start you off in your new role by discussing issues such as hardware, security, backing up and restoring. You'll benchmark your server and teach it how to tell you what's wrong and how you can fix it. You'll learn how to spot troublesome queries before they drag your database down. Even if you're not planning on becoming a developer DBA these skills are essential for anyone working with PostgreSQL. So I hope you join me and watch the PostgreSQL Playbook for Developer DBAs.