SQL Intermediate to Advanced

SQL Fundamentals knowledge and experience.

This instructor-led, live training (online or onsite) is aimed at intermediate to advanced level users who wish to use learn more about SQL.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Extended Use Of Summary Functions

        - Group_Concat

        - Rollup

        - Grouping Function

Window Functions

        - Summarising

        - Ranking

        - Lead & Lag

        - Percentiles

Extended Use Of Sub-Queries

        - Common Table Expression

        - Columns

Recursive Common Table Expressions

        - Hierarchical Queries

        - Reporting Grids

Stored Procedures

• Use of parameters
• Use of IF statements
• Use of Loops & Cursors

Execution Plan

Indexes