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.
Relational Database Administration Capstone Project
Relational Database Administration Capstone Project
This course is part of IBM Relational Database Administrator Professional Certificate
Instructors: Abhishek Gagneja +1 more
Included with 
Gain insight into a topic and learn the fundamentals.
Advanced level
Recommended experience
2 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace
What you'll learn
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
Skills you'll gain
- Category: Database Design
- Category: Disaster Recovery
- Category: MySQL
- Category: Data Pipelines
- Category: Data Warehousing
- Category: Database Architecture and Administration
- Category: SQL
- Category: PostgreSQL
- Category: Apache Airflow
- Category: Operational Databases
- Category: Database Administration
- Category: Extract, Transform, Load
- Category: Performance Tuning
- Category: Data Security
- Category: Database Management
- Category: Data Architecture
Details to know
Shareable certificate
Add to your LinkedIn profile
Recently updated!
March 2025
Assessments
14 assignments
Taught in English
Build your Data Management expertise
This course is part of the IBM Relational Database Administrator Professional Certificate
When you enroll in this course, you'll also be enrolled in this Professional Certificate.
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate from IBM
There are 6 modules in this course
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.
What's included
2 videos1 reading2 assignments1 app item4 plugins
In this module, you will design and implement a data warehouse and you will then generate reports from the data in the data warehouse.
What's included
2 videos3 assignments2 app items
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.
What's included
2 videos3 assignments2 app items
In this module, you will perform back-up and restore operations on the database. You will also implement automation to streamline database management processes.
What's included
2 videos3 assignments2 app items
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.
What's included
2 videos3 assignments2 app items
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.
What's included
3 readings1 app item
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructors
Abhishek Gagneja
IBM
6 Courses198,594 learners
Rav Ahuja
IBM
55 Courses3,733,309 learners
Offered by
IBM
Why people choose Coursera for their career
Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Frequently asked questions
A capstone project is a great opportunity for you to apply your skills in a real-world context. This then enables you to demonstrate your ability to solve complex problems and show employers you are job-ready.
A capstone projects gives you the chance to create a tangible, real-world project that you can showcase to potential employers and talk about in interviews, proving your capabilities. And it really boosts your confidence too!
Completing a capstone project gives you a concrete example of your skills, which you can present to hiring managers as proof of your practical experience and problem-solving abilities. It also gives you something to talk about in interviews and chat about with peers.