Relational Database Administration Capstone Project

Course Overview

In this capstone project, you will apply the skills and knowledge you’ve gained from the IBM Relational Database Administrator Professional Certificate to some real-world database administration tasks. You’ll begin by setting up an Online Transaction Processing (OLTP) database, creating a data warehouse using PostgreSQL, and querying the databases using SQL. Next, you’ll build Extract, Transform, and Load (ETL) pipelines with Apache Airflow to automate data flow across systems. Plus, you’ll implement backup and restore processes, starting with manual setups and then progressing to automated solutions. To ensure database security, you’ll then configure user access and permissions in MySQL. You’ll optimize memory usage and improve query performance to enhance database efficiency. By the end of the course, you’ll have demonstrated and applied key aspects of database administration. An ideal addition to your portfolio! If you’re looking to get hands-on experience in database administration that you can talk about in interviews, enroll today!