2299 zł netto
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 a Data Extraction Solution
Planning Data Extraction
Extracting Modified Data
Lab : Extracting Modified Data
- Module 8: Loading Data into a Data Warehouse
Planning Data Loads
Using SSIS for Incremental Loads
Using Transact-SQL Loading Techniques
Lab : Loading a Data Warehouse
- Module 9: 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 : Deduplicating Data
- Module 10: Master Data Services
Introduction to Master Data Services
Implementing a Master Data Services Model
Managing Master Data
Creating a Master Data Hub
Lab : Implementing Master Data Services
- Module 11: Extending SQL Server Integration Services
Using Scripts in SSIS
Using Custom Components in SSIS
Lab : Using Custom Scripts
- Module 12: Deploying and Configuring SSIS Packages
Overview of SSIS Deployment
Deploying SSIS Projects
Planning SSIS Package Execution
Lab : Deploying and Configuring SSIS Packages
- Module 13: Consuming Data in a Data Warehouse
Introduction to Business Intelligence
Enterprise Business Intelligence
Self-Service BI and Big Data
Lab : Using a Data Warehouse