PostgreSQL Playbook for Developer DBAs
Pluralsight
Course Summary
If you're a Database Administrator looking to quickly update your skillset, this course is for you. Each module stands alone and teaches practical tasks you'll need to do on the job, such as optimizing hardware, benchmarking your server, and more.
-
+
Course 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.
-
+
Course Syllabus
Course Overview- 1m 42s
—Course Overview 1m 42sIntroduction- 4m 11s
—Introduction 2m 5s
—Tools 2m 6sOptimizing Your Hardware- 14m 55sLocking Things Down- 19m 27sBacking up and Restoring- 21m 42sUnderstanding Your Server- 22m 33sTuning Your Server- 12m 2sLetting PostgreSQL Tell Us What's Wrong- 13m 38sFixing Slow Queries- 15m 47sOptimizing Textual Queries- 12m 9sHosted Solutions- 17m 42s