• Venue
  • Register
  • FAQs
  • Contact
  • Time Zone

SQL Intermediate to Advanced

Batch Price From £360 (approx. $455 USD) View Dates & Prices
Custom Price From £240 (approx. $303 USD) Price Calculator & Booking
Short course on Microsoft SQL Server Database Designing
Total Duration: 12 Hours
Course level: Advanced
Delivery Method: Instructor-led Physical Classes or Virtual Classes
Certification: Certificate of Completion will be provided after completing the course

Course Overview

Presently, individuals with an understanding of advanced SQL techniques are in great demand by employers. Advanced SQL knowledge can help you to enhance your position if you are already in employment.

This course is designed to further your understanding of structured query language (SQL) and improve your skills and expand your knowledge. Our Intermediate to Advanced SQL course builds upon the skills learnt in our Introduction to SQL course. It covers windowing, CTEs, dynamic SQL, logical functions, control flow, creating user-defined functions, stored procedures and cursors. You'll also learn how to improve query performance, transaction processing and error handling.

Requirements

You should have a prior understanding of SQL to attend this course.

We highly recommend you complete the following course(s) before attending the SQL Intermediate to Advanced course:

Course Dates, Prices & Enrolment

All Training Physical Classes Virtual Classes
Time Zone:
Training MethodDates and TimesPrice 
Online Training using Zoom 23 Mar 2024 - 07 Apr 2024
3 Saturdays & 3 Sundays
11:00 AM - 01:00 PM ET
£360 £420
(approx. $455 USD)
Enrol Now
Online Training using Zoom 10 Apr 2024 - 26 Apr 2024
3 Wednesdays & 3 Fridays
10:00 AM - 12:00 PM ET
£360 £420
(approx. $455 USD)
Enrol Now
Online Training using Zoom 04 May 2024 - 19 May 2024
3 Saturdays & 3 Sundays
10:00 AM - 12:00 PM ET
£360 £420
(approx. $455 USD)
Enrol Now
Online Training using Zoom 07 May 2024 - 14 May 2024
Mondays & Tuesdays
05:00 AM - 09:00 AM ET
£420
(approx. $531 USD)
Full
Online Training using Zoom 15 May 2024 - 31 May 2024
3 Wednesdays & 3 Fridays
10:00 AM - 12:00 PM ET
£360 £420
(approx. $455 USD)
Enrol Now
Online Training using Zoom 15 Jun 2024 - 30 Jun 2024
3 Saturdays & 3 Sundays
10:00 AM - 12:00 PM ET
£360 £420
(approx. $455 USD)
Enrol Now
Online Training using Zoom 19 Jun 2024 - 05 Jul 2024
3 Wednesdays & 3 Fridays
10:00 AM - 12:00 PM ET
£360 £420
(approx. $455 USD)
Enrol Now
Online Training using Zoom 20 Jul 2024 - 04 Aug 2024
3 Saturdays & 3 Sundays
10:00 AM - 12:00 PM ET
£360 £420
(approx. $455 USD)
Enrol Now

Course Content

  1. Setting Up a SQL Server Environment
    • Setting up Databases
    • IF an object EXISTS
  2. Built-In Functions
    • Introduction to Built-In Functions
    • Using System Functions
    • Conversion Functions - CONVERT
    • Using Mathematical functions
    • Using String Functions
  3. Date and Time Functions
    • GETDATE
    • DATEADD
    • DATEDIFF
    • DATENAME
    • DATEPART
    • DAY, MONTH and YEAR
    • Using CONVERT to format a date/time
  4. Subqueries
    • Introduction of Subqueries
    • Subqueries vs Joining Tables
    • Subqueries with Comparison Operators
    • Subqueries with IN and NOT IN Operators
  5. Multi-Table Queries
    • Joining Tables
    • INNER JOIN
    • INNER JOIN with more than two Tables
    • OUTER JOIN
    • CROSS JOIN
    • SELF JOIN
  6. Aggregate Functions and Group by
    • Using Aggregate Functions
    • Using GROUP BY Clause
    • Using HAVING Clause
    • Aggregate Queries with Multiple Tables
  7. Temporary Tables and Table Variables
    • Using temporary tables
    • Creating table variables
  8. Common Table Expressions (CTE)
    • Introduction to CTE
    • Using CTE
    • Multiple CTE in a single query
  9. Logical Functions
    • Using IIF Function
    • Using CASE
    • Using CASE WHEN
  10. Local & Global variables
    • Introduction to variables
    • Variable data types
    • Local variables
    • Using Global variables
  11. Control of Flow
    • IF...ELSE
    • BEGIN...END
  12. User-Defined Functions - UDFs
    • Introduction to UDFs
    • Creating a Scalar-Valued Function
  13. Stored Procedures
    • Introduction to Stored Procedures
    • Creating User Stored Procedures
    • Stored Procedure with Parameters

Price Calculator & Booking Request Form

Calculate prices for Corporate, 1-on-1 or group training and request a booking.

Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to:

  • book a course on different dates
  • book for a group of delegates
  • book corporate training
  • book a customised training
  • book a one-on-one training

The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below:


Share This Course

Save Money with Packages

SAVE up to 20% by booking this course with other related courses as shown below:

SQL Beginner to Advanced

£560 (save £140)

This package combines
Find out more & book now

Newsletter Sign-up