20767 Implementing a SQL Data Warehouse

Tietovaraston toteutusko vaikeaa?

SQL Server 2016-tietovaraston toteutustekniikat yhdessä paketissa: SQL Server DW, Azure SQL Data Warehouse, SSIS, DQS, MDS.

Kurssi on suunniteltu henkilöille, jotka toteuttavat tietovarastoratkaisuja SQL Serverillä. Kurssi soveltuu versioiden 2012 – 2016 käyttäjille.

Kouluttajana on kokenut, arvostettu ja tuhansia ammattilaisia kouluttanut senior-konsultti Pekka Korhonen. Pekka on itse suorittanut Master-tason sertifioinnin ja antaa arvokasta näkemystä niin käytännön elämään kuin testeihin valmistautumiseen.

Esitiedot: Kurssi edellyttää SQL Serverin käyttökokemusta.

Materiaali: MOC 20767

Koulutuksen tarkempi sisältö:

1. PÄIVÄ

Introduction to Data Warehousing

• Overview of Data Warehousing
• Considerations for a Data Warehouse Solution

Planning Data Warehouse Infrastructure

• Considerations for Data Warehouse Infrastructure
• Planning Data Warehouse Hardware

Implementing a Data Warehouse

• Logical Design for a Data Warehouse
• Physical Design for a Data Warehouse

Columnstore Indexes

• Introduction to Columnstore Indexes
• Creating Columnstore Indexes
• Working with Columnstore Indexes

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

2. PÄIVÄ

Creating an ETL Solution

• Introduction to ETL with SSIS
• Exploring Data Sources
• Implementing Data Flow

Implementing Control Flow in an SSIS Package

• Introduction to Control Flow
• Creating Dynamic Packages
• Using Containers
• Managing Consistency: Transactions, Checkpoints

Debugging and Troubleshooting SSIS Packages

• Debugging an SSIS Package
• Logging SSIS Package Events
• Handling Errors in an SSIS Package

Implementing an Incremental ETL Process

• Planning Data Extraction
• Extracting Modified Data
• Change Data Capture
• Change Traking

3. PÄIVÄ

Implementing an Incremental ETL Process (jatkuu)

• Planning Data Loads
• Using SSIS for Incremental Loads
• Using Temporal Tables

Enforcing Data Quality

• Introduction to Data Quality
• Using Data Quality Services to Cleanse Data
• Using Data Quality Services to Deduplicate Data

Master Data Services

• Introduction to Master Data Services
• Implementing a Master Data Services Model
• Managing Master Data
• Creating a Master Data Hub

4. PÄIVÄ

Extending SQL Server Integration Services

• Using Scripts in SSIS
• Using Custom Components in SSIS

Deploying and Configuring SSIS Packages

• Overview of SSIS Deployment
• SSIS catalog
• Deploying SSIS Projects
• Planning SSIS Package Execution
• Scheduling SSIS Packages with SQL Server Agent

Consuming Data in a Data Warehouse

• Introduction to Business Intelligence
• Enterprise Business Intelligence
• Self-Service BI and Big Data

Avainsanat: Azure SQL Data Warehouse, Data Quality Services, Data Warehouse, Integration Services, Master Data Services, SQL Server 2016