20767 Implementing a SQL Data Warehouse
Course Summary
Training level | MOC |
Duration | 3 days / 24 Hours |
Delivery method | In Class |
Level | 300 |
Language | Bulgarian/English |
List price | 500 Euro VAT Excl. |
Click Tabs for Detailed info
Microsoft Official Course – 20767
- The primary audience for this course are database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.
-
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
- Module 1: Introduction to Data Warehousing
- Module 2: Planning Data Warehouse Infrastructure
- Module 3: Designing and Implementing a Data Warehouse
- Module 4: Columnstore Indexes
- Module 5: Implementing an Azure SQL Data Warehouse
- Module 6: Creating an ETL Solution
- Module 7: Implementing Control Flow in an SSIS Package
- Module 8: Debugging and Troubleshooting SSIS Packages
- Module 9: Implementing a Data Extraction Solutions
- Module 10: Enforcing Data Quality
- Module 11: Using Master Data Services
- Module 12: Extending SQL Server Integration Services (SSIS)
- Module 13: Deploying and Configuring SSIS Packages
- Module 14: Consuming Data in a Data Warehouse
Next planned dates:
Trainer: Ivan Donev

Reserve your seat
Reserving a seat does not imply any obligations for payment