Intermediate to Advanced SQL Training Course

Short course on Microsoft SQL Server Database Designing

Regular Course Price: £360.00

Total Duration: 12 Hours
Course level: Intermediate to 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.

Skills Required

You should have a prior understanding of SQL to attend this course. Our Introduction to SQL training course covers all of the prerequisites for this Intermediate to Advanced SQL course.

Course Dates, Prices & Enrolment

All Training Physical Classes Virtual Classes

Training Method	Dates and Times (in the UK)	Dates and Times (if not in the UK)	Duration	Price
Classroom Training	27 Jun 2022 - 01 Jul 2022 Mon, Wed & Fri 11am - 3:30pm	Start Date & Time End Date & Time	3 Sessions	£360	Enrol Now
Online Training using Zoom	28 Jun 2022 - 14 Jul 2022 2 Tuesdays & 2 Thursdays 3pm - 5pm	Start Date & Time End Date & Time	6 Sessions	£300 £360	Enrol Now
Online Training using Zoom	25 Jul 2022 - 29 Jul 2022 Mon, Wed & Fri 10am - 2pm	Start Date & Time End Date & Time	3 Sessions	£360	Enrol Now
Online Training using Zoom	30 Jul 2022 - 13 Aug 2022 3 Saturdays 10am - 2pm	Start Date & Time End Date & Time	3 Sessions	£360	Enrol Now
Online Training using Zoom	13 Aug 2022 - 27 Aug 2022 3 Saturdays 9:30am - 1:30pm	Start Date & Time End Date & Time	3 Sessions	£300 £360	Enrol Now
Online Training using Zoom	16 Aug 2022 - 01 Sep 2022 3 Tuesdays & 3 Thursdays 3pm - 5pm	Start Date & Time End Date & Time	6 Sessions	£300 £360	Enrol Now
Online Training using Zoom	22 Aug 2022 - 26 Aug 2022 Mon, Wed & Fri 10am - 2pm	Start Date & Time End Date & Time	3 Sessions	£360	Enrol Now
Online Training using Zoom	03 Sep 2022 - 17 Sep 2022 3 Saturdays 10am - 2pm	Start Date & Time End Date & Time	3 Sessions	£360	Enrol Now
Online Training using Zoom	19 Sep 2022 - 23 Sep 2022 Mon, Wed & Fri 10am - 2pm	Start Date & Time End Date & Time	3 Sessions	£360	Enrol Now
Online Training using Zoom	01 Oct 2022 - 15 Oct 2022 3 Saturdays 9:30am - 1:30pm	Start Date & Time End Date & Time	3 Sessions	£300 £360	Enrol Now
Online Training using Zoom	04 Oct 2022 - 20 Oct 2022 3 Tuesdays & 3 Thursdays 3pm - 5pm	Start Date & Time End Date & Time	6 Sessions	£300 £360	Enrol Now
Online Training using Zoom	08 Oct 2022 - 22 Oct 2022 3 Saturdays 10am - 2pm	Start Date & Time End Date & Time	3 Sessions	£360	Enrol Now
Online Training using Zoom	17 Oct 2022 - 21 Oct 2022 Mon, Wed & Fri 10am - 2pm	Start Date & Time End Date & Time	3 Sessions	£360	Enrol Now
Online Training using Zoom	12 Nov 2022 - 26 Nov 2022 3 Saturdays 10am - 2pm	Start Date & Time End Date & Time	3 Sessions	£360	Enrol Now
Online Training using Zoom	14 Nov 2022 - 18 Nov 2022 Mon, Wed & Fri 10am - 2pm	Start Date & Time End Date & Time	3 Sessions	£360	Enrol Now
Online Training using Zoom	19 Nov 2022 - 03 Dec 2022 3 Saturdays 9:30am - 1:30pm	Start Date & Time End Date & Time	3 Sessions	£300 £360	Enrol Now
Online Training using Zoom	22 Nov 2022 - 08 Dec 2022 3 Tuesdays & 3 Thursdays 3pm - 5pm	Start Date & Time End Date & Time	6 Sessions	£300 £360	Enrol Now
Online Training using Zoom	12 Dec 2022 - 16 Dec 2022 Mon, Wed & Fri 10am - 2pm	Start Date & Time End Date & Time	3 Sessions	£360	Enrol Now

Full Course Outline

Setting Up a SQL Server Environment
- Setting up Databases
- IF an object EXISTS
Built-In Functions
- Introduction to Built-In Functions
- Using System Functions
- Conversion Functions - CAST and CONVERT
- Using Mathematical functions
- Using String Functions
Date and Time Functions
- GETDATE
- DATEADD
- DATEDIFF
- DATENAME
- DATEPART
- DAY, MONTH and YEAR
- Using CONVERT to format a date/time
Subqueries
- Introduction of Subqueries
- Subqueries vs Joining Tables
- Subqueries with Comparison Operators
- Subqueries with IN and NOT IN Operators
- Subqueries with EXISTS and NOT EXISTS
Multi-Table Queries
- Joining Tables
- INNER JOIN
- INNER JOIN with more than two Tables
- OUTER JOIN
- CROSS JOIN
- SELF JOIN
Aggregate Functions and Group by Extensions
- GROUP BY CUBE, ROLLUP and GROUPING SETS
- Using CASE with aggregate functions
- Using PIVOT and UNPIVOT
Windowing
- Ranking Functions
- ROW_NUMBER
- RANK and DENSE_RANK
Common Table Expressions (CTE)
- Introduction to CTE
- Non-Recursive CTE
- Recursive CTE
- When to use CTEs, and When not to
Dynamic SQL
- Introduction to Dynamic SQL
- Using sp_executesql
- Using Output parameters with sp_executesql
- Temp tables in Dynamic SQL
Temporary Tables and Table Variables
- Using temporary tables
- Creating table variables
Logical Functions
- Using IIF Function
- Using CHOOSE
- Using GREATEST and LEAST
- Using CASE
Local & Global variables
- Introduction to variables
- Variable data types
- Local variables
- Using Global variables
Control of Flow
- IF...ELSE
- BEGIN...END
- Using WHILE loops
User-Defined Functions - UDFs
- Introduction to UDFs
- Creating a Scalar-Valued Function
- Creating an Inline Table-Valued Function
Stored Procedures
- Introduction to Stored Procedures
- Creating User Stored Procedures
- Stored Procedure with Parameters
Cursors
- Introduction to CURSORS
- CURSOR with FETCH
- When to use cursors and when not to
Transaction Processing
- Introduction to Transaction Processing
- Working with BEGIN TRANSACTION
- Working with COMMIT & ROLLBACK
- Using the TRANCOUNT Global Variable
Error Handling
- Using TRY/CATCH
- Using @@ERROR
- Using ERROR_NUMBER
- Using ERROR_MESSAGE
- Custom error messages
Query Performance
- Improving query performance
- Clustered Indexes
- Non-Clustered Index

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:

How many hours?

How many people?

Total Cost

Price per person

Preferred Dates and Times

Any other information

Related Courses

Save Money with Packages

SAVE more than 15% by booking this course with other related courses as shown below:

SQL Immersive

£540 (save £60)

This package combines

Introduction to SQL
(6 hours)
Intermediate to Advanced SQL
(12 hours)

Find out more & book now

Newsletter Sign-up

First Name

Last Name

Email address

Load More Posts

SQL

Data

Programming

Testing

Web