GET 20% OFF on regular prices . Use this promo code during booking: WINTER21

SQL Intermediate to Advanced 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 Online/Classroom Training
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

Training
Method		Dates and Times
(in the UK)		Dates and Times
(if not in the UK)		Price 
Online Training using Zoom 08 Dec 2021 - 17 Dec 2021
Wed, Thu & Fri
6pm - 8pm 		Start Date & Time
End Date & Time 		£300 £360
Enrol Now
Online Training using Zoom 18 Dec 2021 - 19 Dec 2021
Saturday to Sunday
10am - 5pm 		Start Date & Time
End Date & Time 		£300 £360
Enrol Now
Online Training using Zoom 11 Jan 2022 - 13 Jan 2022
Tuesday & Thursday
10am - 5pm 		Start Date & Time
End Date & Time 		£360
Enrol Now
Online Training using Zoom 17 Jan 2022 - 28 Jan 2022
Mon, Wed & Fri
6pm - 8pm 		Start Date & Time
End Date & Time 		£360
Enrol Now
Online Training using Zoom 22 Jan 2022 - 30 Jan 2022
2 Weekends
11am - 2pm 		Start Date & Time
End Date & Time 		£380
Enrol Now
Online Training using Zoom 09 Feb 2022 - 11 Feb 2022
Wednesday & Friday
10am - 5pm 		Start Date & Time
End Date & Time 		£360
Enrol Now
Online Training using Zoom 14 Feb 2022 - 25 Feb 2022
Mon, Wed & Fri
6pm - 8pm 		Start Date & Time
End Date & Time 		£360
Enrol Now
Online Training using Zoom 19 Feb 2022 - 27 Feb 2022
2 Weekends
11am - 2pm 		Start Date & Time
End Date & Time 		£360
Enrol Now
Online Training using Zoom 02 Mar 2022 - 04 Mar 2022
Wednesday & Friday
10am - 5pm 		Start Date & Time
End Date & Time 		£360
Enrol Now
Online Training using Zoom 07 Mar 2022 - 18 Mar 2022
Mon, Wed & Fri
6pm - 8pm 		Start Date & Time
End Date & Time 		£360
Enrol Now
Online Training using Zoom 12 Mar 2022 - 20 Mar 2022
2 Weekends
11am - 2pm 		Start Date & Time
End Date & Time 		£360
Enrol Now
Online Training using Zoom 23 Mar 2022 - 25 Mar 2022
Wednesday & Friday
10am - 5pm 		Start Date & Time
End Date & Time 		£360
Enrol Now
Online Training using Zoom 28 Mar 2022 - 08 Apr 2022
Mon, Wed & Fri
6pm - 8pm 		Start Date & Time
End Date & Time 		£360
Enrol Now
Online Training using Zoom 02 Apr 2022 - 10 Apr 2022
2 Weekends
11am - 2pm 		Start Date & Time
End Date & Time 		£360
Enrol Now
Online Training using Zoom 27 Apr 2022 - 29 Apr 2022
Wednesday & Friday
10am - 5pm 		Start Date & Time
End Date & Time 		£360
Enrol Now
Online Training using Zoom 02 May 2022 - 13 May 2022
Mon, Wed & Fri
6pm - 8pm 		Start Date & Time
End Date & Time 		£360
Enrol Now
Online Training using Zoom 07 May 2022 - 15 May 2022
2 Weekends
11am - 2pm 		Start Date & Time
End Date & Time 		£360
Enrol Now
Online Training using Zoom 01 Jun 2022 - 03 Jun 2022
Wednesday & Friday
10am - 5pm 		Start Date & Time
End Date & Time 		£360
Enrol Now
Online Training using Zoom 06 Jun 2022 - 17 Jun 2022
Mon, Wed & Fri
6pm - 8pm 		Start Date & Time
End Date & Time 		£360
Enrol Now
Online Training using Zoom 11 Jun 2022 - 19 Jun 2022
2 Weekends
11am - 2pm 		Start Date & Time
End Date & Time 		£360
Enrol Now
Online Training using Zoom 29 Jun 2022 - 01 Jul 2022
Wednesday & Friday
10am - 5pm 		Start Date & Time
End Date & Time 		£360
Enrol Now
Online Training using Zoom 04 Jul 2022 - 15 Jul 2022
Mon, Wed & Fri
6pm - 8pm 		Start Date & Time
End Date & Time 		£360
Enrol Now
Online Training using Zoom 09 Jul 2022 - 17 Jul 2022
2 Weekends
11am - 2pm 		Start Date & Time
End Date & Time 		£360
Enrol Now

Full Course Outline

  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 - CAST and 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
    • Subqueries with EXISTS and NOT EXISTS
  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 Extensions
    • GROUP BY CUBE, ROLLUP and GROUPING SETS
    • Using CASE with aggregate functions
    • Using PIVOT and UNPIVOT
  7. Windowing
    • Ranking Functions
    • ROW_NUMBER
    • RANK and DENSE_RANK
    • NTILE
  8. Common Table Expressions (CTE)
    • Introduction to CTE
    • Non-Recursive CTE
    • Recursive CTE
    • When to use CTEs, and When not to
  9. Dynamic SQL
    • Introduction to Dynamic SQL
    • Using sp_executesql
    • Using Output parameters with sp_executesql
    • Temp tables in Dynamic SQL
  10. Temporary Tables and Table Variables
    • Using temporary tables
    • Creating table variables
  11. Logical Functions
    • Using IIF Function
    • Using CHOOSE
    • Using GREATEST and LEAST
    • Using CASE
  12. Local & Global variables
    • Introduction to variables
    • Variable data types
    • Local variables
    • Using Global variables
  13. Control of Flow
    • IF...ELSE
    • BEGIN...END
    • Using WHILE loops
  14. User-Defined Functions - UDFs
    • Introduction to UDFs
    • Creating a Scalar-Valued Function
    • Creating an Inline Table-Valued Function
  15. Stored Procedures
    • Introduction to Stored Procedures
    • Creating User Stored Procedures
    • Stored Procedure with Parameters
  16. Cursors
    • Introduction to CURSORS
    • CURSOR with FETCH
    • When to use cursors and when not to
  17. Transaction Processing
    • Introduction to Transaction Processing
    • Working with BEGIN TRANSACTION
    • Working with COMMIT & ROLLBACK
    • Using the TRANCOUNT Global Variable
  18. Error Handling
    • Using TRY/CATCH
    • Using @@ERROR
    • Using ERROR_NUMBER
    • Using ERROR_MESSAGE
    • Custom error messages
  19. 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:

Save Money with Packages

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

SQL Immersive

£480 (save £60)

This package combines
Find out more & book now

Newsletter Sign-up

We are providing affordable IT training courses at times to suit you - enhance your employability and stand out from the crowd.

Become an IT expert and get that competitive edge that employers are looking for.

Popular Courses

Useful Links

Contact Us

London Academy of IT
Unit 15, Boardman House
64 Broadway
Stratford
London E15 1NT
United Kingdom
Tel: +44 (0)208 432 6218

2012 - 2021 © London Academy of IT Limited. All Rights Reserved.
Registered in England & Wales with company no. 07923992. VAT no. GB200 4290 68.