PostgreSQL Playbook for Developer DBAs
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.
What you'll learn
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
- fixing slow queries by adding indexes and more
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.
Table of contents
PostgreSQL, or Postgres, is an open source relational database management system. It extends the SQL language with many other features and It supports SQL and JSON. PostgreSQL is the primary data warehouse for many web and mobile applications, storing both structured and unstructured data.
The main difference is that PostgreSQL has more functionalities than SQL, such as supporting IP Address data type, wide range of options to setup triggers, supporting JSON by default, and being completely open source.
This course will teach you the practical tasks you will need to do on the job as a database administrator. Some topics covered include:
- Optimizing hardware
- Installing PostgreSQL
- Setting up accounts
- Backing up and restoring data
- Moving data
- Using pgbench
- Installing pg_stat_statements
- Fixing slow queries
- Optimizing textual queries
- Much more
Anyone who wants to become a better database administrator should take this PostgreSQL course. Even if you aren't planning to become a DBA, this course will teach essential PostgreSQL skills for any use.
Before taking this course, it would help to have some familiarity with SQL and/or database administration.