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

IBM

Relational Database Administration (DBA)

IBM via edX

Overview

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.

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

Taught by

Rav Ahuja

Reviews

Start your review of Relational Database Administration (DBA)

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.