MS-55120: Quick SQL Server Integration Services 2012
COURSE OUTLINE:
Learning Objectives
At Course Completion
- Introduction
- Course Materials
- Facilities
- Prerequisites
- What We'll Be Discussing
- None
- Successfully log into their virtual machine.
- Have a full understanding of what the course intends to cover.
- Version Changes of SSIS From 2008-2012
- The SQL Server Integration Service
- Understanding Packages
- Managing with Control Flow
- Moving Data with Data Flow
- Understanding Variables
- Understanding Parameters
- Managing with Control Flow
- Moving Data with Data Flow
- Understanding Variables
- Understanding Parameters
- Understand packages.
- Manage with Control Flow.
- Move data with Data Flow.
- Understand variables.
- Understand parameters.
- Utilizing the Import/Export Wizard
- Working in the Explore Window
- Creating SQL Server Integration Services Packages
- Utilizing Connection Managers
- Utilizing the Import/Export Wizard
- Working in the Explore Window
- Creating SQL Server Integration Services Packages
- Utilizing Connection Managers
- Utilize the Import/Export Wizard.
- Work in the Explore window.
- Create SQL Server Integration Services packages.
- Utilize Connection Managers.
- Coding the Script Task
- Looping and Sequence Tasks
- Utilizing Data Preparation Tasks
- Data Loading with the Analysis Services Tasks
- Using the Workflow Tasks
- Managing SQL with the SQL Tasks
- Administration of SQL Using the SQL Management Objects Tasks
- Coding the Script Task
- Utilizing Looping and Sequence Tasks
- Utilizing Data Preparation Tasks
- Data Loading with the Analysis Services Tasks
- Using the Workflow Tasks
- Managing SQL with the SQL Tasks
- Administration of SQL Using the SQL Management Objects Tasks
- Code the Script Task.
- Utilize Looping and Sequence Tasks.
- Utilize Data Preparation Tasks.
- Load data with the Analysis Services Tasks.
- Use the Workflow Tasks.
- Manage SQL with the SQL Tasks.
- Administration of SQL using the SQL Management Objects Tasks.
- Optimizing Sources for Extraction
- Using Destinations and Understanding choices
- Examining the Transformation and Other Tasks (about 25 of them)
- Optimizing Sources for Extraction
- Using Destinations and Understanding choices
- Examining the Transformation and Other Tasks (about 25 of them)
- Optimize sources for extraction.
- Use Destinations and understand choices.
- Examine the Transformation and other Tasks (about 25 of them).
- Creating Dynamic Packages
- Utilizing SQL Server Integration Services Data Typing
- Define and Use Variables and Parameters
- Using Expressions in Packages
- Creating Dynamic Packages
- Utilizing SQL Server Integration Services Data Typing
- Define and Use Variables and Parameters
- Using Expressions in Packages
- Create dynamic packages.
- Utilize SQL Server Integration Services data typing.
- Define and use variables and parameters.
- Use expressions in packages.
- Overview of Containers
- Utilizing Sequences in a Container
- Utilizing Container Loops
- Utilizing Sequences in a Container
- Utilizing Container Loops
- Utilize sequences in a container.
- Utilize container loops.
- Performing Joins with the Lookup Transformation
- Performing Joins with the Merge Transformation
- Utilizing Cache Modes in Joins
- Performing Joins with the Lookup Transformation
- Performing Joins with the Merge Transformation
- Perform joins with the Lookup Transformation.
- Perform joins with the Merge Transformation.
- Examining the SSIS Engine
- Using the Best Practices
- Examining the SSIS Engine
- Using the Best Practices
- Examine the SSIS engine.
- Use the best practices.
- Designing to Troubleshoot: Using Precedence Constraints
- Working with Advanced Logging and Reporting
- Handling Errors
- Designing to Troubleshoot: Using Precedence Constraints
- Working with Advanced Logging and Reporting
- Handling Errors
- Design to troubleshoot: using Precedence Constraints.
- Work with advanced logging and reporting.
- Handle errors.
- Choosing the Script Task or Script Component
- Working with XML
- Using Package Hierarchies: Parent Child
- Understanding Deployment Strategies
- Working with XML
- Using Package Hierarchies: Parent Child
- Understand how to choose the Script Task or Script Component.
- Work with XML.
- Use package hierarchies: Parent Child.
- Understand deployment strategies.
- Scenario 1
- Scenario 2
- Scenario 3
- Scenario 1 Solution
- Scenario 2 Solution
- Scenario 3 Solution
- Understand how to use what they’ve learned in real-world scenarios.