PDF Add to WishList
In this SQL integration training course, you gain the skills to improve business intelligence capabilities by automating complex migration tasks, auditing the success or failure of migration processes, transforming data among heterogeneous data sources — such as text files, Oracle, Access, XML, ODBC and OLE DB — and effectively and securely managing data migration across various platforms.
Managing heterogeneous data
Illustrating SSIS architecture
Utilizing basic SSIS objects
Operating system-level tasks
Performing transforms on columns
Profiling, combining and splitting data
Manipulating row sets and BLOB data
Performing database operations
Organizing package workflow
Designing robust packages
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 Learning Tree course exam on the last day of your course or online any time after class.
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
“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