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!
Overview
Syllabus
- Data Platform Architecture and OLTP Database
- 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.
- Build a Data Warehouse
- In this module, you will design and implement a data warehouse and you will then generate reports from the data in the data warehouse.
- 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, transforms and loads data.
- Backup, Restore, and Automation
- In this module, you will perform back-up and restore operations on the database. You will also implement automation to streamline database management processes.
- Database Optimization, Security, and Access Management
- 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.
- Final Submission
- 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.
Taught by
Abhishek Gagneja and Rav Ahuja
