SQL Query Language - Advanced

Enquire About This Course

We are currently delivering Online SQL Query Language training via our Virtual Classroom - see our websites for more info:

https://www.mullanvirtualtraining.co.uk

https://powerbi-trainingbelfast.co.uk

Prerequisites

A very good working knowledge in SQL, or our introduction SQL Language course

 Course Contents

Review of Structured Query Language

• SELECT
• INSERT
• DELETE

 Advanced Update & Delete statements

• Sub-queries
• Correlated Sub-queries

 Programmability

• IF
• WHILE
• CASE
• GOTO
• RETURN

 Managing Errors

• Responding to errors
• RAISERROR
• PRINT

Stored Procedures

• Creating Stored Procedures
• Passing values into a stored Procedure
• Returning Information from Stored Procedures
• Altering Stored Procedures

 Triggers

• Introduction to Triggers
• Creating Triggers
• Transactional Error Handling
• Using Inserted and Deleted Tables

Click here to download Course Content

SQL Query Language Advanced pdf

Enquire About This Course