Loading...

Terminy kursów:

23.01.2023 - 27.01.2023
13.02.2023 - 17.02.2023
06.03.2023 - 10.03.2023

Pozostałe szkolenia

MS-20463 Implementing a Data Warehouse with Microsoft SQL Server

Czas trwania kursu: 5 dni
Cena: 3399 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