The SQL Server Stored Procedures course is designed to teach students what stored procedures are and why the are necessary. This course demonstrates how to create stored procedures, add input and output parameters and how to modify stored procedures. The class also covers permissions necessary for working with stored procedures as well as error handling techniques with Try..Catch.
Overview
COURSE DIFFICULTY
COURSE DURATION
2h 23m
Skills Learned
After completing this online training course, students will be able to:
Design and build data pipelines in Azure Data Factory
Schedule and trigger pipeline executions
Monitor and troubleshoot pipeline runs
Build ETL packages using SQL Server Integration Services
Data Engineers
None
01. SSIS in the Cloud - What you need to get started
02. Class Introduction
03. Getting Started with Azure (Navigating the Azure Portal)
04. Getting Started with Azure (Resource Groups)
05. Getting Started with Azure (Azure SQL DB & Azure Storage)
06. SSIS Hosted On-Prem (Azure Feature Pack)
07. SSIS Hosted On-Prem (Azure Blob Upload Task)
08. SSIS Hosted On-Prem (Azure Blob Download Task)
09. SSIS Hosted On-Prem (Azure Blob Source to Azure SQL DB)
10. SSIS Hosted On-Prem (Flat File Source)
11. SSIS Hosted On-Prem (Azure SQL DB to Azure SQL DB)
12. SSIS Hosted On-Prem (SSIS Deployment)
13. SSIS Hosted On-Prem (SSIS Package Execution)
14. Working with Azure Data Factory (Provisioning Azure Data Factory)
15. Azure Lift and Shift (Provisioning Azure SSIS Integration Runtime)
16. Azure Lift and Shift (Visual Studio Deployment)
17. Azure Lift and Shift (Management Studio Deployment)
18. Azure Lift and Shift (Execute SSIS Packages from Azure)
19. Azure Lift and Shift (Execute SSIS Packages from SSMS)
20. Scheduling a Pipeline (Schedule Triggers)
21. Monitoring (Azure Data Factory)
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Design and build data pipelines in Azure Data Factory
Schedule and trigger pipeline executions
Monitor and troubleshoot pipeline runs
Build ETL packages using SQL Server Integration Services
WHO SHOULD ATTEND
Data Engineers
PREREQUISITES
None
COURSE OUTLINE
01. SSIS in the Cloud - What you need to get started
02. Class Introduction
03. Getting Started with Azure (Navigating the Azure Portal)
04. Getting Started with Azure (Resource Groups)
05. Getting Started with Azure (Azure SQL DB & Azure Storage)
06. SSIS Hosted On-Prem (Azure Feature Pack)
07. SSIS Hosted On-Prem (Azure Blob Upload Task)
08. SSIS Hosted On-Prem (Azure Blob Download Task)
09. SSIS Hosted On-Prem (Azure Blob Source to Azure SQL DB)
10. SSIS Hosted On-Prem (Flat File Source)
11. SSIS Hosted On-Prem (Azure SQL DB to Azure SQL DB)
12. SSIS Hosted On-Prem (SSIS Deployment)
13. SSIS Hosted On-Prem (SSIS Package Execution)
14. Working with Azure Data Factory (Provisioning Azure Data Factory)
15. Azure Lift and Shift (Provisioning Azure SSIS Integration Runtime)
16. Azure Lift and Shift (Visual Studio Deployment)
17. Azure Lift and Shift (Management Studio Deployment)
18. Azure Lift and Shift (Execute SSIS Packages from Azure)
19. Azure Lift and Shift (Execute SSIS Packages from SSMS)
20. Scheduling a Pipeline (Schedule Triggers)
21. Monitoring (Azure Data Factory)
