X
ODT

Introduction to SSIS
On-Demand Training

Starting At: $395
On-Demand Training
Call Us At: (904) 413-1911

Pragmatic Works On-Demand Training gives you the ability to learn from industry experts at your own pace. Our courses cover a variety of topics including Business Intelligence, Business Analytics, Big Data, SQL Server Optimization and more.

Introduction To SSIS
$395
Per User Per Year
Unlimited Elite Pack
$895

$995

Per User Per Year
Free Trial

Unlimited Elite Pack $100 off through March 31th.

3:13
3:13
2:00

Thanks for reporting a problem. We'll attach technical data about this session to help us figure out the issue. Which of these best describes the problem?

Any other details or context?

Cancel
message

Course Details

This course is designed to help you understand all aspects of SQL Server Integration Services (SSIS), the ETL tool of choice for SQL Server users. We will use a variety of lab exercises and small projects to ensure you gain familiarity with how the design and execution of environments work, and prepare you to build your own real world applications using this SQL Server application. Students will learn real world uses for SSIS.

What Will You Learn?

  • How to create an SSIS package to load to a database
  • How to make dynamic packages that work and self-heal in the event of a failure
  • How to use SSIS in your environment

Prerequisites


This course assumes that you have no previous knowledge of SSIS. In some of the scripting chapters, it is useful (but not mandatory) that attendees have some Visual Basic experience. You will need to know how to run a query inside of SQL Server.

System Requirements


  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014
  • AdventureWorks2008R2 or AdventureWorks2012 databases installed on the instance

  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance

Curriculum For This Course

Image

Manuel Quintana

Training Content Manager

As a Training Content Manager with Pragmatic Works, Manuel uses his knowledge with the BI Stack (SSRS, SSIS, SSAS) to deliver exciting and engaging content. He also has experience with T-SQL, DAX and Power Pivot and is always looking to expand his knowledge. A native of Puerto Rico, Manuel graduated from the University of Central Florida and loves being involved in the world of Business Intelligence.



Related Courses

Course Info
12 Comprehensive Modules
19 Effective Quizzes
Access on Mobile and TV
Certificate of Completion
Duration:
7h 8m
Download Syllabus
Enrollment Price:
$395/Year

Share this course with your friends