In this capstone project, you will apply the skills and knowledge you鈥檝e gained from the IBM Relational Database Administrator Professional Certificate to some real-world database administration tasks. You鈥檒l begin by setting up an Online Transaction Processing (OLTP) database, creating a data warehouse using PostgreSQL, and querying the databases using SQL. Next, you鈥檒l build Extract, Transform, and Load (ETL) pipelines with Apache Airflow to automate data flow across systems. Plus, you鈥檒l implement backup and restore processes, starting with manual setups and then progressing to automated solutions. To ensure database security, you鈥檒l then configure user access and permissions in MySQL. You鈥檒l optimize memory usage and improve query performance to enhance database efficiency. By the end of the course, you鈥檒l have demonstrated and applied key aspects of database administration. An ideal addition to your portfolio! If you鈥檙e looking to get hands-on experience in database administration that you can talk about in interviews, enroll today!
Assignment Overview: Data Warehouse Design & Setup
Loading...
Skills You'll Learn
Data Pipelines, Performance Tuning, Data Security, Operational Databases, Data Warehousing, Relational Databases, Data Import/Export, Database Administration, Extract, Transform, Load, SQL, Database Design, Database Architecture and Administration, Database Management, MySQL, Data Maintenance, IT Automation, Data Encryption Standard, Apache Airflow
From the lesson
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.
Taught By
Abhishek Gagneja
Python and AI Subject Matter Expert
Rav Ahuja
CCO & Global Program Director