Duration
SQL Procedure Language Knowing and Enhancing
3 days
Overview
Take your SQL Server programming to the next level. First, we demystify how to manipulate datetime data by performing temporal exploratory data analysis with the dataset. Then, you’ll master how to create, update, and execute user-defined functions and stored procedures. You will learn the proper context for each modular programming tool and best practices.
Part 1 - 2 days
Stored procedures
- 1. Create Procedure with output
- 2. Output parameters vs. return values
- 3. CRUD
- 4. SP insert
- 5. SP update
- 6. SP delete
- 7. Execute
- 8. Execute with output
- 9. Knowing return value
- 10. Error capturing
- 11. Example of error handling
- 12. Knowing your error
- 13. User defined functions
- 14. Case Study
Part 2 - 1 day
- 1. Introduction to stored procedure performance
- 2. Informational messages
- 3. Use fully qualified procedure name
- 4. Alternative Execute for dynamic queries
- 5. Retrieve records with exist command
- 6. Stored procedure naming
- 7. Understanding based queries.
- 8. Keeping short and crisp for transaction in windows.
Programme scope, delivery arrangements and suitability are confirmed during enquiry.