Filter by Topic
Filter by Vendor
Implementing A SQL Data Warehouse
This course provides students with the knowledge and skills to …
What you'll learn
Describe the key elements of a data warehouse solution
Considerations for building a data warehouse
Implementing 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 of implement an ETL Solution
Implement Data Quality Services
Implement a Master Data Service model
Describe how you can use custom components to extend SSIS
Deploy SSI projects
Describe BI and common BI scenarios