img

SQL Intermediate to Advanced Training Course

SQL Intermediate to Advanced

  • $480.00
  • 12 hours
  • Intermediate to Advanced
  • Instructor Led Online/Classroom Training
  • SQL Intermediate to Advanced training 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

Time Zone:
DatesPrice
Tue 28 Jun 2022 - Tue 14 Jul 2022
03:00 PM - 05:00 PM (CT)
2 Tuesdays & 2 Thursdays (6-day)
$480
Closed
Tue 16 Aug 2022 - Tue 01 Sep 2022
03:00 PM - 05:00 PM (CT)
3 Tuesdays & 3 Thursdays (6-day)
$480
Enrol Now
Tue 04 Oct 2022 - Tue 20 Oct 2022
03:00 PM - 05:00 PM (CT)
3 Tuesdays & 3 Thursdays (6-day)
$480
Enrol Now
Tue 22 Nov 2022 - Tue 08 Dec 2022
03:00 PM - 05:00 PM (CT)
3 Tuesdays & 3 Thursdays (6-day)
$480
Enrol Now
  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

Shares

Subscribe To Our Onlinesletter

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor

Copyright © 2022 LAIT.training. Owned by the E4Academy Ltd. All rights reserved.