Advanced SQL, Stored Procedures and Triggers for Microsoft SQL...
Certificate ID:
741427
Authentication Code:
85e36
Certified Person Name:
Katarzyna Sapalska
Trainer Name:
Łukasz Sokołowski
Duration Days:
2
Duration Hours:
14
Course Name:
Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Course Date:
30 October 2023 09:00 to 31 October 2023 16:00
Course Outline:
Review of Structured Query Language
- DQL, DML, DDL
- The GROUP BY, HAVING Clause
- Sub-queries and Correlated Sub-queries
- Advanced Update & Delete Statements
- Sub-queries
- Correlated Sub-queries
Procedural Programming
- Variables
- Control-Of-Flow Statements
- IF, WHILE, CASE, GOTO, RETURN
Managing Errors
- Responding To Errors
- RAISERROR
Using Transactions
- Introduction To Transactions
- Transaction Isolation Levels
- Deadlocks
- Transactional Error Handling
Implementing Cursors
- Declaring Cursors
- OPEN, FETCH, CLOSE
- DEALLOCATE
- CURRENT OF
Stored Procedures
- Creating Stored Procedures
- Passing values into a Stored Procedure
- Returning Information From Stored Procedures
- Altering Stored Procedures
Triggers
- Creating Triggers
- Transactional Error Handling
- Using Inserted and Deleted Tables