SQL Server performance is as much an art form as it is a science. Many times a server will give conflicting information about the state that it is in. The SQL Server Performance Tuning training is designed to provide SQL DBAs with the tools and knowledge that is required to keep their SQL Servers running efficiently and reliably. Additionally, you will experience how to perform advanced performance tuning and optimization in your everyday DBA work.
Overview
COURSE DIFFICULTY
COURSE DURATION
5h 14m
Skills Learned
After completing this online training course, students will be able to:
Create automated workflows using Power Automate
Handle errors and exceptions in flows
Power Automate Developers, Database Administrators
None
01. SQL Stored Procedures - What you need to get started
02. Class Introduction
03. What are Stored Procedures
04. Creating your first stored procedure
05. Modifying stored procedures
06. Adding parameters to stored procedures
07. Working with output parameters
08. Output parameters in Power Automate
09. Permissions for stored procedures
10. Error handling with Try..Catch
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Create automated workflows using Power Automate
Handle errors and exceptions in flows
WHO SHOULD ATTEND
Power Automate Developers, Database Administrators
PREREQUISITES
None
COURSE OUTLINE
01. SQL Stored Procedures - What you need to get started
02. Class Introduction
03. What are Stored Procedures
04. Creating your first stored procedure
05. Modifying stored procedures
06. Adding parameters to stored procedures
07. Working with output parameters
08. Output parameters in Power Automate
09. Permissions for stored procedures
10. Error handling with Try..Catch
