Relational Database Administration Capstone Project

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 automa…