Skip to main content

IBM: Relational Database Administration (DBA)

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.

Relational Database Administration (DBA)
8 weeks
2–3 hours per week
Self-paced
Progress at your own speed
Free
Optional upgrade available

There is one session available:

After a course session ends, it will be archivedOpens in a new tab.
Starts Apr 18
Ends Aug 31
Enroll
Relational Database Administration (DBA)

About this course

Skip About this course

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.

At a glance

  • Language: English
  • Video Transcript: English
  • Associated programs:
  • Associated skills:Database Security, Database Administration, PostgreSQL, SQL (Programming Language), Relational Databases, Backup Devices, MySQL, Troubleshooting (Problem Solving), Automation

What you'll learn

Skip 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

Skip 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

Who can take this course?

Unfortunately, learners residing in one or more of the following countries or regions will not be able to register for this course: Iran, Cuba and the Crimea region of Ukraine. While edX has sought licenses from the U.S. Office of Foreign Assets Control (OFAC) to offer our courses to learners in these countries and regions, the licenses we have received are not broad enough to allow us to offer this course in all locations. edX truly regrets that U.S. sanctions prevent us from offering all of our courses to everyone, no matter where they live.

This course is part of Data Engineering Professional Certificate Program

Learn more 
Expert instruction
14 skill-building courses
1 year 2 months
3 - 4 hours per week

Ways to take this course

Choose your path when you enroll.

Certificate

Free

Price

$99 USD

-

Access to course materials

Unlimited

Limited

Expires on Jun 13

World-class institutions and universities

edX support

Shareable certificate upon completion

Graded assignments and exams

Read our FAQsin a new tab about frequently asked questions on these tracks.

Interested in this course for your business or team?

Train your employees in the most in-demand topics, with edX For Business.
Purchase nowRequest information