SAVE – Special Offers – Click Here...
Latest News
SAVE – Special Offers – Click Here...

SQL Query Language - Advanced

Enquire About This Course

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
Latest News
SAVE – Special Offers – Click Here...