Implementing a SQL Data Warehouse

Product information

IT

Reviews

4 out of 5 stars

(no reviews)

Level: Certificate

Inquire Now

Entry Requirement

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

Course Content

  • Introduction to Data Warehousing
  • Planning Data Warehouse Infrastructure
  • Designing and Implementing a Data Warehouse
  • Columnstore Indexes
  • Implementing an Azure SQL Data Warehouse
  • Creating an ETL Solution
  • Implementing Control Flow in an SSIS Package
  • Debugging and Troubleshooting SSIS Packages
  • Implementing a Data Extraction Solution
  • Enforcing Data Quality
  • Using Master Data Services
  • Extending SQL Server Integration Services (SSIS)
  • Deploying and Configuring SSIS Packages
  • Consuming Data in a Data Warehouse

Inquire Now