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ö:
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
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
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
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