fbpx

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

SSIS in the Cloud

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • Create SSIS packages that interact with various Azure Storage options
  • Introduction to Azure Data Factory
  • Deploy packages to an Azure SQL Database
This course includes:

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.

Outline

 

Module 00 | Class Introduction
06m 33s total

 

Module 00A | Class Introduction
06m 33s

 

Module 01 | Getting Started with Azure
51m 81s total

 

Module 01A | Navigating the Azure Portal
13m 57s

 

Module 01B | Resource Groups
13m 17s

 

Module 01C | Azure SQL DB & Azure Storage
25m 07s

 

Module 02 | SSIS Hosted On-Prem
163m 11s total

 

Module 02A | Azure Feature Pack
12m 02s

 

Module 02B | Azure Blob Upload Task
25m 04s

 

Module 02C | Azure Blob Download Task
32m 05s

 

Module 02D | Azure Blob Source to Azure SQL DB
30m 52s

 

Module 02E | Flat File Source
12m 59s

 

Module 02F | Azure SQL DB to Azure SQL DB
18m 24s

 

Module 02G | SSIS Deployment
15m 45s

 

Module 02H | SSIS Package Execution
17m 20s

 

Module 03 | Working with Azure Data Factory
10m 51s total

 

Module 03A | Provisioning Azure Data Factory
10m 51s

 

Module 04 | Azure Lift and Shift
58m 43s total

 

Module 04A | Provisioning Azure SSIS Integration Runtime
17m 19s

 

Module 04B | Visual Studio Deployment
10m 53s

 

Module 04C | Management Studio Deployment
06m 19s

 

Module 04D | Execute SSIS Packages from Azure
11m 25s

 

Module 04E | Execute SSIS Packages from SSMS
13m 27s

 

Module 05 | Scheduling a Pipeline
13m 31s total

 

Module 05A | Schedule Triggers
13m 31s

 

Module 06 | Monitoring
07m 34s total

 

Module 06A | Azure Data Factory
07m 34s

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 (Many features discussed are Enterprise/Developer edition only)
    • SQL Server Database Engine
    • SQL Server Integration Services
    • SQL Server Analysis Services (Optional)
    • SQL Server Data Tools (SQL 2012/2014) or Business Intelligence Development Studio (SQL 2008/2008R2)
    • SQL Server Management Studio
    • Data Quality Services (SQL 2012/2014 only)
    • Data Quality Client (SQL 2012/2014 only)
    • Follow this installation guide: (https://file.ac/CtasreVWQEA/Pragmatic%20SSIS%20Master%20Installation%20Guide.docx)

What to Know Before Class

We recommend first taking our Introduction to SSIS course prior to taking this one.

REVIEWS
Great instructor.

Anonymous

Very helpful, thank you!

Anonymous

Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.

 

Bonus:

• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!