Implementing a SQL Data Warehouse

Descrizione del corso

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.

Programma

1. Introduction to Data Warehousing
   • Overview of Data Warehousing
   • Considerations for a Data Warehouse Solution
2. Planning Data Warehouse Infrastructure
   • Considerations for Building a Data Warehouse
   • Data Warehouse Reference Architectures and Appliances
3. Module 3: Designing and Implementing a Data Warehouse
   • Logical Design for a Data Warehouse
   • Physical Design for a Data Warehouse
4. Columnstore Indexes
   • Introduction to Columnstore Indexes
   • Creating Columnstore Indexes
   • Working with Columnstore Indexes
5. Implementing an Azure SQL Data Warehouse
   • Advantages of Azure SQL Data Warehouse
   • Implementing an Azure SQL Data Warehouse
   • Developing an Azure SQL Data Warehouse
   • Migrating to an Azure SQ Data Warehouse
6. Creating an ETL Solution
   • Introduction to ETL with SSIS
   • Exploring Source Data
   • Implementing Data Flow
7. Implementing Control Flow in an SSIS Package
   • Introduction to Control Flow
   • Creating Dynamic Packages
   • Using Containers
8. Debugging and Troubleshooting SSIS Packages
   • Debugging an SSIS Package
   • Logging SSIS Package Events
   • Handling Errors in an SSIS Package
9. Implementing an Incremental ETL Process
   • Introduction to Incremental ETL
   • Extracting Modified Data
   • Temporal Tables
10. Enforcing Data Qualità
    • Introduction to Data Qualità
    • Using Data Qualità Services to Cleanse Data
    • Using Data Qualità Services to Match Data
11. Using Master Data Services
    • Master Data Services Concepts
    • Implementing a Master Data Services Model
    • Managing Master Data
    • Creating a Master Data Hub
12. Extending SQL Server Integration Services (SSIS)
    • Using Custom Components in SSIS
    • Using Scripting in SSIS
13. Deploying and Configuring SSIS Packages
    • Overview of SSIS Deployment
    • Deploying SSIS Projects
    • Planning SSIS Package Execution
14. Consuming Data in a Data Warehouse
    • Introduction to Business Intelligence
    • Introduction to Reporting
    • An Introduction to Data Analysis
    • Analyzing Data with Azure SQL Data Warehouse