Introduction to SSIS

Gain expertise in design, execution, real-world application building in this SSIS class. Hands-on labs, SSIS package creation, ETL challenges. Excel in using SSIS for real-world scenarios.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

Gain expertise in design, execution, real-world application building in this SSIS class. Hands-on labs, SSIS package creation, ETL challenges. Excel in using SSIS for real-world scenarios.

This course includes:

7+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Description

This SSIS class 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 in how the design and execution environments work and be prepared to build your own real world applications using this SQL Server application. Students will learn how to use SSIS in the real-world. With the hands-on labs, you will learn how to create a SSIS package to load a database. You’ll also learn how to make the package dynamic to where it will work and self-heal in the event of a failure. This course gives detailed and extensive demos on how to use SSIS in your environment.

This course includes:

7+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Outline

SSIS - What you need to get started

This course includes:

7+ hours hours of training
Access on mobile and browser
Certificate of Completion

Instructor

Manuel Quintana

Data Engineer (Azure) Trainer

Manuel Quintana has been teaching and developing training content for Pragmatic Works for the past 6 years. The areas of knowledge he has worked with includes the Microsoft SQL BI Stack (T-SQL, SSIS, SSAS, and SSRS), the Power Platform (Power BI, Power Automate, and PowerApps), and other various Azure services. Manuel has also authored a couple of books around Power BI and the Power Platform and participates within the community by presenting topics at various SQL Server or Power BI User groups.

Learn More

This course includes:

7+ hours hours of training
Access on mobile and browser
Certificate of Completion

System Requirements

- Windows 7, Windows 8, or Windows 10 - 2 GHz or faster CPU - 2 GB of available RAM (recommended 4 GB) - 20 GB of free hard drive space - SQL Server Developer, Standard or Enterprise Edition 2012/2014/2016/2017/2019 - SQL Server Database Engine - SQL Server Integration Services - SQL Server Data Tools - SQL Server Management Studio - Follow this [installation guide](https://www.youtube.com/playlist?list=PLcwrIWK7WBcRXS59lktaU9SJwb3cGgvCw) to ensure all items are installed correctly - AdventureWorks2008R2 or AdventureWorks2012 databases installed on the instance. - AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance. - The Adventure Works databases can be found in the class files in the SSISClass\Databases folder

This course includes:

7+ hours hours of training
Access on mobile and browser
Certificate of Completion

What to know before class

This course includes:

7+ hours hours of training
Access on mobile and browser
Certificate of Completion