Get in Touch

Course Outline

Analytical Functions

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

Key Database Objects

  • Fundamentals of index usage
  • Creation and maintenance of indexes
  • Application of clustered tables
  • Application of partitioned tables
  • Leveraging metadata in the master database

Query Performance Tracing

  • Fundamentals of query execution and optimization
  • Utilization of the Execution Plan
  • Application of table and index statistics
  • Use of query hints

Basic Data Warehouse Techniques

  • Application of Indexed Views
  • Use of Dimension and fact tables
  • Application of Star and Snowflake designs
 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-14 09:30
7 hours
Fortaleza - Etevaldo Nogueira Building
$ 2543 (Online)
$ 3043 (Classroom)

Transact SQL Advanced

2026-10-28 09:30
7 hours
Curitiba - Corporate Evolution
$ 2543 (Online)
$ 3043 (Classroom)

Transact SQL Advanced

2026-11-11 09:30
7 hours
Belo Horizonte - Amadeus Business Tower
$ 2543 (Online)
$ 3043 (Classroom)

Transact SQL Advanced

2026-11-25 09:30
7 hours
Porto Alegre - Platinum Building
$ 2543 (Online)
$ 3043 (Classroom)

Transact SQL Advanced

2026-12-09 09:30
7 hours
Porto Alegre - Guaiba Business Center
$ 2543 (Online)
$ 3043 (Classroom)

Related Courses

Administering in Microsoft SQL Server

 21 Hours
In Brazil, this course enables administrators to effectively manage SQL Server. Participants gain expertise in database creation, applying SQL syntax for data access, and enforcing security protocols. Additionally, you will explore advanced capabilities like replication, automation, and BI to construct robust, real-world solutions.
Read more...

SQL Advanced

 14 Hours

This instructor-led, live training in Brazil (online or onsite) targets 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 on Brazil empowers data engineers to embed LLMs into their SQL environments. Learners will construct natural language pipelines, apply AI-driven optimization techniques, and engineer secure enterprise workflows for automated data analysis.

Read more...

SQL DATABASE MANAGEMENT AND DESIGN - Bespoke

 14 Hours
This instructor-led training in Brazil focuses on advanced SQL database management and design. Participants will gain proficiency in query commands, joins, and transaction management, while learning to construct robust schemas through entity-relationship modeling and ACID properties to ensure system reliability.
Read more...

SQL Advanced level for Analysts

21 Hours
This module within Brazil focuses on advanced SQL techniques for analysts, covering essential skills such as data retrieval, filtering, and sorting. You will gain proficiency in complex operations like joins, subqueries, and the application of analytic functions such as RANK and LAG. These skills enable you to perform sophisticated data analysis directly within Oracle, SQL Server, or MS Access environments.
Read more...

SQL Basics

 14 Hours
This live, instructor-led course on Brazil introduces the fundamentals of SQL for beginners, covering key concepts such as data extraction, filtering, aggregation, and joining tables. Through interactive lectures and hands-on lab sessions, participants learn to craft effective SQL statements to handle real-world querying and reporting challenges.
Read more...

SQL: Basics to Intermediate

 35 Hours

This instructor-led live training in Brazil (available online or onsite) is designed for beginner 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 Brazil takes you from basic querying to advanced techniques, including joins and aggregation. Through hands-on exercises and real-world datasets, you will build the skills to manipulate data, generate reports, and optimize performance for modern, effective database management.
Read more...

SQL Fundamentals

 14 Hours
This instructor-led training in Brazil enables participants to cultivate practical abilities for extracting and analyzing data from any relational database. Learners will master writing SQL queries, comprehend database architecture, and navigate diverse SQL dialects to produce robust reports.
Read more...

SQL Intermediate

 14 Hours
Live, instructor-led training in Brazil tailored for intermediate users. Develop proficiency in complex SQL queries, data manipulation, and performance tuning through advanced methodologies. The course incorporates practical exercises and live-lab sessions to enable the effective application of skills in real-world contexts.
Read more...

SQL language in MSSQL

 14 Hours
This practical SQL training in Brazil focuses on writing efficient queries for Microsoft SQL Server. It addresses relational models, data retrieval, filtering, and aggregation. Participants will gain proficiency in 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 in Brazil (available online or onsite) targets data scientists and developers looking to utilize and integrate SQL, Python, and Tableau to conduct sophisticated data analysis, processing, and visualization.

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

  • Prepare the necessary environment to conduct data analysis with SQL, Python, and Tableau.
  • Comprehend the essential concepts of software integration (data, servers, clients, APIs, endpoints, etc.).
  • Refresh their understanding of Python and SQL fundamentals.
  • Apply data pre-processing techniques in Python.
  • Discover how to link Python and SQL for data analysis purposes.
  • Generate insightful data visualizations and charts with Tableau.
Read more...

Business Intelligence with SSAS

 14 Hours
This practical course on Brazil delves into SQL Server Analysis Services for sophisticated BI and data modeling. Learners will master the design of OLAP cubes, the utilization of MDX queries, and the deployment of robust solutions, acquiring the essential skills needed to facilitate data-driven decision-making in modern business contexts.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led, live training in Brazil (online or onsite) targets 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 program in Brazil concentrates on engineering sophisticated SSIS data flows and transformations. Learners will gain proficiency in managing Slowly Changing Dimensions, processing complex data sources, and deploying stable packages to support efficient data warehousing and migration initiatives.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server
SQL
SQL