IBM DB2 on Cloud
-
IBM Data Engineering Capstone Project
In this IBM sponsored project, I assumed the role of a Junior Data Engineer who has recently joined a fictional online e-Commerce company named SoftCart. Presented with real-world use cases, I was required to apply a number of industry standard data engineering solutions.
-
LAB: Watch me write a Python script that automates data synchronization between MySQL and DB2
In this lab, I was tasked with writing a Python script that automates the process of regularly synchronizing data between MySQL and DB2.
-
LAB: Watch me run aggregation queries and create a Materialized Query Table on a DB2 production data warehouse instance
In this lab, I was required to create an instance of IBM DB2, load sample datasets into their respective tables, write aggregation queries and create a Materialized Query Table for BI reporting.