Home   Schulung > EDV > Backoffice > SQL Server

The course is devoted to creating data warehousing solutions in SQL Server 2008/R2 using the Integration Services ÔÇô the SQL Server service for the extraction, transformation and data transfer ÔÇô the basic processes used in implementing data warehouses and data marts. Numerous illustrated examples demonstrate how easy it can be to create data pumps, as well as integration and cleansing of data from heterogeneous sources, without the programming knowledge. It also covers the subsequent integration with OLAP and reporting. Upon successful completion of this course, students will be able to: - Describe the usage of data warehouses and ETL processes - Create SSIS packages - Control package execution with control flows - Design data transformations using data flows - Transfer and transform data into data warehouses rapidly - Handle errors and create reliable SSIS packages - Configure and deploy SSIS packages into production environment - Secure the packages properly - Integrate with other SQL Server tools and services

Microsoft Data Warehousing with SQL Server 2008/R2 Integration Services

Ziel
The course is devoted to creating data warehousing solutions in SQL Server 2008/R2 using the Integration Services ÔÇô the SQL Server service for the extraction, transformation and data transfer ÔÇô the basic processes used in implementing data warehouses and data marts. Numerous illustrated examples demonstrate how easy it can be to create data pumps, as well as integration and cleansing of data from heterogeneous sources, without the programming knowledge. It also covers the subsequent integration with OLAP and reporting. Upon successful completion of this course, students will be able to:- Describe the usage of data warehouses and ETL processes- Create SSIS packages- Control package execution with control flows- Design data transformations using data flows- Transfer and transform data into data warehouses rapidly- Handle errors and create reliable SSIS packages- Configure and deploy SSIS packages into production environment- Secure the packages properly- Integrate with other SQL Server tools and services
Schulungsinhalte


· Introduction to Data Warehousing
Data warehouses and data marts . The usage of data warehousing in practice . Commonly solved problems in data warehouses . Introduction to the ETL processes (extraction, transformation, load)

· Introduction to SQL Server 2008 Integration Services (SSIS)
Architecture and overview of Integration Services. Integration Services tools

· Creating an Integration Services Project
Creating a new SSIS package . Compiling and running the package

· Working with Control Flows
Control Flow operations . Determining the sequence of operations, restrictive conditions . Containers for operations . Using variables . Integration with external systems . Parallelization of operations

· Working with Data Flows
Sources and destinations of data flows .Basic data transformations . Advanced data transformations . Definition of the sequence of transformations, restrictive conditions . Conditional control of data flows . Debugging data flows . Integration with .NET and other technologies . Using Change Data Tracking (CDC) for a rapid transfer of changes into DWH . Using Staging Area for busy systems

· Logging and Error Handling
Logging at all levels of Integration Services . Debugging SSIS packages . Error Handling

· Creating Reliable SSIS Packages
The usage of checkpoints ÔÇô recovery points . Using SSIS transactions

· Configuration and Deployment of SSIS Packages
Configuration options for SSIS packages . Preparing for deployment of packages, deployment options . Automating the execution of SSIS packages . Troubleshooting SSIS packages, 32bit vs. 64bit

· Managing and Securing Packages
Managing SSIS packages . Options for securing and protecting SSIS packages

· Integration with other SQL Server 2008/R2 Services
Data warehousing as a basis for OLAP cubes . Data warehouses and data marts for reporting .
Zielgruppe
Developers and data warehouse designers who consider implementing their data warehousing solution using Integration Services.
Voraussetzungen
Basic overview of relational databases. Knowing the fundamentals of data warehousing is of advantage.
Ausschlie├člich als Inhouse-Schulung
Dieses Seminar bieten wir ausschlie├člich als Inhouse-Seminar in Ihren R├Ąumlichkeiten oder bei uns in M├╝nster an.
Seminardaten
Schulung-Nrdwwarew
Dauer2 Tage
Inhouse-Schulung
Dieses Seminar bieten wir Ihnen als Inhouse-Seminar oder -coaching vor Ort in Ihren R├Ąumlichkeiten an.

Rufen Sie uns bitte an:

+4925198 110 99 0
QRCode zu dieser Schulung

Aktuelle Termine
Mo, 04.07.2016 - Fr, 08.07.2016, M├╝nster
Webentwicklung mit HTML, CSS, JavaScript, jQuery und PHP
Di, 05.07.2016 - Mi, 06.07.2016, M├╝nster
Social Media - Grundlagen und Strategien
Mo, 11.07.2016 - Mi, 13.07.2016, M├╝nster
Programmieren lernen f├╝r Nicht-ProgrammiererInnen
Mo, 11.07.2016 - Mi, 13.07.2016, M├╝nster
PHP5 - Dynamische Webseiten mit PHP
Mo, 11.07.2016 - Mi, 13.07.2016, M├╝nster
PHP 5.4 - Grundlagen zur Erstellung dynamischer Webseiten
Garantierte Durchf├╝hrung Garantierte Durchf├╝hrung!