Get in Touch

Course Outline

Analytical Functions

  • Application of advanced summary functions
  • Implementation of hierarchical queries
  • Use of analytical summary functions, such as moving averages and running totals
  • Application of ranking functions

Essential Database Objects

  • Core principles of index utilisation
  • Methods for creating and maintaining indexes
  • Use of clustered tables
  • Utilisation of partitioned tables
  • Leveraging metadata within the master database

Query Performance Analysis

  • Foundations of query execution and optimisation
  • Interpreting Execution Plans
  • Utilising table and index statistics
  • Application of query hints

Foundational Data Warehouse Techniques

  • Use of Indexed Views
  • Employment of dimension and fact tables
  • Implementation of Star and Snowflake design patterns
 7 Hours

Need help picking the right course?
uae@nobleprog.com or +971 4871 6715

Testimonials (7)

The lecture about cte

Glyssa Mae - Metropolitan Bank and Trust Company
Course - Transact SQL Advanced

Really enjoyed compression data components

James - Medtech Limited
Course - Transact SQL Advanced

new techniques and style

Goniforte Balane - MORESCO-1
Course - Transact SQL Advanced

Some additional tips given to us that is somewhat outside topic area

John Erzon Tan - MORESCO-1
Course - Transact SQL Advanced

Outside topic tips Randomized new IDS, Indexes, Window function The joke was too funny and realistic

ALBERT SANDIG - MORESCO-1
Course - Transact SQL Advanced

when the trainer lets us do task one by one. the additional tips and ideas given to us and also the joke haha

Carl Sherwin Francis Llenares - MORESCO-1
Course - Transact SQL Advanced

Trainer is knowledgeable about the topic, and he really knows what he is doing. I appreciate the pacing and helps the trainees if there is a problem. He is also very engaging and very patient. Gives us words of encouragement very often and keeps training interesting.

Bianca Angela Yap - Human Edge Software Philippines, Inc. (part of Tribal Group)
Course - Transact SQL Advanced

Upcoming Courses

Transact SQL Advanced

2026-10-06 09:30
7 hours
Hyatt Regency - Dubai Creek Heights

Transact SQL Advanced

2026-10-20 09:30
7 hours
Business Village Block B

Transact SQL Advanced

2026-11-03 09:30
7 hours
Hamdan Innovations

Transact SQL Advanced

2026-11-17 09:30
7 hours
Business Bay

Transact SQL Advanced

2026-12-01 09:30
7 hours
Bay Square - Business Bay

Related Courses

SQL Advanced

 14 Hours

This instructor-led, live training in the UAE (online or onsite) is aimed at intermediate-level database administrators, developers, and analysts who wish to master advanced SQL functionalities for complex data operations and database management.

By the end of this training, participants will be able to:

  • Perform advanced querying techniques using unions, subqueries, and complex joins.
  • Add, update, and delete data, tables, views, and indexes with precision.
  • Ensure data integrity through transactions and manipulate database structures.
  • Create and manage databases efficiently for robust data storage and retrieval.
Read more...

AI for SQL: Leveraging Large Language Models for Intelligent Querying and Optimization

 21 Hours
This live, instructor-led training in the UAE empowers data engineers to seamlessly integrate LLMs into SQL environments. Learners will construct natural language pipelines, apply AI-driven optimization techniques, and design secure, enterprise-grade workflows for automated data analysis.
Read more...

SQL DATABASE MANAGEMENT AND DESIGN - Bespoke

 14 Hours
This instructor-led training on the UAE delves into advanced SQL database administration and architecture. Learners will develop expertise in complex query commands, join operations, and transaction handling, while constructing resilient schemas through entity relationship modeling and ACID principles to guarantee system reliability.
Read more...

Oracle Database 19c Performance Management and Tuning

 28 Hours

This instructor-led live training, offered in the UAE (online or onsite), targets intermediate-level database administrators and IT professionals aiming to optimize Oracle Database 19c performance.

By the conclusion of this training, participants will be able to:

  • Understand performance tuning concepts in Oracle Database 19c.
  • Effectively utilize performance management tools.
  • Enhance database performance via tuning techniques.
  • Troubleshoot and address performance challenges.
Read more...

SQL Advanced level for Analysts

21 Hours
This course in the UAE equips analysts with advanced SQL skills, focusing on data selection, filtering, and sorting. Learners will gain proficiency in joins, subqueries, and analytic functions such as RANK and LAG, enabling them to perform sophisticated data analysis directly within Oracle, SQL Server, or MS Access environments.
Read more...

SQL Basics

 14 Hours
This guided training in the UAE provides an introduction to SQL for beginners, focusing on core concepts such as data retrieval, filtering, aggregation, and table joins. Through interactive discussions and practical lab sessions, participants learn to craft effective SQL queries suitable for real-world database analysis and reporting.
Read more...

SQL: Basics to Intermediate

 35 Hours

This instructor-led, live training in the UAE (online or onsite) is designed for beginner to intermediate-level data analysts, database professionals, and software developers aiming to learn SQL for effective database management.

Upon completion of this training, participants will be able to:

  • Understand and utilize fundamental SQL commands and queries.
  • Create and manipulate tables and databases.
  • Leverage SQL to sort, filter, and summarize data.
  • Execute complex operations such as joins, subqueries, and set operations.
  • Apply intermediate techniques including indexes, views, stored procedures, and triggers.
Read more...

SQL For Data Science and Data Analysis

 14 Hours
This live training in the UAE helps developers and analysts master SQL for big data. Participants learn to query large datasets efficiently using MySQL, Postgres, HiveQL, and Redshift, while exploring data modeling and NoSQL systems to wrangle data into reporting tools effectively.
Read more...

SQL Fundamentals to Advanced Querying

 10 Hours
This instructor-led SQL training in the UAE walks beginners through advanced querying, joins, and aggregation. You will develop practical skills using hands-on exercises and real datasets to manipulate data, generate reports, and optimize performance for effective, modern database management.
Read more...

SQL Fundamentals

 14 Hours
This instructor-led the UAE training facilitates the development of practical abilities for extracting and analysing data from relational databases. Learners will master the creation of SQL queries, gain insight into database architecture, and navigate diverse SQL dialects to produce robust reports.
Read more...

SQL Intermediate

 14 Hours
Instructor-led live training in the UAE tailored for intermediate users. Develop proficiency in complex SQL queries, data manipulation, and performance optimization through advanced methodologies. The program features hands-on exercises and a live lab to effectively apply skills to real-world situations.
Read more...

SQL language in MSSQL

 14 Hours
This hands-on SQL training in the UAE focuses on writing efficient queries for Microsoft SQL Server. It covers relational models, data retrieval, filtering, and aggregation. Participants will gain mastery over multi-table joins, subqueries, and DML operations to manipulate business intelligence datasets with confidence.
Read more...

Business Intelligence with SSAS

 14 Hours
This practical training in the UAE delves into SQL Server Analysis Services for advanced Business Intelligence and data modeling. Learners will gain the skills to design OLAP cubes, utilize MDX queries, and implement robust solutions, thereby acquiring the practical capabilities necessary to drive data-informed decisions within modern business operations.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led, live training in the UAE (online or onsite) is aimed at beginner-level data professionals who wish to learn how to design, implement, and manage SSIS packages to perform data integration and transformation tasks.

By the end of this training, participants will be able to:

  • Understand the architecture and components of SSIS.
  • Design and implement ETL processes using SSIS.
  • Use SSIS tools to develop, deploy, and manage data integration solutions.
  • Troubleshoot and optimize SSIS packages for performance and reliability.
Read more...

SQL Server 2022 Integration Services (SSIS) – Data Flows and Advanced Transformations

 14 Hours
This instructor-led session in the UAE concentrates on the design of advanced SSIS data flows and transformations. Learners will gain mastery over Slowly Changing Dimensions, manage complex data sources, and deploy robust packages to support efficient data warehousing and migration initiatives.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server
SQL
SQL