Implementing an SQL Data Warehouse (20767)
Details
Outline
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.
At Course Completion:
- 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 Service
- 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
Speaker/s
Special Offer
- Courseware (please indicate if you would prefer a hard copy or e-book)
- Online labs for up to 180 days
- Full technical support for 3 months following delivery, for this course.
We are here to promote the core values of our vendors. We promote learning courses and courseware which has been approved by vendors to be accurate and the best material on the market to ensure that you learn the content with a view to certifying in the same area of study.
Our team of delivery specialists, training staff and proctoring team are guided by the principles, codes and requirements of our vendors. We can assure you that the training you will get will be correct and is as was intended by the vendor.
Our trainers are all experienced in their respective fields. Vendor requirements have been met.
In the case of Microsoft training, both public and private courses are provided using:
- active, current Microsoft Certified Trainers experienced in the area who have passed the relevant certification exam.
- official courseware and virtual lab materials only.
- Course management provided in association with a Certified Partner for Learning Solutions (CPLS) centre training provider (where it has not been possible for MBIT to manage the course directly ourselves). ...