Relational Database Administration (DBA)

Categories: Data Engineering Professional Certificate, Data Programs

Create, query, and configure databases and access and build system objects such as tables.
Perform basic database management including backing up and restoring databases as well as managing user roles and permissions.
Monitor and optimize important aspects of database performance.
Troubleshoot database issues such as connectivity, login, and configuration and automate functions such as reports, notifications, and alerts.

Course Content

Module 1: Introduction to Database Management

Day in the Life of a Database Administrator

00:00
Database Management Lifecycle

00:00
Database Objects

00:00
System Objects and Database Configuration

00:00
Database Storage

00:00

3 readings

4 quizzes

3 app items

4 plugins

Module 2: Managing Databases

Introduction to Backup and Restore

00:00
Types of Backup

00:00
Backup Policies

00:00
Using Database Transaction Logs for Recovery

00:00
Overview of Database Security

00:00
Users, Groups, and Roles

00:00
Managing Access to Databases and Their Objects

00:00
Auditing Database Activity

00:00
Encrypting Data

00:00

2 readings

4 quizzes

5 app items

2 plugins

Module 3: Monitoring and Optimization

2 readings

2 quizzes

3 app items

1 plugin

Module 4: Troubleshooting and Automation

1 reading

2 quizzes

2 app items

Module 5: Final Assignment and Final Exam

Student Ratings & Reviews

No Review Yet

No Review Yet

error: Content is protected !!