Hands On Training

Relational Database Administration (DBA)

IBM

via

edX

Course Features

Duration

8 weeks

Delivery Method

Online

Available on

Limited Access

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Beginner

Effort

3 hours per week

Teaching Type

Self Paced

Course Description

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.

Course Overview

International Faculty

Post Course Interactions

Instructor-Moderated Discussions

Skills You Will Gain

What You Will 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.

Course Content

Expand all sections

Module 1: Introduction to Database Management

Module 2: Managing Databases

Module 3: Monitoring and Optimization

Module 4: Troubleshooting and Automation

Course Instructors

Rav Ahuja

AI and Data Science Program Director

Rav Ahuja is a Global Program Director at IBM. He leads growth strategy, curriculum creation, and partner programs for the IBM Skills Network. Rav co-founded Cognitive Class, an IBM led initiative to...