Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server Training Course

Course

In City Of London

Price on request

Description

  • Type

    Course

  • Location

    City of london

The aim of this course is to provide a clear understanding of the advanced use of (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL. For more in depth coverage of the topics this course can be run as a three day course.

Facilities

Location

Start date

City Of London (London)
See map
Token House, 11-12 Tokenhouse Yard, EC2R 7AS

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Server
  • SQL

Course programme

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
  • PRINT
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

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server Training Course

Price on request