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 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 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.
This course includes:
- 5+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
System Requirements
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