SQL Server 2016 Integration Services - Data Warehouse

Denna SQL Server 2016- och Azure SQL Database-utbildning behandlar en av grundstenarna inom Business Intelligence-stöd, SQL Server Integrating Services (SSIS) och implementation av ETL och datalager, Data Warehouse.

Målgrupp

Kursen riktar sig till databas-proffs som skall utveckla stöd för Business Intelligence-lösningar med Data Warehouse baserat på Microsoft SQL Server eller Azure SQL Database. Under kursen används SQL Server 2016, men det mesta du lär dig kan också tillämpas på äldre versioner.

Förkunskaper

Du behöver grundläggande kunskaper i SQL Server eller Azure SQL Database, samt grundläggande kunskaper i Transact-SQL. Till detta rekommenderar vi vår kurs SQL Server 2016 - Querying Data with Transact-SQL 

Ämnesområden

Introduction to Data Warehousing

Describe data warehouse concepts and architecture considerations.

  • Overview of Data Warehousing
  • Considerations for a Data Warehouse Solution

Planning Data Warehouse Infrastructure

This module describes the main hardware considerations for building a data warehouse.

  • Considerations for Building a Data Warehouse
  • Data Warehouse Reference Architectures and Appliances

Designing and Implementing a Data Warehouse

This module describes how you go about designing and implementing a schema for a data warehouse.

  • Logical Design for a Data Warehouse
  • Physical Design for a Data Warehouse

Columnstore Indexes

This module introduces Columnstore Indexes.

  • Introduction to Columnstore Indexes
  • Creating Columnstore Indexes
  • Working with Columnstore Indexes

Implementing an Azure SQL Data Warehouse

This module describes Azure SQL Data Warehouses and how to implement them.

  • 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

At the end of this module you will be able to implement data flow in a SSIS package.

  • Introduction to ETL with SSIS
  • Exploring Source Data
  • Implementing Data Flow

Implementing Control Flow in an SSIS Package

This module describes implementing control flow in an SSIS package.

  • Introduction to Control Flow
  • Creating Dynamic Packages
  • Using Containers

Debugging and Troubleshooting SSIS Packages

This module describes how to debug and troubleshoot SSIS packages.

  • Debugging an SSIS Package
  • Logging SSIS Package Events
  • Handling Errors in an SSIS Package

Implementing an Incremental ETL Process

This module describes how to implement an SSIS solution that supports incremental DW loads and changing data.Lessons

  • Introduction to Incremental ETL
  • Extracting Modified Data
  • Temporal Tables

Enforcing Data Quality

This module describes how to implement data cleansing by using Microsoft Data Quality services.

  • Introduction to Data Quality
  • Using Data Quality Services to Cleanse Data
  • Using Data Quality Services to Match Data

Using Master Data Services

This module describes how to implement master data services to enforce data integrity at source.

  • Master Data Services Concepts
  • Implementing a Master Data Services Model
  • Managing Master Data
  • Creating a Master Data Hub

Extending SQL Server Integration Services (SSIS)

This module describes how to extend SSIS with custom scripts and components.

  • Using Custom Components in SSIS
  • Using Scripting in SSIS

Deploying and Configuring SSIS Packages

This module describes how to deploy and configure SSIS packages.

  • Overview of SSIS Deployment
  • Deploying SSIS Projects
  • Planning SSIS Package Execution

Consuming Data in a Data Warehouse

This module describes how to debug and troubleshoot SSIS packages.

  • Introduction to Business Intelligence
  • Introduction to Reporting
  • An Introduction to Data Analysis
  • Analyzing Data with Azure SQL Data Warehouse

 

Boka kursen

Boka din plats redan idag.

Om kursen

Pris: 31 450,00 kr

exklusive moms

Längd 5 dagar
Kurskod M20767

Software AssuranceSA-voucher gäller på denna kurs
KompetenskortKompetenskort gäller på denna kurs 

Boka kursen

Välj ort och kursstart

sg Startgaranti innebär att kursen startar oavsett antal deltagare

lc LiveClass innebär att kursen hålls som en lärarledd interaktiv onlineutbildning.

10 oktober

31 oktober

14 november

12 december

13 februari

27 februari

Visa fler kursdatum

Kunduppgifter

Kursanmälan är bindande. För mer information och avbokningsregler se våra allmänna villkor.