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!

In this module, you will design a data platform that uses MySQL as an OLTP database. You will be using MySQL to store the OLTP data.

In this module, you will design and implement a data warehouse and you will then generate reports from the data in the data warehouse.

Module 3: ETL and Data Pipelines
In this module, you will use the given Python script to perform various ETL operations that load the data warehouse with the required information. You will also write a pipeline that analyzes the web server log file, extracts the required lines and fields, and transforms and loads data.

In this module, you will perform back-up and restore operations on the database. You will also implement automation to streamline database management processes.

In this module, you will optimize the query performance and memory utilization of your database. You will also implement data security protocols, including user access management strategies and data encryption.

In this module, you will organize and submit your project deliverables for final evaluation. This module guides you through the submission process and outlines the criteria for assessing your work. 

Proficiency in SQL, MySQL, PostgreSQL, ETL, Apache Airflow, and database creation, administration, and security principles is required.