How long does it take to complete the course?

It will take six weeks to complete this course if you spend 2–3 hours of study time per week.

Do I need any background knowledge to complete this course successfully?

Knowledge of database querying, MySQL, Apache Airflow, Kafka, database administration, and security principles is required.

Which roles can I perform after completing this course?

You can take on roles such as Database Administrator, Data Engineer, ETL Developer, Data Architect, Business Intelligence Developer, Data Analyst, Solutions Architect, Cloud Data Engineer, or Systems Analyst.

Do I need any specific software or tools to complete the course successfully?

You will need a laptop or desktop computer with a modern web browser and a reliable internet connection.

What will I get if I subscribe to this Certificate?

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Relational Database Administration Capstone Project

Grow your skills with Coursera Plus for $239/year (usually $399). Save now.

Relational Database Administration Capstone Project

This course is part of IBM Relational Database Administrator with GenAI Professional Certificate

Instructors: Abhishek Gagneja

Included with

Learn more

6 modules

Gain insight into a topic and learn the fundamentals.

16 reviews

Advanced level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

6 modules

Gain insight into a topic and learn the fundamentals.

16 reviews

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

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

14 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your Data Management expertise

This course is part of the IBM Relational Database Administrator with GenAI 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 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’ll implement backup and restore processes, starting with manual setups and then progressing to automated solutions. To ensure database security, you’ll then configure user access and permissions in MySQL. You’ll optimize memory usage and improve query performance to enhance database efficiency. By the end of the course, you’ll have demonstrated and applied key aspects of database administration. An ideal addition to your portfolio! If you’re looking to get hands-on experience in database administration that you can talk about in interviews, enroll today!

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

2 videos Total 5 minutes

Course Introduction 3 minutes
Assignment Overview: OLTP Database 2 minutes

1 reading Total 5 minutes

Prerequisites and Course Syllabus 5 minutes

2 assignments Total 36 minutes

Checklist: OLTP Database 24 minutes
Graded Quiz: OLTP Database 12 minutes

1 app item Total 30 minutes

Lab: OLTP Database 30 minutes

4 plugins Total 40 minutes

Helpful Tips for Course Completion 15 minutes
Reading: Project Overview 15 minutes
Reading: Data Platform Architecture 5 minutes
OLTP Database Requirements and Design 5 minutes

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

2 videos Total 4 minutes

Assignment Overview: Data Warehouse Design & Setup 2 minutes
Assignment Overview: Data Warehouse Reporting 1 minute

3 assignments Total 69 minutes

Checklist: Data Warehousing 15 minutes
Checklist: Data Warehouse Reporting 24 minutes
Graded Quiz: Build a Data Warehouse 30 minutes

2 app items Total 120 minutes

Lab: Data Warehousing 60 minutes
Lab: Data Warehouse Reporting using PostgreSQL 60 minutes

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

2 videos Total 4 minutes

Assignment Overview: ETL 2 minutes
Assignment Overview: Data Pipelines using Apache Airflow 2 minutes

3 assignments Total 66 minutes

Checklist: ETL 9 minutes
Checklist: Data Pipelines using Apache Airflow 27 minutes
Graded Quiz: ETL and Data Pipelines 30 minutes

2 app items Total 90 minutes

Lab: ETL 60 minutes
Lab: Data Pipelines using Apache Airflow 30 minutes

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

2 videos Total 3 minutes

Assignment Overview: Database Backup and Restoration 2 minutes
Assignment Overview: Backup and Restore Automation 1 minute

3 assignments Total 66 minutes

Checklist: Database Backup and Restoration 18 minutes
Checklist: Backup and Restore Automation 27 minutes
Graded Quiz: Backup, Restore, and Automation 21 minutes

2 app items Total 120 minutes

Lab: Database Backup and Restoration 60 minutes
Lab: Backup and Restore Automation 60 minutes

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

2 videos Total 3 minutes

Assignment Overview: Database and Query Optimization 2 minutes
Assignment Overview: Access Management and Database Security 2 minutes

3 assignments Total 72 minutes

Checklist: Database and Query Optimization 24 minutes
Checklist: Access Management and Database Security 27 minutes
Graded Quiz: Database Optimization, Security, and Access Management 21 minutes

2 app items Total 120 minutes

Lab: Database and Query Optimization 60 minutes
Lab: Access Management and Database Security 60 minutes

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 Courses 276,717 learners

Rav Ahuja

IBM

55 Courses 4,893,320 learners

Offered by

IBM

Explore more from Data Management

IBM
Relational Database Administration (DBA)
Course
Meta
Database Engineer Capstone
Course
IBM
IBM Relational Database Administrator with GenAI
Professional Certificate
SkillUp
Data Management Capstone Project
Course

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."

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

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

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.

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

Relational Database Administration Capstone Project

Relational Database Administration Capstone Project

What you'll learn

Skills you'll gain

Tools you'll learn

Details to know

See how employees at top companies are mastering in-demand skills

Build your Data Management expertise

There are 6 modules in this course

Data Platform Architecture and OLTP Database

What's included

Build a Data Warehouse

What's included

ETL and Data Pipelines

What's included

Backup, Restore, and Automation

What's included

Database Optimization, Security, and Access Management

What's included

Final Submission

What's included

Earn a career certificate

Instructors

Offered by

Explore more from Data Management

Relational Database Administration (DBA)

Database Engineer Capstone

IBM Relational Database Administrator with GenAI

Data Management Capstone Project

Why people choose Coursera for their career

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.

Open new doors with Coursera Plus

Advance your career with an online degree

Join over 3,400 global companies that choose Coursera for Business

Frequently asked questions

Why is a capstone project important?

How does a capstone project benefit you?

How does a capstone project improve your job prospects?

More questions