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’l

• Gain real-world, hands-on experience in database administration that you can discuss in interviews and showcase in your portfolio
• Design and implement OLTP and data warehouse schemas, manage data, and query data in MySQL and PostgreSQL
• Perform ETL operations, extract data from RDBMS, NoSQL databases, and weblogs, and manage pipelines using Apache Airflow
• Apply backup, restore policies, automate the process, set up user access management policies, encrypt data, and optimize SQL queries