SQL
-
Census ACS5 Data Pipeline
In this project I utilized Python, SQL, and AWS to design and develop an ETL pipeline that extracts and visualizes data from the official Census ACS5 Survey API. This project serves as an exercise in developing data architectures that allow for easy access of real data that provides valuable insights to drive positive change in education outcomes in the US.
-
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.
-
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.