Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
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
Requirements
Delegates should be familiar with the Microsoft SQL Server SQL Language
Testimonials
Knowledge of the lecturer
Paweł Dybowski
I enjoyed the attention to detail, knowledge and enthusiasm for the subject.
Bristol City Council
It allowed us to have an applied hands on sproc to our company database.
Corneliu Buculei - Standard Building Supplies Ltd
Related Courses
SQL in Microsoft Access
14 hours
SQL in SQL Server
14 hours
Transact SQL Basic
14 hours
Transact SQL Advanced
7 hours
SQL Fundamentals
14 hours
SQL Advanced in MySQL
7 hours
SQL in MySQL
14 hours
ORACLE PL/SQL Fundamentals
21 hours
ORACLE SQL Fundamentals
14 hours
Oracle SQL Language
14 hours
Business Intelligence with SSAS
14 hours
Administration with Powershell
35 hours