MySQL
-
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 configure a MySQL database to store Online Transactional Processing data
In this lab, I was required to design a database schema, create a database to store sales data based on sample data, create an index on the timestamp column and write an administrative bash script that exports sales data into a SQL file.