Labs
-
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 design a data warehouse schema on PostgreSQL using pgAdmin ERD
In this lab, I was tasked with designing a data warehouse star schema using pgAdmin’s ERD Design tool, exporting the schema SQL and creating a staging database.
-
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.