Advanced SQL for Professionals
Featuring AI Tools
MQA Approved
Training Overview
This Advanced SQL training is designed for professionals looking to expand their SQL expertise with complex querying techniques, query performance optimization, and modern reporting techniques. Participants will gain hands-on experience on multi-table joins, subqueries, and foundational performance optimization using execution plans and indexes. They will explore reporting capabilities with grouping sets and pivoting for multidimensional data analysis, and powerful analytic functions for deeper insights and data presentation. Participants will also be introduced to AI Tools like GitHub Copilot to support SQL development and analysis. While the training is designed around T-SQL on SQL Server, those with SQL experience on other relational databases, such as Oracle and others, are also encouraged to join, as the core concepts and logic apply broadly across platforms.
Who is it for?
This training is ideal for professionals with at least 2 years of experience in T-SQL or SQL, who already possess foundational to intermediate knowledge. The target audience for this training is:
- Data professionals working with relational databases
- Developers and Testers who frequently query data and validate logic
- Business Int elligence (BI) professionals and Analysts seeking more advanced querying and reporting techniques
- Application support engineers performing in-depth analysis with SQL
- IT practitioners who want to learn how to integrate AI tools into their SQL workflow responsibly and effectively
What You'll Learn
You'll gain practical skills through a mix of lectures, hands-on exercises, group work, and real-world projects - all designed to help you apply what you learn immediately. You'll explore the following modules:
1. Setting up and exploring the Sample Database
- Installation of SQL Server Management Studio and Visual Studio Code
- Connection to SQL Server
- Exploring the sample database
2. Querying Multiple Tables with Joins
- Overview of the Join Concepts and Syntax
- Understanding and implementing the different types of Joins: Inner Join, Outer Joins, Cross Join and Self Join
- Performance considerations and best practices when joining multiple tables
3. Understanding Query Performance Optimization
- Analyzing query plans and enhancing query performance
- Using Indexes to optimize performance while following Index Design recommended practices
4. Aggregate Functions
- Grouping with GROUP BY
- Filtering groups with the HAVING clause
- Managing NULLs
- Avoiding common mistakes when filtering queries involving GROUP functions
5. Advanced Reporting using Grouping Sets and Pivoting Data
- Implementing multiple groupings using Grouping Sets
- Using ROLLUP and CUBE to create subtotals
- Tips on identifying Groupings in Results
- Pivoting Data using PIVOT while including aggregation
6. Advanced Window and Analytic Functions
- Using ROW_NUMBER(), RANK() and DENSE_RANK() Window Functions
- Understanding the importance of ORDER BY while working with certain Window functions
- Using PARTITION BY to introduce aggregates in multiple levels - each partition
- Using the LAG and LEAD functions
7. Use of Artificial Intelligence for SQL
- Guidance on security best practices: respecting company policies, avoiding the sharing of sensitive or confidential data, and understanding the risks when using AI tools online
- Using SQL-Aware AI Tools
- Using GitHub Copilot as your AI pair programmer for SQL - exploring several use cases while writing good Prompts
8. Using Subqueries
- Building Subqueries using Scalar and Multi-Valued subqueries
- Understanding Self-Contained and Correlated subqueries
- Understanding the use of EXISTS and the performance implication
- Using derived tables
- Using Common Table Expressions - Implementing reusable subqueries
Your Trainer
The training will be delivered by myself, Mehfooz Kausmally: Certified SQL Expert with nearly 12 years of experience as a developer in multinational companies. Having worked extensively with complex databases and backend systems, I bring real-world expertise into the training.
After a successful career in the IT industry, I have transitioned into a full-time role as a professional trainer and coach, specializing in SQL and backend technologies. I have already trained over 270 engineers, and counting, in different technologies at different levels. My approach blends deep technical knowledge with practical, hands-on, scenario-driven learning, ensuring participants gain skills they can immediately apply to their day-to-day roles.
Upcoming Batch
Course Fee
Rs 55,000 Rs 47,900
At only Rs 12,000 approx. after up to 75% HRDC refund (Conditions apply).
- MQA Approved Training Course, in collaboration with Honoris Educational Network Ltd
- Up to 75% HRDC Refund available (Conditions apply)
- Final course price after HRDC Refund: approx. Rs 13,000
October 2025 Batch Schedule
- 5 full-day intensive training, during the last 3 weeks of October
- Dates: 14, 16, 22, 28, and 30 October 2025
- First 4 days: Online live sessions
- Final day: In-person classroom session in Ebene, Mauritius (venue to be confirmed soon)
- This training will run with a minimum of 4 participants to ensure a great interactive learning experience
Express Your Interest
Don't miss your chance to advance your SQL skills with this exclusive training! Register your interest below and secure your spot for priority access. All key details, including the confirmed venue will be shared with you as soon as they are finalized. Fill out the form below to register your interest.
Need More Information?
Have questions about the training? We're here to help! Reach out to us through the appropriate channel below:
Technical & Course Content
For questions about course content, technical requirements, or learning objectives, contact the trainer, Mehfooz, directly:
Registration & HRDC Refund
For registration process, HRDC refund queries, and administrative matters, contact Nasifah from Honoris: