Advanced SQL for Professionals – Featuring AI Tools
Duration: 5 Days
4 Days Online and 1 Day Face to Face
MQA Approved and HRDC Refundable*
About the Training
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 should attend?
- 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 Intelligence (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
Course Content
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:
- Installation of SQL Server Management Studio and Visual Studio Code
- Connection to SQL Server
- Exploring the sample database
- 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
- Analyzing query plans and enhancing query performance
- Using Indexes to optimize performance while following Index Design recommended practices
- Grouping with GROUP BY
- Filtering groups with the HAVING clause
- Managing NULLs
- Avoiding common mistakes when filtering queries involving GROUP functions
- 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
- 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
- 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
- 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
Trainer Profile
The training will be delivered by 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, he brings real-world expertise into the training.
After a successful career in the IT industry, he has transitioned into a full-time role as a professional trainer and coach, specializing in SQL and backend technologies. He has already trained over 270 engineers, and counting, in different technologies at different levels. His 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,000Rs 47,900
At only Rs 12,000 approx. after up to 75% HRDC refund (Conditions apply).
- MQA Approved Training Course
- Up to 75% HRDC Refund available (Conditions apply)
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
