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

SQL Query Language - Intermediate

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 Content

Review of Structured Query Language

  • SELECT
  • UPDATE

Advanced Select Statements

  • The GROUP BY clause
  • The HAVING Clause
  • Sub-queries
  • Correlated Sub-queries 

Advanced Update & Delete statements

  • Sub-queries
  • Correlated Sub-queries

Programmability

  • IF
  • WHILE
  • CASE
  • GOTO
  • RETURN

Managing Errors

  • Print

Using Transactions

  • Introduction to Transaction
  • Transaction Isolation Levels
  • Deadlocks
  • Transactional Error Handling

Stored Procedures

  • Introduction to Stored Procedures
  • Creating Stored Procedures
  • Altering Stored Procedures

Click here to download Course Content

SQL Query Language Intermediate pdf

Enquire About This Course
Latest News
SAVE – Special Offers – Click Here...