Implementing a SQL Data Warehouse
Under den här utbildningen lär du dig att skapa ett Data Warehouse med SQL Server 2017. Du lär dig hur du implementerar ETL med SQL Server Integrating Services (SSIS) och utnyttjar Data Quality Services och Master Data Services.
Många kurser kan även betalas med vårt kompetenskort alternativt utbildningsvouchers eller motsvarande credits från någon av våra teknikpartners.
Boka utbildning
Under kursen används SQL Server 2017, men det mesta du lär dig kan också tillämpas på äldre versioner.
Målgrupp och förkunskaper
Kursen riktar sig till databas-proffs som ska utveckla stöd för Business Intelligence-lösningar med Data Warehouse baserat på Microsoft SQL Server.
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 Querying Data with Transact-SQL.
För att alltid hålla en hög kvalitet på våra teknikkurser använder vi både engelsk- och svensktalande experter som kursledare.
Detaljerad information
Kursmaterialet är på engelska, med detta innehåll:
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
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 introduces BI, describing the components of Microsoft® SQL Server® that you can use to create a BI solution, and the client tools with which users can create reports and analyze data.
- Introduction to Business Intelligence
- Introduction to Reporting
- An Introduction to Data Analysis
"Normalt tycker jag det är jobbigt att sitta så länge i utbildningssituation på distans men utbildaren gjorde ett bra jobb med bra engagemang."