2299zł
KLUCZOWE ZAGADNIENIA
- zrozumienie czym jest hurtownia danych
- tworzenie pakietów SSIS – Control Flow, Data Flow, kontenery
- logowanie i obsługa błędów pakietów
- wdrażanie gotowych projektów i uruchamianie pakietów
- DQS, czyli dbanie o jakość danych
- podstawy zarządzania danymi za pomocą MDS
Bartosz Ratajczyk, Microsoft Certified Trainer
CERTYFIKACJE ZAWODOWE
| Certyfikacja podstawowa |
CertyfIkacja specjalistyczna |
Certyfikacja ekspercka |
| FUNDAMENTALS |
ASSOCIATE |
EXPERT |
Tematyka szkolenia pokrywa zagadnienia wymagane na ścieżce MCSA: SQL Server 2012
Dowiedz się więcej o certyfikacjach Microsoft
POZIOM SZKOLENIA
| podstawowy |
średniozaawansowany |
zaawansowany |
ekspercki |
| 100 |
200 |
300 |
400 |
TEMATYKA ZAJĘĆ
- Module 1: Introduction to Data Warehousing
Overview of Data Warehousing
Considerations for a Data Warehouse Solution
Lab : Exploring a Data Warehousing Solution
- Module 2: Data Warehouse Hardware Considerations
Considerations for building a Data Warehouse
Data Warehouse Reference Architectures and Appliances
Lab : Planning Data Warehouse Infrastructure
- Module 3: Designing and Implementing a Data Warehouse
Logical Design for a Data Warehouse
Physical design for a data warehouse
Lab : Implementing a Data Warehouse Schema
- Module 4: Creating an ETL Solution with SSIS
Introduction to ETL with SSIS
Exploring Data Sources
Implementing Data Flow
Lab : Implementing Data Flow in an SSIS Package
- Module 5: Implementing Control Flow in an SSIS Package
Introduction to Control Flow
Creating Dynamic Packages
Using Containers
Managing Consistency
Lab : Implementing Control Flow in an SSIS Package
Lab : Using Transactions and Checkpoints
- Module 6: Debugging and Troubleshooting SSIS Packages
Debugging an SSIS Package
Logging SSIS Package Events
Handling Errors in an SSIS Package
Lab : Debugging and Troubleshooting an SSIS Package
- Module 7: Implementing an Incremental ETL Process
Introduction to Incremental ETL
Extracting Modified Data
Loading Modified data
Lab : Loading Incremental Changes
Lab : Extracting Modified Data
- Module 8: Enforcing Data Quality
Introduction to Data Quality
Using Data Quality Services to Cleanse Data
Using Data Quality Services to Match data
Lab : Cleansing Data
Lab : De-duplicating data
- Module 9: Using Master Data Services
Master Data Services Concepts
Implementing a Master Data Services Model
Managing Master Data
Creating a Master Data Hub
Lab : Implementing Master Data Services
- Module 10: Extending SQL Server Integration Services
Using Scripts in SSIS
Using Custom Components in SSIS
Lab : Using Custom Components and Scripts
- Module 11: Deploying and Configuring SSIS Packages
Overview of SSIS Deployment
Deploying SSIS Projects
Planning SSIS Package Execution
Lab : Deploying and Configuring SSIS Packages
- Module 12: Consuming Data in a Data Warehouse
Introduction to Business Intelligence
Introduction to Reporting
An Introduction to Data Analysis
Lab : Using Business Intelligence Tools