Need some help ? Call us:+32 2 503 40 40
Back

N° 20767 : Implementing a SQL Database Warehouse

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

After completing 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

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.

You might also be interested in:

N° 10986B : Updating Your Skills to SQL Server 2016

This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.

N° 10985C : Introduction to SQL Databases

This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.

N° 10998A : Updating Your Skills to SQL Server 2017

This two-day instructor led training course is aimed at database professionals looking to update their skills to cover SQL Server 2017.