Get in Touch
 Duration 7 hours

Course Outline

Analytical Functions

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

Essential Database Objects

  • Core concepts of index utilization
  • Strategies for creating and maintaining indexes
  • Implementation of clustered tables
  • Utilization of partitioned tables
  • Accessing metadata within the master database

Query Performance Tracing

  • Fundamentals of query execution and optimization
  • Interpreting Execution Plans
  • Leveraging table and index statistics
  • Applying query hints

Foundational Data Warehouse Methods

  • Implementation of Indexed Views
  • Utilization of Dimension and fact tables
  • Application of Star and Snowflake design schemas

Number of participants


Price per participant

Open Training Courses require 5+ participants.

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-11-16 09:30
7 hours
Mirobod
11,298,753 UZS (Online)
12,298,753 UZS (Classroom)

Transact SQL Advanced

2026-11-30 09:30
7 hours
Mirobod
11,298,753 UZS (Online)
12,298,753 UZS (Classroom)

Transact SQL Advanced

2026-12-14 09:30
7 hours
Mirobod
11,298,753 UZS (Online)
12,298,753 UZS (Classroom)

Transact SQL Advanced

2026-12-28 09:30
7 hours
Mirobod
11,298,753 UZS (Online)
12,298,753 UZS (Classroom)

Related Courses

SQL Advanced

 14 Hours

This instructor-led, live training in Uzbekistan (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 instructor-led live training in Uzbekistan empowers data engineers to seamlessly integrate LLMs into SQL environments. Participants will learn to build natural language pipelines, apply AI-driven optimization, and design secure enterprise workflows for automated data analysis.

Read more...

SQL DATABASE MANAGEMENT AND DESIGN - Bespoke

 14 Hours
This instructor-led training on Uzbekistan focuses on advanced SQL database management and design. Participants will gain mastery over query commands, joins, and transaction management, while learning to construct robust schemas through entity-relationship modeling and ACID properties for dependable systems.
Read more...

Oracle Database 19c Performance Management and Tuning

 28 Hours

This instructor-led, live training in Uzbekistan (online or onsite) is aimed at intermediate-level database administrators and IT professionals who wish to optimize the performance of Oracle Database 19c.

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

  • Understand Oracle Database 19c performance tuning concepts.
  • Use performance management tools effectively.
  • Optimize database performance through tuning techniques.
  • Troubleshoot and resolve performance issues.
Read more...

Oracle SQL - advanced

 14 Hours

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

This course is tailored for users, developers, or administrators who have some prior experience with Oracle databases and aim to enhance and organize their expertise. It acts as a follow-up to the ORA_S1 training.

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

  • Leverage advanced SQL skills to store and process data efficiently, including optimization, analysis, and various extraction methods. Gain knowledge of database architecture and its advanced features to build robust applications.

Course Format

  • Interactive lectures and discussions.
  • Extensive exercises and hands-on practice.
  • Practical implementation in a live-lab environment.

Customization Options

  • To request a customized version of this course, please contact us to arrange it.
Read more...

SQL Advanced level for Analysts

21 Hours
This Uzbekistan level course offers analysts advanced SQL training, focusing on data retrieval, filtering, and sorting techniques. Participants will gain proficiency in joins, subqueries, and analytic functions such as RANK and LAG, enabling them to perform complex data analyses directly within Oracle, SQL Server, or MS Access environments.
Read more...

SQL Basics

 14 Hours
This live-led course on Uzbekistan introduces SQL fundamentals for novices, covering data extraction, filtering, summarization, and table joining. Through interactive instruction and practical lab work, learners will gain the skills to write effective SQL queries for practical database analysis and reporting.
Read more...

SQL: Basics to Intermediate

 35 Hours

This instructor-led live training in Uzbekistan (available online or onsite) targets beginner to intermediate data analysts, database professionals, and software developers seeking to learn SQL for effective database management.

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

  • Grasp and utilize core SQL commands and queries
  • Create and modify tables and databases
  • Employ SQL to organize, filter, and summarize data
  • Execute complex operations such as joins, subqueries, and set operations
  • Apply intermediate-level techniques including indexes, views, stored procedures, and triggers
Read more...

SQL For Data Science and Data Analysis

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

SQL Fundamentals to Advanced Querying

 10 Hours
This instructor-led SQL training in Uzbekistan leads beginners through advanced querying, joins, and aggregation. Develop practical abilities via hands-on exercises and real-world datasets to manipulate data, generate reports, and optimize performance for effective, modern database administration.
Read more...

SQL Fundamentals

 14 Hours
This instructor-led training in Uzbekistan equips participants with the practical abilities needed to extract and interpret data from any relational database. The curriculum covers writing SQL queries, understanding underlying database structures, and navigating various SQL dialects to produce effective reports.
Read more...

SQL Intermediate

 14 Hours
Instructor-led live training in Uzbekistan for intermediate users. Master complex SQL queries, data manipulation, and performance optimization through advanced techniques. Includes hands-on exercises and a live lab to apply skills to real-world scenarios effectively.
Read more...

Business Intelligence with SSAS

 14 Hours
This practical training module focuses on Uzbekistan, exploring SQL Server Analysis Services for advanced Business Intelligence and data modeling. Learners will gain the expertise to design OLAP cubes, apply MDX queries, and deploy robust solutions, acquiring the practical skills necessary to facilitate data-driven decision-making for contemporary business operations.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led live training, held Uzbekistan (online or onsite), targets beginner-level data professionals who want to learn how to design, implement, and manage SSIS packages for 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 live, instructor-led course in Uzbekistan emphasizes the design of advanced SSIS data flows and transformations. Learners will gain proficiency in implementing Slowly Changing Dimensions, managing complex data inputs, and deploying stable packages to optimize data warehousing and migration workflows.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server
SQL
SQL