NEED HELP? TALK TO AN EXPERT (904) 638-5743

Introduction to SSIS

Part Of The On-Demand Courses

WHAT YOU'LL 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
This course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

Course Description

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.

 

Click here for a downloadable PDF

Outline

 

Module 00 | Getting Started
06m 53s total

 

Module 00A | Getting Started
06m 53s

 

Module 01 | SSIS Overview
15m 37s total

 

Module 01A | SSIS Overview
15m 37s

 

Module 02 | Introduction to the Development Environment
72m 97s total

 

Module 02A | Introduction to SQL Server Data Tools
25m 31s

 

Module 02B | Connection Managers
16m 54s

 

Module 02C | Precedence Constraints and Control Flow Tasks
31m 12s

 

Module 03 | Loading Data with the Data Flow
96m 82s total

 

Module 03A | Common Sources
24m 54s

 

Module 03B | Common Transforms
41m 07s

 

Module 03C | Common Destinations
31m 21s

 

Module 04 | Using Variables, Parameters and Expressions
36m 76s total

 

Module 04A | Using Variable and Parameters
15m 41s

 

Module 04B | SSIS Expression Language and Parameterized Objects
21m 35s

 

Module 05 | Using Containers
42m 53s total

 

Module 05A | Grouping, Sequence and For Loop Container
18m 20s

 

Module 05B | For Each Loop Container
24m 33s

 

Module 06 | Troubleshooting SSIS
15m 54s total

 

Module 06A | Troubleshooting SSIS
15m 54s

 

Module 07 | Loading a Dimension
64m 44s total

 

Module 07A | Designing a Data Warehouse
36m 31s

 

Module 07B | Loading Dimension Tables
28m 13s

 

Module 08 | Loading a Fact Table
26m 38s total

 

Module 08A | Loading a Fact Table
26m 38s

 

Module 09 | Deploying SSIS Packages
20m 27s total

 

Module 09A | Deploying SSIS Packages
20m 27s

 

Module 10 | Configuring SSIS Packages for Portability
21m 51s total

 

Module 10A | Configuring SSIS Packages for Portability
21m 51s

 

Module 11 | SSIS Server Executions
24m 35s total

 

Module 11A | SSIS Server Executions
24m 35s

 

Module 12 | Setting Up Auditing and Notification
15m 15s total

 

Module 12A | Setting Up Auditing and Notification
15m 15s

Instructor

MANUEL QUINTANA

Training Content Manager

As a Training Content Manager, Consultant and Trainer with Pragmatic Works, Manuel uses his extensive knowledge of the BI Stack (SSRS, SSIS, SSAS etc.) to deliver exciting and engaging content. He also has experience with T-SQL, DAX, Power Platform and Azure Data Services. Manuel, however, is known for his impressive knowledge of the Microsoft Power BI tool. A native of Puerto Rico, He graduated from the University of Central Florida and loves being involved in the world of business intelligence. Manuel is a thought leader in the BI community.

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

What to Know Before Class

This course assumes that you have no previous knowledge of SSIS. In some of the scripting modules, 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.

REVIEWS

Excellent course, steady pace and the audience level is perfect for people who need the ground knowledge.

Imtiaz H.

I was very impressed with Manuel Quintana's public speaking skill. It had a friendly tone, helpful side comments and was captivating to listen. He came across as humble and confident helping listeners find their self-confidence with the respective technology.

Anonymous

I really enjoyed this class and found it very informative. I've been writing SSIS packages for a long time but have never taken a course. Many knowledge gaps were taken care of. Thanks!

Anonymous

Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required