Writing Stored Procedures Training

Nivå: Intermediate
Snittbetyg: 4,5/5 4,50/5 Based on 10 Reviews

This Stored Procedures training course provides an introduction to leveraging the programming extensions to the Transact-SQL language. Through hands-on practical exercises, this course will teach you how to create robust, stored procedures that improve the performance and security of applications, and the essential skills to write production-quality SQL Server stored procedures.


  • Train your whole team by bringing this course to your facility
  • After-course instructor coaching

Du kommer lära dig att:

  • 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

Välj den utbildningsform som passar dig bäst



  • Använd denna eller någon annan utbildning i ditt företag
  • Fullskalig programutveckling
  • Levereras när, var och hur du vill
  • Blandade utbildningsmodellerSkräddarsytt innehåll
  • Coaching av ett expertteam
View Details ›

Anpassa kurs och innehåll efter teamets behov

Kontakta oss

Utveckla dig och ditt team med anpassade eller öppna kurser alternativt e-learning

Learning Tree erbjuder kundanpassad utbildning hos er, öppna kurser i Stockholm, London eller Washington, möjlighet att delta via våra Anywhere centers (Malmö, Göteborg, Linköping, Stockholm eller Borlänge) eller olika former av e-learning med lärarstöd. Läs mer på www.learningtree.se/priser .


Important Stored Procedures Course Information

  • Requirements

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

Stored Procedures Course Outline

  • 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

Stored Procedures Training FAQs

  • What is a stored procedure?

    Stored procedures are the programming extensions to the Transact-SQL language.

  • Can I bring this SQL query course to my facility to teach my team how to create stored procedures?

    Learning Tree provides Private Team Training that can save time and travel costs by training your entire team at once, at a convenient location of your choice. We handle all the details including instructor travel, tailored content, comprehensive course materials, shipping and equipment setup and teardown.

Questions about which training is right for you?

call 08-506 668 00

100% Satisfaction Guaranteed

Your Training Comes with a 100% Satisfaction Guarantee!*

*Partner-delivered courses may have different terms that apply. Ask for details.

Hur föredrar du att bli kontaktad:

Please Choose a Language

Canada - English

Canada - Français