Monthly Subscription Starting at AED 99 + VAT

Data Warehousing Capstone Project
  • Level Professional
  • Duration 11 hours
  • Course by IBM
  • Offered by

About

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.

Modules

Introduction to Capstone Project

    • 1 Videos
    • 1 Plugin
Show info about module content

1 Videos

  • Introduction to Capstone Project

OLTP Database

    • 1 Videos
    • 1 ExternalTool
    • 1 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Checklist: OLTP Database
  • Graded Quiz: OLTP Database

1 External Tool

  • Hands-on Lab: OLTP Database

1 Videos

  • Assignment Overview

Data Warehouse Design and Setup

    • 1 Videos
    • 1 Quiz
    • 1 ExternalTool
Show info about module content

1 External Tool

  • Hands-on Lab: Data Warehousing

1 Videos

  • Assignment Overview: Data Warehouse Design & Setup

1 Quiz

  • Checklist: Data Warehousing

Data Warehouse Reporting

    • 1 Videos
    • 1 Readings
    • 2 ExternalTool
    • 1 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Checklist: Data Warehouse Reporting
  • Graded Quiz: Data Warehouse Reporting

2 External Tool

  • Hands-on Lab: Data Warehouse Reporting using PostgreSQL
  • (Optional) Obtain IBM Cloud Feature Code and Activate Trial Account

1 Videos

  • Assignment Overview: Data Warehouse Reporting

1 Readings

  • Optional Lab Information

Data Analytics Overview and Preparation

    • 1 Videos
    • 4 Readings
    • 3 Plugin
Show info about module content

1 Videos

  • Assignment Overview

4 Readings

  • (Optional): About this optional lesson with Looker Studio
  • (Optional) : Getting Started with Google Looker Studio
  • (Optional): Creating Visualizations in Reports using Looker Studio
  • (Optional) : Summary and Highlights

Dashboard Creation

    • 1 Readings
    • 2 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Checklist: Dashboard Creation
  • Graded Quiz: Dashboard Creation

1 Readings

  • Final Assignment Overview

ETL with MySQL, PostgreSQL, and Bash

    • 1 Videos
    • 1 Readings
    • 1 ExternalTool
    • 1 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Checklist: ETL
  • Graded Quiz: ETL with MySQL, PostgreSQL, and Bash

1 External Tool

  • Hands-on Lab: ETL with MySQL, PostgreSQL, and Bash

1 Videos

  • Assignment Overview: ETL & Data Pipelines

1 Readings

  • Formatting Functions in PostgreSQL

Final Submission and Peer review

    • 1 PeerReview
Show info about module content

1 Peer Review

  • Submit your Work and Review your Peers

Course Wrap Up

    • 2 Readings
Show info about module content

2 Readings

  • Congrats & Next Steps
  • Thanks from the Course Team

Auto Summary

Embark on a transformative learning journey with the "Data Warehousing Capstone Project," a comprehensive course designed for aspiring data professionals. Focused on the IT and Computer Science domain, this course offers hands-on experience where you will assume the role of a Junior Data Engineer. Throughout the program, you'll tackle a real-world use case, leveraging the data warehouse engineering skills and techniques acquired from the IBM Data Warehouse Engineer Professional Certificate series. Guided by industry experts at Coursera, this advanced course spans 660 minutes of immersive content, ensuring you gain practical and actionable knowledge. Whether you are a seasoned professional looking to refine your skills or a newcomer eager to break into the field, the course caters to a range of professional levels. Flexible subscription options, including Starter and Professional plans, make it accessible for all learners. Join this capstone project to bridge the gap between theory and practice, enhancing your expertise and preparing you for real-world challenges in data warehousing.

Rav Ahuja
Instructors

Rav Ahuja

Ramesh Sannareddy
Instructors

Ramesh Sannareddy