SQL Training – SQL Server Stored Procedure
Course
In Cardiff
Description
-
Type
Course
-
Location
Cardiff (Wales)
-
Duration
1 Day
-
Start date
Different dates available
The Knowledge Academy Writing Stored Procedures 1 day course covers the following topics:
Introduction
Participants of this course will be introduced to the best practices for building simple stored procedures and will be provided with the opportunity to gain hands-on experience of handling programming errors.
Facilities
Location
Start date
Start date
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 8 years
Subjects
- Server
- IT
- SQL
- Writing
- Programming
- IF-ELSE
- WHILE
- Variables
- Parameters
- Querying
Course programme
Candidates should be familiar with basic SQL queries.
Who should attend?
This course is ideal for technical users and developers who need to understand how to build stored procedures that retrieve and modify data.
What will you learn?
- How to build stored procedures that retrieve and modify data
- How to implement IF-ELSE, WHILE and BEGIN-END blocks
- How to manipulate variables and parameters
Course Outline
- Techniques for building simple stored procedures
- Methods for using procedural extensions to Transact-SQL
- Implementing IF-ELSE, WHILE and BEGIN-END blocks
- Declaring local variables
- Declaring input/output parameters
- Techniques for handling programming errors
Additional information
SQL Training – SQL Server Stored Procedure