Managing databases is an essential skill for Data Engineers and Database Administrators (DBAs) 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 $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.

The course includes hands-on practice labs and a real-world inspired project to add to your portfolio, demonstrating your ability to perform Database Administration tasks using relational databases (RDBMSs) such as MySQL, PostgreSQL, and IBM Db2.

What you will learn:

After completing this course, you will be able to:

Explain 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 Syllabus

Module 1 : Introduction to Database Management

Module Introduction and Learning Objectives
Introduction to Relational Database Administration
Day in the Life of a Database Administrator
Database Management Lifecycle
Data Security, Ethical and Compliance Considerations
Reading: Data Security, Ethical and Compliance Considerations
Hands-on Lab: Sign up for IBM Cloud and Create Db2 service instance
Summary & Highlights
Practice Quiz: Overview of Database Management Tasks
Graded Quiz: Overview of Database Management Tasks
Database Objects
System Objects and Database Configuration
Database Storage
Storage Engines in MYSQL
Hands-on Lab: Db2 System Tables
Hands-on Lab: MySQL Configuration, Storage Engines, and System Tables
Hands-on Lab: PostgreSQL Instance Configuration and System Catalog
Summary & Highlights
Practice Quiz: Server Objects and Hierarchy
Graded Quiz: Server Objects and Hierarchy

Module 2: Managing Databases

Module Introduction and Learning Objectives
Backup and Restore Databases
Introduction to Backup and Restore
Types of Backup
Backup Policies
Using Database Transaction Logs for Recovery
Hands-on Lab: Loading / Importing and Exporting using Db2
Hands-on Lab: Backup and Restore using PostgreSQL
Hands-on Lab: Backup and Restore using MySQL
Summary & Highlights
Practice Quiz: Back Up and Restore Databases
Graded Quiz: Back Up and Restore Databases
Overview of Database Security
Users, Groups, and Roles
Managing Access to Databases and their Objects
Auditing Database Activity
Encrypting Data
User Management with DB2
Hands-on Lab: MySQL User Management, Access Control, and Encryption
Hands-on Lab: User Management and Access Control in PostgreSQL
Summary & Highlights
Practice Quiz: Security and User Management
Graded Quiz: Security and User Management

Module 3: Monitoring and Optimization

Module Introduction and Learning Objectives
Overview of Database Monitoring
Monitoring Usage and Performance - Part 1
Monitoring Usage and Performance - Part 2
Optimizing Databases
Optimizing Queries
Using Indexes
Reading: Improving Peformance of Slow Queries in MySQL
Hands-on Lab: Improving Performance of Slow Queries in MySQL
Reading: Monitoring and Optimizing your Databases in MySQL
Hands-on Lab: Monitoring and Optimizing your Databases in MySQL
Hands-on Lab: Monitoring and Optimizing your Databases in PostgreSQL
Summary & Highlights
Practice Quiz: Monitoring and Optimization
Graded Quiz: Monitoring and Optimization

Module 4: Troubleshooting & Automation

Module Introduction and Learning Objectives
Troubleshooting Common Issues
Using Status Variables, Error Codes, and Documentation
Using Logs for Troubleshooting
Hands-on Lab: Troubleshooting with PostgreSQL
Overview of Automating Database Tasks
Automating Reports and Alerts
Hands-on Lab: Automating MySQL Database Tasks using Shell Scripts
Summary & Highlights
Practice Quiz: Troubleshooting and Automation
Graded Quiz: Troubleshooting and Automation

Module 5: Final Assignment and Final Exam

Module Introduction and Learning Objectives
Instructions for Peer-graded assignment
Claim IBM Cloud Feature code
Hands-on Lab: Database Administration - Part 1 (Postgres)
Hands-on Lab: Database Administration - Part 2 (MySQL)
Hands-on Lab: Database Administration - Part 3 (DB2)
Peer Review: Project Submission & Peer Review
Graded Quiz: Final Quiz
Congrats & Next Steps
Team & Acknowledgements

General Information

This course is self-paced.
This platform works best with current versions of Chrome, Edge, Firefox, Internet Explorer, or Safari.

Recommended Skills Prior to Taking this Course

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

RDBMS Database Administration (DBA)

Language

Topic

Skills You Will Learn

Offered By

Estimated Effort

Platform

Last Update