028 3824 5819 traincert@tdt-tanduc.com
Tiếng ViệtEnglish

MCSA SQL 2016 BI Development - Mua 1 tặng 1

BUY 1 GET 1 FREE

Training Fee10.000.000 for 02 courses (package)

Trainer: Microsoft Certified Trainer (MCT) 

Certificate: Microsoft Certified of Achievement

20767: Implementing a SQL Data Warehouse

 

Date: 3 – 7  Dec, 2018 (5 days)

Time: 8h30am – 5:00pm

 

REGISTER NOW

Objective

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 column store 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

View moreclick here

 

20768: Developing SQL Data Models

 

Date: 17 – 19 Dec, 2018 (3 days)

Time: 8h30am – 5:00pm

 

 

REGISTER NOW

Objective

After completing this course, students will be able to:

  • Describe the components, architecture, and nature of a BI solution
  • Create a multidimensional database with Analysis Services
  • Implement dimensions in a cube
  • Implement measures and measure groups in a cube
  • Use MDX syntax
  • Customize a cube
  • Implement a tabular database
  • Use DAX to query a tabular model
  • Use data mining for predictive analysis

View moreclick here

For more training program please click here

KH1
KH 2
KH6
KH 3
KH4
KH 5
Top