Stored Procedure

This training will 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 gain an introduction to leveraging the programming extensions to the Transact-SQL language. Through hands-on practical exercises.


  1. Stored Procedure
    • 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