Implementing a SQL Data Warehouse (20767)

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to: • Describe the key elements of a data warehousing solution • Describe the main hardware considerations for building a data warehouse • Implement a logical design for a data warehouse • Implement a physical design for a data warehouse • Create columnstore indexes • Implementing an Azure SQL Data Warehouse • Describe the key features of SSIS • Implement a data flow by using SSIS • Implement control flow by using tasks and precedence constraints • Create dynamic packages that include variables and parameters • Debug SSIS packages • Describe the considerations for implement an ETL solution • Implement Data Quality Services • Implement a Master Data Services model • Describe how you can use custom components to extend SSIS • Deploy SSIS projects • Describe BI and common BI scenarios