Preferred method of contact:

Writing Stored Procedures

COURSE TYPE

Intermediate

Course Number

4563

Duration

1 Day

PDF Add to WishList

Gain an introduction to leveraging the programming extensions to the Transact-SQL language. Through hands-on practical exercises, this training course provides the fundamental knowledge to create robust procedures that improve the performance and security of applications, and the essential skills to write production-quality SQL Server stored procedures.

You Will Learn How To

  • Take advantage of procedural extensions to Transact-SQL
  • Build simple stored procedures
  • Declare local variables and input/output parameters
  • Handle errors such as primary and foreign key violations

Important Course Information

Requirements:

  • A solid foundation in SQL and be comfortable in utilising SQL Server Management Studio

Hands-On Experience:

  • Coding a simple retrieval procedure
  • Implementing IF-ELSE, WHILE and BEGIN-END blocks
  • Declaring and manipulating variables and parameters
  • Nesting stored procedures
  • Programming error handling logic

Convenient Ways to Attend This Instructor-Led Course

Hassle-Free Enrolment: No advance payment required to reserve your seat.
Tuition Fee due 30 days after you attend your course.

Live, Online

Private Team Training

Live, Online

Tuition Fee — Standard: £495  

AFTERNOON START: Attend these live courses online via Anyware

28 Feb (1 Day)
2:00 PM - 9:30 PM GMT
Online (AnyWare) Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online

29 May (1 Day)
2:00 PM - 9:30 PM BST
Online (AnyWare) Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online

19 Jul (1 Day)
2:00 PM - 9:30 PM BST
Online (AnyWare) Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online

3 Oct (1 Day)
2:00 PM - 9:30 PM BST
Online (AnyWare) Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online

Guaranteed to Run

Private Team Training

Enroling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.

For details, call 0800 282 353 or Click here »

Tuition Fee

Standard

In Classroom or
Online

Standard

£495

Private Team Training

Contact Us »

Course Tuition Fee Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

After-Course Computing Sandbox
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.

Prev
Next

Training Hours

Standard class hours:
9:00 a.m. - 4:30 p.m.

Last day class hours:
9:00 a.m. - 3:30 p.m.

Free Course Exam – Last Day:
3:30 p.m. - 4:30 p.m.

Each class day:
Informal discussion with instructor about your projects or areas of special interest:
4:30 p.m. - 5:30 p.m.

AFTERNOON START class hours:
2:00 p.m. - 9:30 p.m.


Last day class hours:
2:00 p.m. - 8:30 p.m.


Free Course Exam – Last Day:
8:30 p.m. - 9:30 p.m.


Each class day:
Informal discussion with instructor about your projects or areas of special interest
9:30 p.m. - 10:30 p.m.

- ,

Prev
Next
Chat Now

Please Choose a Language

Canada - English

Canada - Français