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 using indexes
  • Techniques for creating and maintaining indexes
  • Application of clustered tables
  • Utilization of partitioned tables
  • Exploration of metadata within the master database

Query Performance Tracing

  • Foundations of query execution and optimization
  • Interpreting the Execution Plan
  • Leveraging table and index statistics
  • Application of query hints

Foundational Data Warehouse Techniques

  • Implementation of Indexed Views
  • Use of Dimension and fact tables
  • Application of Star and Snowflake schemas
 7 Hours

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-10-27 09:30
7 hours
Empire Tower
31607 THB (Online)
31607 THB (Classroom)

Transact SQL Advanced

2026-11-10 09:30
7 hours
Empire Tower
31607 THB (Online)
31607 THB (Classroom)

Transact SQL Advanced

2026-11-24 09:30
7 hours
Empire Tower
31607 THB (Online)
31607 THB (Classroom)

Transact SQL Advanced

2026-12-08 09:30
7 hours
Empire Tower
31607 THB (Online)
31607 THB (Classroom)

Related Courses

Administering in Microsoft SQL Server

 21 Hours
In Thailand, this training equips administrators with the skills to manage SQL Server efficiently. Participants will master database creation, utilize SQL syntax for data retrieval, and enforce security protocols. You will also investigate advanced features like replication, automation, and BI to construct complex, practical solutions.
Read more...

SQL Advanced

 14 Hours

This live, instructor-led training in Thailand (available online or on-site) is tailored for intermediate-level database administrators, developers, and analysts who aspire to perfect advanced SQL functionalities for complex data operations and database management.

By the conclusion 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 course in Thailand empowers data engineers to seamlessly integrate LLMs into their SQL environments. Learners will construct natural language pipelines, apply AI-driven optimization techniques, and design secure enterprise workflows to support automated data analysis.

Read more...

SQL DATABASE MANAGEMENT AND DESIGN - Bespoke

 14 Hours
This instructor-led course in Thailand focuses on advanced SQL database management and design. Learners will gain proficiency in query commands, joins, and transaction management, while developing robust schemas through entity-relationship modeling and ACID compliance to ensure system reliability.
Read more...

SQL Advanced level for Analysts

21 Hours
This course in Thailand teaches advanced SQL for analysts, covering data selection, filtering, and sorting. You will master joins, subqueries, and analytic functions like RANK and LAG, enabling complex data analysis directly within Oracle, SQL Server, or MS Access databases.
Read more...

SQL Basics

 14 Hours
This instructor-led training in Thailand introduces SQL fundamentals for beginners, covering key areas such as data retrieval, filtering, aggregation, and joins. Through interactive lectures and practical lab exercises, participants learn to craft effective SQL statements for real-world database querying and reporting scenarios.
Read more...

SQL: Basics to Intermediate

 35 Hours

This live, instructor-led session in Thailand (online or onsite) is designed for data analysts, database specialists, and software developers at beginner to intermediate levels who aim to enhance their database management capabilities using SQL.

By the conclusion of this training, participants will be capable of:

  • Understanding and executing fundamental SQL commands and queries.
  • Building and modifying database tables and structures.
  • Using SQL to organize, filter, and summarize datasets.
  • Executing complex operations such as joins, subqueries, and set operations.
  • Applying intermediate techniques including indexes, views, stored procedures, and triggers.
Read more...

SQL Fundamentals to Advanced Querying

 10 Hours
This instructor-led SQL training in Thailand takes learners from foundational concepts to advanced querying, joins, and aggregation. Through hands-on exercises and real-world datasets, participants build practical skills to manipulate data, generate reports, and optimize performance for effective, modern database management.
Read more...

SQL Fundamentals

 14 Hours
This instructor-led session in Thailand focuses on developing practical capabilities to extract and analyze data from relational databases. Participants will gain proficiency in writing SQL queries, interpreting database architecture, and navigating various SQL dialects to produce impactful reports.
Read more...

SQL Intermediate

 14 Hours
Live instructor-led training in Thailand tailored for intermediate users. Gain proficiency in complex SQL queries, data manipulation, and performance optimization through advanced methodologies. The program features practical exercises and a live lab to effectively apply skills to real-world challenges.
Read more...

SQL language in MSSQL

 14 Hours
This practical SQL course in Thailand focuses on developing efficient query-writing skills for Microsoft SQL Server. It provides a comprehensive overview of relational models, alongside techniques for data retrieval, filtering, and aggregation. Upon completion, participants will have mastered multi-table joins, subqueries, and DML operations, enabling them to manipulate business intelligence datasets effectively and consistently.
Read more...

Data Analysis with SQL, Python, and Tableau

 14 Hours

This live, instructor-led training, delivered in Thailand (either online or onsite), targets data scientists and developers aiming to harness SQL, Python, and Tableau for advanced data analysis, processing, and visualization.

By the end of the program, participants will be able to:

  • Set up the necessary environment to perform data analysis with SQL, Python, and Tableau.
  • Understand the key concepts of software integration (data, servers, clients, APIs, endpoints, etc.).
  • Get a refresher on the fundamentals of Python and SQL.
  • Perform data pre-processing techniques in Python.
  • Learn how to connect Python and SQL for data analysis.
  • Create insightful data visualizations and charts with Tableau.
Read more...

Business Intelligence with SSAS

 14 Hours
This practical course on Thailand delves into SQL Server Analysis Services for advanced BI strategies and data modeling. Learners will master the design of OLAP cubes, the application of MDX queries, and the deployment of robust solutions, equipping them with the expertise necessary to foster data-driven decisions within modern business environments.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led, live training in Thailand (available online or on-site) is designed for beginner-level data professionals aiming to acquire the skills necessary to design, implement, and manage SSIS packages for data integration and transformation tasks.

Upon completion, participants will be capable of:

  • Understanding the architecture and components of SSIS.
  • Designing and implementing ETL processes using SSIS.
  • Utilizing SSIS tools to develop, deploy, and manage data integration solutions.
  • Troubleshooting and optimizing SSIS packages for performance and reliability.
Read more...

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

 14 Hours
This instructor-led training in Thailand is dedicated to mastering advanced SSIS data flow design and complex transformations. Learners will gain expertise in implementing Slowly Changing Dimensions, managing intricate data sources, and deploying resilient packages to support efficient data warehousing and migration initiatives.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server
SQL
SQL