MS55321 SQL Server Integration Services (55321) E-Learning (English)

Volg de MS55321 SQL Server Integration Services Training bij Master IT en leer SSIS te gebruiken. Deze training is bedoeld voor IT-professionals die willen leren hoe ze SSIS kunnen gebruiken om Integration Services-projecten en -pakketten te bouwen, implementeren, onderhouden en beveiligen

Deze training vervangt de MS20767 Implementing a SQL Data Warehouse training.

Na afronding van deze training kun je onder andere:

• Geavanceerde SSIS-pakketten voor het extraheren, transformeren en laden van gegevens maken
• Containers gebruiken om repetitieve taken en transacties efficiënt te beheren
• De SSIS-catalogus maken, beheren en beveiligen

This five-day instructor-led course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server.This course is similar to the retired Course MS20767-C: Implementing a SQL Data Warehouse but focuses more on building packages, rather than the entire data warehouse design and implementation. At Course Completion

• Create sophisticated SSIS packages for extracting, transforming, and loading data
• Use containers to efficiently control repetitive tasks and transactions
• Configure packages to dynamically adapt to environment changes
• Use Data Quality Services to cleanse data
• Successfully troubleshoot packages
• Create and Manage the SSIS Catalog
• Deploy, configure, and schedule packages
• Secure the SSIS Catalog

Lesmethode

Ben je op zoek naar volledige zelfstudie? Wij bieden je de mogelijkheid om deze training volledig in jouw eigen tijd te volgen. Uiteraard met het officiële Engelstalige lesmateriaal waarmee je de juiste kennis opdoet.

Doelgroep

The primary audience for this course is database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.The primary audience for this course is database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.

Voorkennis

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Working knowledge of relational databases.
• Some experience with database design.

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Working knowledge of relational databases.
• Some experience with database design.

Onderdelen

Module 1: SSIS OverviewThis module explains the purpose of SSIS and teaches how to use the Import/Export Wizard to exchange data between data structures.Lessons

• Import/Export Wizard
• Exporting Data with the Wizard
• Common Import Concerns
• Quality Checking Imported/Exported Data

Lab: Use the Import/Export Wizard from SSMSModule 2: Working with Solutions and ProjectsLessons

• Working with SQL Server Data Tools
• Understanding Solutions and Projects
• Working with the Visual Studio Interface

Lab:

• Import and run a package in SSDT-BI

Module 3: Basic Control FlowLessons

• Working with Tasks
• Understanding Precedence Constraints
• Annotating Packages
• Grouping Tasks
• Package and Task Properties
• Connection Managers
• Favorite Tasks

Lab:

• Precedence Constraints and Execute SQL Task

Module 4: Common TasksLessons

• Analysis Services Processing
• Data Profiling Task
• Execute Package Task
• Execute Process Task
• Expression Task
• File System Task
• FTP Task
• Hadoop Task
• Script Task Introduction
• Send Mail Task
• Web Service Task
• XML Task

Labs:

• Create a package to copy a file and send an email message on completion
• Create a package to perform data profiling and then review the results
• Create a master package and test the execution flow of the child packages

Module 5: Data Flow Sources and DestinationsLessons

• The Data Flow Task
• The Data Flow SSIS Toolbox
• Working with Data Sources
• SSIS Data Sources
• Working with Data Destinations
• SSIS Data Destinations

Lab: Working with Data Sources and DestinationsModule 6: Data Flow TransformationsLessons

• Transformations
• Configuring Transformations

Lab:

• Working with Derived Column Transformations
• Working with Lookup Transformations
• Module 7: Making Packages Dynamic

After completing this module, students will be able to:

• Working with Derived Column Transformations
• Working with Lookup Transformations

Module 7: Making Packages DynamicLessons

• Features for Making Packages Dynamic
• Package Parameters
• Project Parameters
• Variables
• SQL Parameters
• Expressions in Tasks
• Expressions in Connection Managers
• After Deployment
• How It All Fits Together

Lab: Making a Package DynamicModule 8: ContainersLessons

• Sequence Containers
• For Loop Containers
• Foreach Loop Containers

Lab: Use a Foreach Loop container to send a custom email to the names found in a database viewModule 9: Troubleshooting and Package ReliabilityLessons

• Understanding MaximumErrorCount
• Breakpoints
• Redirecting Error Rows
• Logging
• Event Handlers
• Using Checkpoints
• Transactions

Labs:

• Creating a Script Task to Merge Error Messages
• Configure a package to use transactions

Module 10: Deploying to the SSIS CatalogLessons

• The SSIS Catalog
• Deploying Projects
• Working with Environments
• Executing Packages in SSMS
• Executing Packages from the Command Line
• Deployment Model Differences

Labs:

• Deploying a Project to the SSIS Catalog
• Manually executing a Package

Module 11: Installing and Administering SSISLessons

• Installing SSIS
• Upgrading SSIS
• Managing the SSIS Catalog
• Viewing Built-in SSIS Reports
• Managing SSIS Logging and Operation Histories
• Automating Package Execution

Lab: Automating Package ExecutionModule 12: Installing, Upgrading, and Migrating to Windows 7Lessons

• Principals
• Securables
• Grantable Permissions
• Granting Permissions
• Configuring Proxy Accounts

Lab: Securing the SSIS CatalogModule 1: SSIS OverviewThis module explains the purpose of SSIS and teaches how to use the Import/Export Wizard to exchange data between data structures.Lessons

• Import/Export Wizard
• Exporting Data with the Wizard
• Common Import Concerns
• Quality Checking Imported/Exported Data

Lab: Use the Import/Export Wizard from SSMSModule 2: Working with Solutions and ProjectsLessons

• Working with SQL Server Data Tools
• Understanding Solutions and Projects
• Working with the Visual Studio Interface

Lab:

• Import and run a package in SSDT-BI

Module 3: Basic Control FlowLessons

• Working with Tasks
• Understanding Precedence Constraints
• Annotating Packages
• Grouping Tasks
• Package and Task Properties
• Connection Managers
• Favorite Tasks

Lab:

• Precedence Constraints and Execute SQL Task

Module 4: Common TasksLessons

• Analysis Services Processing
• Data Profiling Task
• Execute Package Task
• Execute Process Task
• Expression Task
• File System Task
• FTP Task
• Hadoop Task
• Script Task Introduction
• Send Mail Task
• Web Service Task
• XML Task

Labs:

• Create a package to copy a file and send an email message on completion
• Create a package to perform data profiling and then review the results
• Create a master package and test the execution flow of the child packages

Module 5: Data Flow Sources and DestinationsLessons

• The Data Flow Task
• The Data Flow SSIS Toolbox
• Working with Data Sources
• SSIS Data Sources
• Working with Data Destinations
• SSIS Data Destinations

Lab: Working with Data Sources and DestinationsModule 6: Data Flow TransformationsLessons

• Transformations
• Configuring Transformations

Lab:

• Working with Derived Column Transformations
• Working with Lookup Transformations
• Module 7: Making Packages Dynamic

After completing this module, students will be able to:

• Working with Derived Column Transformations
• Working with Lookup Transformations

Module 7: Making Packages DynamicLessons

• Features for Making Packages Dynamic
• Package Parameters
• Project Parameters
• Variables
• SQL Parameters
• Expressions in Tasks
• Expressions in Connection Managers
• After Deployment
• How It All Fits Together

Lab: Making a Package DynamicModule 8: ContainersLessons

• Sequence Containers
• For Loop Containers
• Foreach Loop Containers

Lab: Use a Foreach Loop container to send a custom email to the names found in a database viewModule 9: Troubleshooting and Package ReliabilityLessons

• Understanding MaximumErrorCount
• Breakpoints
• Redirecting Error Rows
• Logging
• Event Handlers
• Using Checkpoints
• Transactions

Labs:

• Creating a Script Task to Merge Error Messages
• Configure a package to use transactions

Module 10: Deploying to the SSIS CatalogLessons

• The SSIS Catalog
• Deploying Projects
• Working with Environments
• Executing Packages in SSMS
• Executing Packages from the Command Line
• Deployment Model Differences

Labs:

• Deploying a Project to the SSIS Catalog
• Manually executing a Package

Module 11: Installing and Administering SSISLessons

• Installing SSIS
• Upgrading SSIS
• Managing the SSIS Catalog
• Viewing Built-in SSIS Reports
• Managing SSIS Logging and Operation Histories
• Automating Package Execution

Lab: Automating Package ExecutionModule 12: Installing, Upgrading, and Migrating to Windows 7Lessons

• Principals
• Securables
• Grantable Permissions
• Granting Permissions
• Configuring Proxy Accounts

Lab: Securing the SSIS Catalog