08 3 824 5819 traincert@tdt-tanduc.com
Tiếng ViệtEnglish

20767: Implementing a SQL Data 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.

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.  

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.
  • Some experience with database design.

After completing this course, students will be able to:

  • Provision a Database Server.
  • Upgrade SQL Server.
  • Configure SQL Server.
  • Manage Databases and Files (shared).

Module 1: Introduction to Data Warehousing

Module 2: Planning Data Warehouse Infrastructure 

Module 3: Designing and Implementing a Data Warehouse

Module 4: Columnstore Indexes

Module 5: Implementing an Azure SQL Data Warehouse

Module 6: Creating an ETL Solution

Module 7: Implementing Control Flow in an SSIS Package

Module 8: Debugging and Troubleshooting SSIS Packages

Module 9: Implementing a Data Extraction Solution

Module 10: Enforcing Data Quality

Module 11: Using Master Data Services

Module 12: Extending SQL Server Integration Services (SSIS)

Module 13: Deploying and Configuring SSIS Packages

Module 14: Consuming Data in a Data Warehouse

 

Vui lòng bấm "Course Outline" để xem thêm nội dung chi tiết.

Thời lượng: 05 ngày
Giảng viên: Microsoft Certified Trainer
Chứng nhận hoàn thành khóa học của Microsoft

Các khóa học liên quan
KH1
KH 2
KH6
KH 3
KH4
KH 5
Top