Course not currently available

Advanced SQL, Stored Procedures & Triggers for Microsoft SQL Server

Training

In City Of London ()

Price on request

Description

  • Type

    Training

  • Level

    Advanced

  • Class hours

    21h

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. Suitable for: Delegates should be familiar with the Microsoft SQL Server SQL Language.

Questions & Answers

Add your question

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

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Transactions
  • Database Design
  • Microsoft Certifications
  • Server
  • SQL
  • Database Administration
  • Database training
  • Programming
  • IT
  • IT Development

Course programme

Course review:

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 & Triggers for Microsoft SQL Server

Price on request