Boost logo
Language
course | Advanced SQL

We turn your development needs and aspirations into powerful digital solutions that drive growth

IT-1262 | Advanced SQL

Course Sector : Information Technology

Duration
Date from
Date to Course Venue Course fees Book a course
5 Days2025-06-232025-06-27Dubai$4,250 Book now
5 Days2025-09-082025-09-12Dubai$4,250 Book now
5 Days2025-12-292026-01-02Los Angeles$5,950 Book now

Course Introduction

This training course is designed to provide participants with the advanced, new, and complex SQL techniques, allowing the delegates to understand the core innovative SQL concepts. This course creates capable SQL users, confident in executing more complicated commands when viewing and managing tables and running complex queries.

Training Course Methodology

 

 

The training course is designed to be interactive and participatory, and includes various learning tools to enable the participants to operate effectively and efficiently in a multifunctional environment. The course will use lectures and presentations, exercises, experiential and exposure to real world problems and policy choices confronting delegates.


Course objective

  • Apply advanced techniques in managing SQL such as advanced queries, how to add, update, and delete data, tables, views, and indexes.
  •  Enable the production of Databases and Apps.
  •  Scale emerging and dynamic technological networks
  • Confidently execute more complicated commands when viewing and managing tables and running complex queries.  

Course Outline | Day 01

Stored Procedure Basics

  • Pros and cons of stored procedures
  • Creating stored procedures
  • Three ways to execute
  • System stored procedures

Variables

  • Declaring variables
  • SET versus SELECT
  • Tricks with variables and rowsets
  • So-called global variables

Parameters and Return Values

  • Passing parameters
  • Default values and WHERE clauses
  • Output parameters
  • Using RETURN

Course Outline | Day 02

Avoiding Scalar Functions

  • What are scalar functions?
  • Some examples
  • Disadvantages of scalar functions
  • Three advantages

Testing Conditions

  • IF/ELSE statement
  • Using CASE where possible

Looping

  • Syntax of WHILE
  • Breaking out of a loop
  • Basic transactions
  • Beginning a transaction
  • Committing/rolling back
  • Deleting and updating
  • Using DELETE and UPDATE
  • Sys.Objects
  • Dropping objects

Course Outline | Day 03

Creating Tables

  • Creating Tables in SQL
  • Inserting data
  • Inserting single rows
  • Inserting multiple rows

Temporary Tables and Table Variables

  • Using temporary tables
  • Creating table variables
  • Pros and cons of each approach

Table Valued Functions

 

  • In-line table-valued functions
  • Multi- Statement table-valued functions
  • Limitations of user-defined functions

Course Outline | Day 04

Derived Tables and CTEs

  • Using derived tables
  • Common Table Expressions (CTEs)
  • Recursive CTEs

Subqueries

 

  • The concept of a subquery
  • Using ALL, ANY, and IN
  • Correlated subqueries
  • Using EXISTS

Course Outline | Day 05

Cursors

  • Syntax of fetching rows
  • When to use (and when not to)

Error-Handling

  • Using TRY/CATCH
  • System error functions
  • Custom error messages
  • The obsolete @@ error function

Debugging

 

  • Version differences
  • The Visual Studio debugger
  • The SQL Server debugger
  • Debugging (breakpoints, etc.
Course Certificates
BOOST Logo

BOOST’s Professional Attendance Certificate “BPAC”

BPAC is always given to the delegates after completing the training course,and depends on their attendance of the program at a rate of no less than 80%,besides their active participation and engagement during the program sessions.

Request a Quote
Follow us
facebook iconinstagram iconlinkedIn icontwitter icon
BOOST Logo

Since 2001, we have been pioneering the training field in the Middle East, helping individuals, teams, and organizations reach their full potential with integrated solutions.

left

🔗 Quick Links

Boost Abroad logoSparks logo

Sister Companies to Boost Consulting and Training

Training Image 1Training Image 2Training Image 3Training Image 4Training Image 5Training Image 6

We believe in progress for everyone.

We helped more than 10,000 clients over 20 countries on 4 continents in boosting their knowledge, skills, and careers.

Copy rights

Boost Training And Consulting All Copyrights Reserved 2025