X
ODT

Introduction to SSIS
On-Demand Training

Starting At: $495.00
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
$495
Per User Per Year
Business Intelligence Pack
$995
Per User Per Year
Unlimited Elite Pack
$1295
Per User Per Year
Free Trial
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

Devin Knight

Director of Training

Devin Knight is our Training Lead, overseeing our workshops, boot camps, virtual training, webinars and corporate training programs. Devin is a Microsoft Most Valued Professional (MVP) and has authored numerous technical publications, including the books "Knight’s 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services", "Knight’s Microsoft Business Intelligence 24-Hour Trainer" and "SharePoint 2010 Business Intelligence 24-Hour Trainer". He has been selected as a speaker for conferences like PASS, SQLSaturdays and Code Camps for many years, and is the President of the SQL Server user group in Jacksonville, Florida (JSSUG).



Related Courses

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

Share this course with your friends