Relational Database Administration (DBA) (edX)

Relational Database Administration (DBA) (edX)
Course Auditing
Categories
Effort
Certification
Languages
Misc

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Relational Database Administration (DBA) (edX)
This course helps you develop the foundational skills required to perform the role of a Database Administrator (DBA) including designing, implementing, securing, maintaining, troubleshooting and automating databases such as MySQL, PostgreSQL and Db2.

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Managing databases is a critical skill for Data Engineers and Database Administrators to ensure data is reliable, protected and easily accessible for organizations to make better decisions, solve problems and create business value.

With the amount of data continually expanding and business leaders focused on building data-literate organizations, it’s no surprise that Database Administrators are in high demand and earn a median salary of US $98,860 per year according to the US Bureau of Labor Statistics.

This course provides you with the knowledge and hands-on experience to manage and maintain databases, understand database security, design and define database schemas, tables, views, and other database objects, describe storage, perform backups and recovery, troubleshoot errors, monitor and optimize performance and automate tasks.

This course includes hands-on practice labs and a real-world inspired project to add to your portfolio that will demonstrate your ability to perform the Database Administration tasks using relational databases (RDBMSes) such as MySQL, PostgreSQL and IBM Db2.

Prior knowledge of database fundamentals and SQL is required to complete this course.

This course is part of the Data Engineering Professional Certificate and Data Engineering Professional Certificate.


What you'll learn

- Describe common database administration tasks.

- Define database security measures and create users, groups and roles.

- Perform full and incremental backup and restore procedures.

- Configure a database server including various database parameters and logging.

- Create and manage database objects including tables, schemas, keys and indexes.


Syllabus


Module 1: Introduction to Database Management

Day in the Life of a Database Administrator

Database Management Lifecycle

Database Objects

System Objects and Database Configuration

Database Storage

Module 2: Managing Databases

Types of Backup

Backup Policies

Using Database Transaction Logs for Recovery

Overview of Database Security

Users, Groups, and Roles

Managing Access to Databases and Their Objects

Auditing Database Activity

Encrypting Data

Module 3: Monitoring and Optimization

Overview of Database Monitoring

Monitoring Usage and Performance - Part 1

Monitoring Usage and Performance - Part 2

Using Indexes

Module 4: Troubleshooting and Automation

Troubleshooting Common Issues

Using Status Variables, Error Codes, and Documentation

Using Logs for Troubleshooting

Overview of Automating Database Tasks

Automating Reports and Alerts

Module 5: Final Project



MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Course Auditing
87.00 EUR

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.