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 Enrolment: 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: $640   Government: $570

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

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

How would you like to attend?

Live, Online

Oct 3 (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

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

Tuition

Standard

Government

In Classroom or
Online

Standard

$640

Government

$570

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
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm

FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:

  • Have a record of your growth and learning results
  • Bring proof of your progress back to your organization
  • Earn credits toward industry certifications (if applicable)

- ,

Prev
Next
Chat Now

Please Choose a Language

Canada - English

Canada - Français