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: Database and Query Optimization
Loading...
Skills You'll Learn
Data Management, Query Optimization, Database Modeling, ETL Operations, Database Administration, Backup And Restore
From the lesson
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.
Taught By
Abhishek Gagneja
Python and AI Subject Matter Expert
Rav Ahuja
CCO & Global Program Director