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

Description

• Type

  Course

• Methodology

  Online

Description

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.

About this course

Requirements

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

I agree to the Privacy Policy and the Conditions.

Send

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Request information

We are verifying your question adjusts to our publishing rules. According to your answers, we noticed you might not be elegible to enroll into this course, possibly because of: qualification requirements, location or others. It is important you consult this with the Centre.

Thank you!

We are reviewing your question. We will publish it shortly.

Or do you prefer the center to contact you?

Request information

Reviews

Have you taken this course? Share your opinion

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

Additional information

14 hours (usually 2 days including breaks)

See related categories

• Server courses
• Distance learning Server courses
• SQL courses
• Distance learning SQL courses
• Oracle sql courses
• Data analysis sql courses
• Sql intermediate courses
• Transact sql courses
• SQL Server courses
• Distance learning SQL Server courses
• Distance learning Course
• Nobleprog Limited courses