IBM
Data Warehousing Capstone Project
IBM

Data Warehousing Capstone Project

Rav Ahuja
Ramesh Sannareddy

Instructors: Rav Ahuja

Sponsored by Coursera Learning Team

2,259 already enrolled

Gain insight into a topic and learn the fundamentals.
4.6

(12 reviews)

Intermediate level

Recommended experience

13 hours to complete
3 weeks at 4 hours a week
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
4.6

(12 reviews)

Intermediate level

Recommended experience

13 hours to complete
3 weeks at 4 hours a week
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.

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

1 quiz, 8 assignments

Taught in English

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 assignments1 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 reading1 quiz2 assignments3 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 video5 readings2 assignments5 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 assignments1 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 Courses3,132,388 learners
Ramesh Sannareddy
IBM
12 Courses338,258 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."

Recommended if you're interested in Information Technology

Placeholder

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