Get in Touch
 Duration 7 hours

Course Outline

Analytical Functions

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

Useful Database Objects

  • Core principles of index usage
  • Methods for creating and maintaining indexes
  • Application of clustered tables
  • Utilization of partitioned tables
  • Use of metadata stored in the master database

Query Performance Tracing

  • Fundamentals of query execution and optimization
  • Interpretation of Execution Plans
  • Leveraging table and index statistics
  • Application of query hints

Basic Data Warehouse Techniques

  • Use of Indexed Views
  • Implementation of Dimension and fact tables
  • Application of Star and Snowflake schema designs

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
Puerto Madero - Torre Colonos Sur
2543 USD (Online)
3043 USD (Classroom)

Transact SQL Advanced

2026-11-30 09:30
7 hours
Buenos Aires - Laminar Catalinas
2543 USD (Online)
3043 USD (Classroom)

Transact SQL Advanced

2026-12-14 09:30
7 hours
Buenos Aires - Libertador
2543 USD (Online)
3043 USD (Classroom)

Transact SQL Advanced

2026-12-28 09:30
7 hours
Còrdoba - Ecipsa Tower
2543 USD (Online)
3043 USD (Classroom)

Transact SQL Advanced

2027-01-11 09:30
7 hours
Puerto Madero - Torre Colonos Sur
2543 USD (Online)
3043 USD (Classroom)

Related Courses

Administering in Microsoft SQL Server

 21 Hours
In Argentina, this course equips administrators with the expertise to manage SQL Server efficiently. Participants will master database creation, apply SQL syntax for data manipulation, and enforce robust security protocols. Additionally, you will delve into advanced functionalities like replication, automation, and BI to construct sophisticated, real-world solutions.
Read more...

SQL Advanced

 14 Hours

This instructor-led live training in Argentina (online or onsite) is designed for intermediate 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 Argentina empowers data engineers to seamlessly integrate LLMs into their SQL environments. Participants will learn to construct natural language pipelines, execute AI-driven optimizations, and design secure enterprise workflows for automated data analysis.

Read more...

SQL DATABASE MANAGEMENT AND DESIGN - Bespoke

 14 Hours
This instructor-led program in Argentina focuses on advanced SQL database management and design. Learners will acquire mastery over query commands, join operations, and transaction control, while learning to construct robust schemas through entity relationship modeling and ACID compliance to ensure system reliability.
Read more...

SQL Advanced level for Analysts

21 Hours
This module in Argentina focuses on advanced SQL techniques tailored for analysts, covering essential skills in data retrieval, filtering, and sorting. Learners will gain proficiency in constructing joins, writing subqueries, and utilizing analytic functions such as RANK and LAG, enabling sophisticated data analysis directly within Oracle, SQL Server, or MS Access environments.
Read more...

SQL Basics

 14 Hours
This live-led course in Argentina introduces SQL fundamentals to beginners, covering data extraction, filtering, aggregation, and joining. Through interactive lectures and practical labs, it enables participants to craft effective SQL queries for practical database analysis and reporting needs.
Read more...

SQL: Basics to Intermediate

 35 Hours

This instructor-led, live training in Argentina (online or onsite) is aimed at beginner-level to intermediate-level data analysts, database professionals, and software developers who wish to learn SQL to manage databases effectively.

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

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

SQL Fundamentals to Advanced Querying

 10 Hours
This instructor-led SQL course in Argentina takes beginners through the journey to advanced querying, joins, and aggregation. Participants build practical abilities through hands-on exercises and real-world datasets, enabling them to manipulate data, generate reports, and optimize performance for modern, effective database management.
Read more...

SQL Fundamentals

 14 Hours
This instructor-led training in Argentina equips learners with the hands-on expertise required to pull and analyze data from any relational database. Participants will master writing SQL queries, grasp database architecture, and navigate different SQL dialects to produce effective reports.
Read more...

SQL Intermediate

 14 Hours
Live instructor-led training in Argentina tailored for intermediate users. Develop expertise in complex SQL queries, data manipulation, and performance optimization through advanced methods. The course features hands-on exercises and a live lab to effectively apply skills to real-world contexts.
Read more...

SQL language in MSSQL

 14 Hours
This practical SQL training in Argentina focuses on writing efficient queries for Microsoft SQL Server. It encompasses relational models, data retrieval, filtering, and aggregation strategies. Participants will gain mastery over multi-table joins, subqueries, and DML operations to effectively manage business intelligence datasets.
Read more...

Data Analysis with SQL, Python, and Tableau

 14 Hours

This instructor-led live training, available Argentina (online or onsite), targets data scientists and developers who aim to utilize and integrate SQL, Python, and Tableau for advanced data analysis, processing, and visualization.

Upon completing this training, participants will be equipped to:

  • Configure the necessary environment for performing data analysis using SQL, Python, and Tableau.
  • Grasp essential concepts of software integration, including data handling, servers, clients, APIs, and endpoints.
  • Review and solidify their understanding of core Python and SQL principles.
  • Apply data pre-processing techniques within Python.
  • Establish connections between Python and SQL to facilitate robust data analysis.
  • Design compelling data visualizations and charts using Tableau.
Read more...

Business Intelligence with SSAS

 14 Hours
This practical training on Argentina delves into SQL Server Analysis Services for sophisticated BI and data modeling. Learners will acquire the skills to construct OLAP cubes, apply MDX queries, and deploy sturdy solutions, ultimately enabling data-driven decision-making that supports modern business operations.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This live, instructor-led training in Argentina (online or on-site) is designed for beginner-level data professionals who wish 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 instructor-led course in Argentina is dedicated to the design of sophisticated SSIS data flows and transformations. Learners will gain expertise in implementing Slowly Changing Dimensions, managing complex data sources, and deploying resilient packages to streamline data warehousing and migration processes.

Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server
SQL
SQL