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
Data Warehousing Capstone Project
This course is part of IBM Data Warehouse Engineer Professional Certificate
Instructors: Rav Ahuja +1 more
2,185 already enrolled
Included with 
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
- Category: Extraction, Transformation And Loading (ETL)
- Category: Data Warehousing
- Category: OLTP Databases
- Category: Relational Database
- Category: Data Pipelines
Details to know
Shareable certificate
Add to your LinkedIn profile
Assessments
1 quiz, 8 assignments
Taught in English
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
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
Instructors
Rav Ahuja
IBM
53 Courses3,051,752 learners
Ramesh Sannareddy
IBM
12 Courses328,599 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."
Frequently asked questions
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. 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.
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. If you only want to read and view the course content, you can audit the course for free.
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.