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 utilizing 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 Enrollment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.

Live, Online

Private Team Training

Live, Online

Tuition — Standard: $690   Government: $520

Aug 29 (1 Day)
9:00 AM - 4:30 PM EDT
Online (AnyWare) Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online

Nov 29 (1 Day)
9:00 AM - 4:30 PM EST
Online (AnyWare) Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online

Feb 28 (1 Day)
9:00 AM - 4:30 PM EST
Online (AnyWare) Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online

May 29 (1 Day)
9:00 AM - 4:30 PM EDT
Online (AnyWare) Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online

Guaranteed to Run

Private Team Training

Enrolling 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 1-888-843-8733 or Click Here »

Tuition

Standard

Government

In Classroom or
Online

Standard

$690

Government

$520

Private Team Training

Contact Us »

Course Tuition 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 Course Hours:
9:00 am – 4:30 pm

Each Course Day:
Informal discussion with instructor about your projects or areas of special interest:
4:30 pm – 5:30 pm

- ,

Prev
Next
Chat Now

Please Choose a Language

Canada - English

Canada - Français