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 DBA Administrator Capstone Project
Relational DBA Administrator Capstone Project
This course is part of IBM Relational Database Administrator Professional Certificate
Instructors: Abhishek Gagneja
Included with 
Gain insight into a topic and learn the fundamentals.
Advanced level
Recommended experience
9 hours to complete
3 weeks at 3 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 perform queries using 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, and set up user access management policies, optimize SQL queries, and troubleshoot issues
Details to know
Shareable certificate
Add to your LinkedIn profile
Assessments
9 assignments
Taught in English
See how employees at top companies are mastering in-demand skills
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
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
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 videos2 assignments1 app item3 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 move data from RDBMS to NoSQL, NoSQL to RDBMS, and from RDBMS, NoSQL to the data warehouse. You will 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 videos1 assignment2 app items
In this module, you will optimize query performance, implement database security and define access management strategies. You will also learn how to fine-tune SQL queries for better efficiency, and troubleshoot common database issues.
What's included
3 videos
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
2 readings
Offered by
Recommended if you're interested in Data Management
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."
New to Data Management? Start here.
Open new doors with Coursera Plus
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose Coursera for Business
Upskill your employees to excel in the digital economy
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.