PostgreSQL
-
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 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.