MS-20463 Implementing a Data Warehouse with Microsoft SQL Server

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

Tematyka szkolenia pokrywa zagadnienia wymagane na ścieżce MCSA: SQL Server 2012
Dowiedz się więcej o certyfikacjach Microsoft

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