Why is a capstone project important?

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.

How does a capstone project benefit you?

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!

How does a capstone project improve your job prospects?

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.

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.

When will I have access to the lectures and assignments?

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.

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

4 days left! Save on skills that make you shine with 40% off 3 months of Coursera Plus. 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!

Module details

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 videosTotal 5 minutes

Course Introduction3 minutes
Assignment Overview: OLTP Database2 minutes

1 readingTotal 5 minutes

Prerequisites and Course Syllabus5 minutes

2 assignmentsTotal 36 minutes

Checklist: OLTP Database24 minutes
Graded Quiz: OLTP Database12 minutes

1 app itemTotal 30 minutes

Lab: OLTP Database30 minutes

4 pluginsTotal 40 minutes

Helpful Tips for Course Completion15 minutes
Reading: Project Overview15 minutes
Reading: Data Platform Architecture5 minutes
OLTP Database Requirements and Design5 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 videosTotal 4 minutes

Assignment Overview: Data Warehouse Design & Setup2 minutes
Assignment Overview: Data Warehouse Reporting1 minute

3 assignmentsTotal 69 minutes

Checklist: Data Warehousing15 minutes
Checklist: Data Warehouse Reporting24 minutes
Graded Quiz: Build a Data Warehouse30 minutes

2 app itemsTotal 120 minutes

Lab: Data Warehousing60 minutes
Lab: Data Warehouse Reporting using PostgreSQL60 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 videosTotal 4 minutes

Assignment Overview: ETL2 minutes
Assignment Overview: Data Pipelines using Apache Airflow2 minutes

3 assignmentsTotal 66 minutes

Checklist: ETL 9 minutes
Checklist: Data Pipelines using Apache Airflow27 minutes
Graded Quiz: ETL and Data Pipelines30 minutes

2 app itemsTotal 90 minutes

Lab: ETL60 minutes
Lab: Data Pipelines using Apache Airflow30 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 videosTotal 3 minutes

Assignment Overview: Database Backup and Restoration2 minutes
Assignment Overview: Backup and Restore Automation1 minute

3 assignmentsTotal 66 minutes

Checklist: Database Backup and Restoration18 minutes
Checklist: Backup and Restore Automation27 minutes
Graded Quiz: Backup, Restore, and Automation 21 minutes

2 app itemsTotal 120 minutes

Lab: Database Backup and Restoration60 minutes
Lab: Backup and Restore Automation60 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 videosTotal 3 minutes

Assignment Overview: Database and Query Optimization2 minutes
Assignment Overview: Access Management and Database Security2 minutes

3 assignmentsTotal 72 minutes

Checklist: Database and Query Optimization24 minutes
Checklist: Access Management and Database Security27 minutes
Graded Quiz: Database Optimization, Security, and Access Management21 minutes

2 app itemsTotal 120 minutes

Lab: Database and Query Optimization60 minutes
Lab: Access Management and Database Security60 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.