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

  Training schedule for "Implementing a SQL Data Warehouse - Course 20767-C Course"

November
2024
25
Mon
26
Tue
27
Wed
One to One - Online
09:00-17:00 (EST)
AT7780V243301
1,590 €
30 November 2024 - 3 Dec
One to One - Online
09:00-17:00 (EST)
AT7780V243351
1,590 €
December
2024
9
Mon
10
Tue
11
Wed
One to One - Online
09:00-17:00 (EST)
AT7780V243441
1,590 €
December
2024
14
Sat
15
Sun
16
Mon
One to One - Online
09:00-17:00 (EST)
AT7780V243491
1,590 €
1,450 €
Early bird discount
December
2024
23
Mon
24
Tue
25
Wed
One to One - Online
09:00-17:00 (EST)
AT7780V243581
1,590 €
1,450 €
Early bird discount
December
2024
28
Sat
29
Sun
30
Mon
One to One - Online
09:00-17:00 (EST)
AT7780V243631
1,590 €
1,450 €
Early bird discount
January
2025
6
Mon
7
Tue
8
Wed
One to One - Online
09:00-17:00 (EST)
AT7780V250061
1,590 €
1,450 €
Early bird discount
January
2025
11
Sat
12
Sun
13
Mon
One to One - Online
09:00-17:00 (EST)
AT7780V250111
1,590 €
1,450 €
Early bird discount
January
2025
20
Mon
21
Tue
22
Wed
One to One - Online
09:00-17:00 (EST)
AT7780V250201
1,590 €
1,450 €
Early bird discount

Who Should Attend

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

Course Content

  • 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

Frequently Asked Questions

"Implementing a SQL Data Warehouse - Course 20767-C Course" trainings are given in ("Group - One to one") two different  ways.
The one-to-one tuition fee is 1,450 €.

"Implementing a SQL Data Warehouse - Course 20767-C Course" trainings are given in two different ways.

The tuition fee as a group is 1,670 €. To create a group, you must be at least  3 people.
The one-to-one tuition fee is 1,450 €.

Our "Implementing a SQL Data Warehouse - Course 20767-C Course" trainings are one-to-one 5 days,

Our "Implementing a SQL Data Warehouse - Course 20767-C Course" trainings are group 3 days,
 

 

Exam & Certification

Participation Certificate

All trainees who participate in training will have an AcademyTech participation certificate.

Exam & Certification

Reviews

Recommendations by our happy graduates.

Popular locations for Implementing a SQL Data Warehouse - Course 20767-C Course in Portugal

Request more information for
"Implementing a SQL Data Warehouse - Course 20767-C Course"

Prefered Mode of Contact