In this course you will apply a variety of data warehouse engineering skills and techniques you have learned as part of the previous courses in the IBM Data Warehouse Engineer Professional Certificate. You will assume the role of a Junior Data Engineer who has recently joined the organization and be presented with a real-world use case that requires a data warehouse engineering solution.
Data Warehousing Capstone Project
This course is part of IBM Data Warehouse Engineer Professional Certificate
Instructors: Rav Ahuja
Sponsored by EdgePoint Software
2,262 already enrolled
(12 reviews)
Recommended experience
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
Add to your LinkedIn profile
1 quiz, 8 assignments
See how employees at top companies are mastering in-demand skills
Build your Data Management expertise
- 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 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
Offered by
Why people choose Coursera for their career
Recommended if you're interested in Information Technology
SkillUp EdTech
Northeastern University
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