Homwork 05 - Creating A ETL Processing Script

In this homework, I created a SQL ETL processing script to take data from the NorthwindLite database, transform the data, and then load it into the DWNorthwindLite database.

First I completed the list of data transformations for each column and then placed the SQL transformation code in the Instructor's spreadsheet:

After, I used the starter ETL script to help test the SQL transformation code:

Finally once I completed the Starter script, I put it all together in a clean single ETL script that wipes the DWNorthwindLite database and then fills it back up from the NorthwindLite database: