SSIS in the Cloud

Join our SSIS in the Cloud class. Learn to create SSIS packages with Azure Storage, Blob Storage, SQL DB. From creating, deploying, executing packages on-premises to leveraging Azure Data Factory's Lift and Shift, we cover it all.

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

What you'll learn

This course includes:

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

Course Description

This SSIS in the Cloud class will take users through the process of creating simple SSIS packages that interact with various Azure Storage options like Azure Blob Storage and Azure SQL DB. It will start with creating, deploying, and executing packages that move data in the Cloud via an on-premises solution. Then users will be introduced to Azure Data Factory and the feature known as Lift and Shift which will allow us to deploy our packages to an Azure SQL Database and execute them uses Cloud resources. Users should have a basic understanding of SSIS prior to watching this class.

This course includes:

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

Course Outline

SSIS in the Cloud - What you need to get started

Module 00 - Class Introduction 7 min.

Module 01A - Getting Started with Azure (Navigating the Azure Portal) 14 min.

Module 01B - Getting Started with Azure (Resource Groups) 13 min.

Module 01C – Getting Started with Azure (Azure SQL DB & Azure Storage) 25 min.

Module 02A - SSIS Hosted On-Prem (Azure Feature Pack) 12 min.

Module 02B - SSIS Hosted On-Prem (Azure Blob Upload Task) 25 min.

Module 02C - SSIS Hosted On-Prem (Azure Blob Download Task) 32 min.

Module 02D - SSIS Hosted On-Prem (Azure Blob Source to Azure SQL DB) 31 min.

Module 02E - SSIS Hosted On-Prem (Flat File Source) 13 min.

Module 02F - SSIS Hosted On-Prem (Azure SQL DB to Azure SQL DB) 18 min.

Module 02G - SSIS Hosted On-Prem (SSIS Deployment) 16 min.

Module 02H - SSIS Hosted On-Prem (SSIS Package Execution) 17 min.

Module 03 - Working with Azure Data Factory (Provisioning Azure Data Factory) 11 min.

Module 04A - Azure Lift and Shift (Provisioning Azure SSIS Integration Runtime) 21 min.

Module 04B – Azure Lift and Shift (Visual Studio Deployment) 11 min.

Module 04C - Azure Lift and Shift (Management Studio Deployment) 6 min.

Module 04D - Azure Lift and Shift (Execute SSIS Packages from Azure) 11 min.

Module 04E - Azure Lift and Shift (Execute SSIS Packages from SSMS) 13 min.

Module 05 - Scheduling a Pipeline (Schedule Triggers) 14 min.

Module 06 - Monitoring (Azure Data Factory) 8 min.

This course includes:

5+ 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:

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

System Requirements

**Download Details** Please download and unzip the following class files to you root directory C:\ [Click to Download](https://pragmaticworksonline.sharepoint.com/:u:/s/FileShare/EX_3DyJ-aq1NvT8CUcRPCpEBB_IhcaqMAlkUawrdR_hBig?e=pdcp1I&download=1) (Required) - Microsoft Azure Account (Paid or Trial) - SQL Server Management Studio 17.5+ - 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 or higher - SQL Server Database Engine - SQL Server Integration Services - SQL Server Data Tools - SQL Server Management Studio - Follow this [installation guide](https://pragmaticworksonline.sharepoint.com/:w:/s/FileShare/EYBWk22wup5Nty4rNzSfZfQByw4W1LG3n8j-IeWn1Ds3Uw?e=cqCFmq) to ensure all items are installed correctly Need additional help installing the SQL Server tools? Check out our video series on installing these requirements [here](https://www.youtube.com/playlist?list=PLcwrIWK7WBcS6yAJb-FjYMndzWPxmbQ0_).

This course includes:

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

What to know before class

This course includes:

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