IBM
Data Warehousing Capstone Project
IBM

Data Warehousing Capstone Project

This course is part of IBM Data Warehouse Engineer Professional Certificate

Taught in English

Some content may not be translated

Rav Ahuja
Ramesh Sannareddy

Instructors: Rav Ahuja

1,539 already enrolled

Included with Coursera Plus

Course

Gain insight into a topic and learn the fundamentals

Intermediate level

Recommended experience

11 hours (approximately)
Flexible schedule
Learn at your own pace

What you'll learn

  • Demonstrate proficiency in skills required for an entry-level data warehouse engineering role.

  • Design and implement various concepts and components in the data warehouse engineering lifecycle such as data repositories.

  • Showcase working knowledge with relational databases, data warehouses, and data pipelines.

  • You can use your expertise in Linux shell scripting, SQL, and business intelligence Cognos dashboard design, to tackle data warehousing problems.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

9 quizzes

Course

Gain insight into a topic and learn the fundamentals

Intermediate level

Recommended experience

11 hours (approximately)
Flexible schedule
Learn at your own pace

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

Placeholder

Build your Data Management expertise

This course is part of the IBM Data Warehouse Engineer 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
Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 5 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 quizzes1 app item2 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 videos1 reading3 quizzes3 app items1 plugin

In this module, you will assume the role of a data engineer at an e-commerce company. Your company has finished setting up a data warehouse. Now you are assigned the responsibility to design a reporting dashboard that reflects the key metrics of the business.

What's included

1 video2 quizzes1 app item2 plugins

In this module, you will set up an ETL process using a Shell script to extract new transactional data for each day from the MySQL database and load it into the staging data warehouse in PostgreSQL. Later you will perform the transformation on the table in the staging warehouse to load the data in a dimension table and a fact table. You will then export these tables as CSV files to the production warehouse. You will set up a Cron Job to schedule these tasks.

What's included

1 video1 reading2 quizzes1 app item1 plugin

In this final module, you will complete your submission of screenshots from the hands-on labs for your peers to review. Once you have completed your submission you will then review the submission of one of your peers and grade their submission.

What's included

2 readings1 peer review

Instructors

Rav Ahuja
IBM
53 Courses2,368,801 learners
Ramesh Sannareddy
IBM
11 Courses205,950 learners

Offered by

IBM

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.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,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