GIẢM 50% KHÓA HỌC SQL 2016

6/6/2019

GIẢM 50% HỌC PHÍ CHO KHÓA THỨ 2 (20768) hoặc

NHẬN NGAY 01 VOUCHER THI MICROSOFT QUỐC TẾ ($80.00)

Giảng viên: Microsoft Certified Trainer (MCT) 

Chứng chỉ: Microsoft Certified of Achievement

 
 

20767: Implementing a SQL Data Warehouse

 

Date: 15 - 19 Jul 2019 (5 days)

Time: 8h30am – 5:00pm

Training Fee: 12.000.000 VND

 

REGISTER NOW

 

Mục tiêu

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: 30 Jul - 01 Aug (3 days)

Time: 8h30am – 5:00pm

Training Fee: 8.000.000 VND 

 

 

REGISTER NOW

 

Mục tiêu

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