Community Course

Quick Microsoft SQL Server 2012-2014 Integration Services

55120AC (Class Pack)
Based on student feedback via 'Metrics that Matter'
Quick Microsoft SQL Server 2012-2014 Integration Services
This two-day instructor-led course is intended for those that are new to SQL Server Integration Services or are interested in learning the features available. This course uses an instructor-led topic explanation, instructor performing detailed demonstrations, then the student performing exercises to duplicate what the instructor demonstrated. This style of training is a combination of traditional classroom training and mentored learning. Additionally, videos of the demonstrations performed by the course author are included with the course as a take-away. The course completes with additional scenario-based labs to reinforce the course content.
Please contact your Learning Partner in order to take this course
Author: BlueBuffaloPress

Course Duration: 2 Days

SATV: Yes

About This Course

This two-day instructor-led course is intended for those that are new to SQL Server Integration Services or are interested in learning the features available. This course uses an instructor-led topic explanation, instructor performing detailed demonstrations, then the student performing exercises to duplicate what the instructor demonstrated. This style of training is a combination of traditional classroom training and mentored learning. Additionally, videos of the demonstrations performed by the course author are included with the course as a take-away. The course completes with additional scenario-based labs to reinforce the course content.

Audience Profile

This course is intended for IT Professionals.

At Course Completion

  • Understand packages.
  • Manage with Control Flow.
  • Move data with Data Flow.
  • Understand variables.
  • Understand parameters.
  • Utilize the Import/Export Wizard.
  • Work in the Explore window.
  • Create SQL Server Integration Services packages.
  • Utilize Connection Managers.
  • 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.
  • Optimize sources for extraction.
  • Use Destinations and understand choices.
  • Examine the Transformation and other Tasks (about 25 of them).
  • Create dynamic packages.
  • Utilize SQL Server Integration Services data typing.
  • Define and use variables and parameters.
  • Use expressions in packages.
  • Utilize sequences in a container.
  • Utilize container loops.
  • Perform joins with the Lookup Transformation.
  • Perform joins with the Merge Transformation.
  • Examine the SSIS engine.
  • Use the best practices.
  • Design to troubleshoot: using Precedence Constraints.
  • Work with advanced logging and reporting.
  • Handle errors.
  • Understand how to choose the Script Task or Script Component.
  • Work with XML.
  • Use package hierarchies: Parent Child.
  • Understand deployment strategies.
  • Understand how to use what they’ve learned in real-world scenarios.