MS SQL Server Advanced Course, 2-Day , Live Online Classroom

MS SQL Server Advanced Course, 2-Day , Live Online Classroom

Actions and Detail Panel

Sales Ended

Date and time


Online event

Refund policy

No Refunds

Advanced SQL Course. More about DML, DDL Queries and automation. Instructor-led. Practical. Online.

About this event

SQL Advanced Course

Duration: 2 consecutive days, the first thereof showing as the booking date

Pre-requisite: Basic understanding of SQL queries.

Location: Online, booking link emailed upon booking.

This SQL Advanced course is excellent for delegates who work daily on SQL. Read more

SQL Advanced Course details

Revising MS SQL Server query basics, joins, aggregates, string and date functions

SQL Sub-queries

  • Derived Tables and CTEs

Views, Indexes, Sequencing

SQL Stored Procedure 

  • Variables
  • Parameters and Return Values
  • Looping


  • User defined Functions
  • Table Valued Functions
  • Scalar Functions
  • Cursors
  • Triggers

Creating Tables in SQL


  • Not Null
  • Unique
  • Default
  • Check
  • Primary Key
  • Foreign Key
  • Identity / Auto-increments

SQL Temporary Tables and Table Variables


  • ·SQL System error functions
  • ·Customizing SQL error messages
  • ·@@ error function

Debugging ·The SQL Server debugger, Debugging (breakpoints, etc.)

System requirements: Your SQL Database, query interface and sample data must be ready before the course starts.

Read more:

Share with friends