Star Schemas
-
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.