Tel: 1300 TO TRAIN

Email: info@advancedtraining.com.au

IT Training with Advanced Training



MOC On-Demand: Implementing a SQL Data Warehouse


MOC On-Demand

MOC On-Demand is an integrated blend of video, text, hands-on labs, and knowledge checks, designed to help IT professionals and developers build their skills on Microsoft technologies. The courses provide a self-paced, stand-alone training alternative for those who prefer to learn at their own convenience. They can also be used in conjunction with instructor-led training to provide a blended classroom experience or be used as a foundation for a training solution that includes mentoring and other learning services.

Implementing a SQL Data Warehouse

About this course

This course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 data-base. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install. 

Audience Profile

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:

At the completion of this course participants 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.
Install and configure Windows Server 2012.



User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: OD20767
  • Duration: 90 Days
  • Price: $1,089.00

Next Step

Enquire Now
Tell a Friend