Type to search LearningTree.com

Do you mean "{{response.correctedQuery}}" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.

 

Business Intelligence Training









Preferred method of contact?

SQL Server Integration Services for Business Intelligence

COURSE TYPE

Practitioner

Course Number

134

Duration

4 Days

Enroll

About This Course: In order to improve business intelligence capabilities, organizations must effectively and securely manage data migration across a myriad of platforms. In this course, you gain the skills to automate complex migration tasks and audit the success or failure of migration processes. In addition, this course helps you prepare for Microsoft professional certification exams.

You Will Learn How To

  • Solve data management problems by migrating and processing data
  • Perform nonstandard imports and exports using the Script component
  • Assemble tasks to perform complex data migrations
  • Enhance package functionality with scripting
  • Extract, Transform and Load (ETL) data
  • Deploy packages to an SSIS server

Important Course Information

Recommended Experience:

  • Familiarity with relational database management systems, programming concepts, and SQL language

Software:

  • This course uses Microsoft SQL Server 2014, running on Windows Server 2013 R2
  • This course is applicable to those using earlier versions of SQL Server

Course Outline

  • Introduction to Integration Services
  • Defining SQL Server Integration Services (SSIS)
  • Exploring the need for migrating diverse data
  • The role of Business Intelligence (BI)
  • SSIS Architecture and Tools

Managing heterogeneous data

  • Leveraging the Extract, Transform and Load (ETL) capabilities of SSIS
  • Running wizards for basic migrations
  • Creating packages for complex tasks

Illustrating SSIS architecture

  • Distinguishing between data flow pipeline and package runtime
  • Executing packages on the client side or hosted in the SSIS service
  • Bulletproofing a package with package environment configurations

Simplifying deployments

  • Switching between project and package deployment modes
  • Deploying packages to the SSISDB
  • Running packages from SQL Server
  • Leveraging package parameters
  • Implementing Tasks and Containers

Utilizing basic SSIS objects

  • Configuring connection managers
  • Adding data flow tasks to packages
  • Reviewing progress with data viewers
  • Assembling tasks to perform complex data migrations
  • Migrating multiple files with FOREACH container

Operating system-level tasks

  • Copying, moving and deleting files
  • Transferring files with the FTP task
  • Communicating with external sources
  • Sending messages through mail

Processing XML

  • Iterating XML nodes
  • Writing XML files from databases
  • Extending Capabilities with Scripting

Writing expressions

  • Making properties dynamic with variables
  • Utilizing expressions in loop iterations

Script Task

  • Extending functionality with the Script Task
  • Debugging, breakpoints and watches
  • Transforming with the Data Flow Task

Performing transforms on columns

  • Converting and calculating columns
  • Transforming with Character Map

Profiling, combining and splitting data

  • Merge, Union and Conditional Split
  • Multicasting and converting data

Manipulating row sets and BLOB data

  • Aggregate, sort, audit and look up data
  • Importing and exporting BLOB data
  • Redirecting error rows

Performing database operations

  • Executing a SQL task
  • Bulk inserting data from text files
  • Error Handling, Logging and Transactions

Organizing package workflow

  • Defining success, failure, completion and expression precedence constraints
  • Handling events and event bubbling

Designing robust packages

  • Choosing log providers
  • Adapting solutions with package configurations
  • Auditing package execution results
  • Accessing package data with ADO.NET
Show complete outline
Show Less

Course Schedule

Attend this live, instructor-led course In-Class or Online via AnyWare.

Hassle-Free Enrollment: No advance payment required.
Tuition due 30 days after your course.

Dec 19 - 22 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Jan 31 - Feb 3 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Feb 7 - 10 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Mar 7 - 10 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Mar 28 - 31 AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Apr 18 - 21 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

May 16 - 19 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

May 23 - 26 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Jun 13 - 16 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Jun 20 - 23 AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Aug 15 - 18 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Sep 5 - 8 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Sep 19 - 22 AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Sep 26 - 29 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Oct 3 - 6 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Dec 5 - 8 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Guaranteed to Run

Show all dates
Show fewer dates

Bring this Course to Your Organization and Train Your Entire Team
For more information, call 1-888-843-8733 or click here

Tuition

Standard

$2990

Government

$2659

Course Tuition Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

After-Course Computing Sandbox
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.

Free Course Exam
You can take your course exam on the last day of your course and receive a Certificate of Achievement with the designation "Awarded with Distinction."

Prev
Next

Questions

Call 1-888-843-8733 or click here »

An experienced training advisor will happily answer any questions you may have and alert you to any tuition savings to
which you or your organization may be entitled.

Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm


FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:

  • Have a record of your growth and learning results.
  • Bring proof of your progress back to your organization
  • Earn credits toward industry certifications (if applicable)
  • Make progress toward one or more Learning Tree Specialist & Expert Certifications (if applicable)

Enhance Your Credentials with Professional Certification

Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.

Earn 23 Credits from NASBA

This course qualifies for 23 CPE credits from the National Association of State Boards of Accountancy CPE program. Read more ...

“This is the fifth course I’ve taken via AnyWare, and I love it! Within a week back at work, I was given the complicated task of combining 35 files into one. Because of what I learned in the SSIS course, I had the know-how to successfully complete the task.”

- J. Romero, Applications Systems Analyst
AtlantiCare

Prev
Next
s