Get in Touch
 Duration 7 hours

Course Outline

Analytical Functions

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

Essential Database Objects

  • Foundational principles of index usage
  • Methods for creating and maintaining indexes
  • Utilization of clustered tables
  • Utilization of partitioned tables
  • Leveraging metadata within the master database

Query Performance Tracing

  • Core principles of query execution and optimization
  • Utilization of Execution Plans
  • Application of table and index statistics
  • Implementation of query hints

Foundational Data Warehouse Techniques

  • Use of Indexed Views
  • Application of Dimension and fact tables
  • Implementation of Star and Snowflake 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
Riga, Old Town
1500 EUR (Online)
1700 EUR (Classroom)

Transact SQL Advanced

2026-11-30 09:30
7 hours
Riga, Old Town
1500 EUR (Online)
1700 EUR (Classroom)

Transact SQL Advanced

2026-12-14 09:30
7 hours
Riga, Old Town
1500 EUR (Online)
1700 EUR (Classroom)

Transact SQL Advanced

2026-12-28 09:30
7 hours
Riga, Old Town
1500 EUR (Online)
1700 EUR (Classroom)

Transact SQL Advanced

2027-01-11 09:30
7 hours
Riga, Old Town
1500 EUR (Online)
1700 EUR (Classroom)

Transact SQL Advanced

2027-01-25 09:30
7 hours
Riga, Old Town
1500 EUR (Online)
1700 EUR (Classroom)

Related Courses

Administering in Microsoft SQL Server

 21 Hours
In Latvia, this training empowers administrators to manage SQL Server effectively. Learners master database creation, SQL syntax for data retrieval, and security protocols. You will also explore advanced features like replication, automation, and BI to build complex, real-world solutions.
Read more...

SQL Advanced

 14 Hours

This live, instructor-guided program in Latvia (delivered online or on-site) is designed for intermediate database administrators, developers, and analysts aiming to command advanced SQL features for complex data handling and database administration.

Upon finishing this program, participants will be capable of:

  • Applying advanced query techniques that utilize unions, subqueries, and intricate joins.
  • Accurately adding, modifying, and deleting data, tables, views, and indexes.
  • Guaranteeing data integrity through transaction management and database structure manipulation.
  • Efficiently creating and maintaining databases to support strong 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 Latvia empowers data engineers to seamlessly integrate LLMs into their SQL environments. Learners will develop proficiency in constructing natural language pipelines, executing AI-driven optimizations, and architecting secure, enterprise-grade workflows for automated data analysis.

Read more...

SQL DATABASE MANAGEMENT AND DESIGN - Bespoke

 14 Hours
This instructor-led training in Latvia focuses on advanced SQL database administration and design. Attendees will gain mastery of query commands, joins, and transaction control while learning to construct resilient schemas through Entity-Relationship modeling and ACID compliance to ensure system reliability.
Read more...

SQL Advanced level for Analysts

21 Hours
This course in Latvia equips analysts with advanced SQL skills, focusing on data selection, filtering, and sorting. Participants will gain proficiency in joins, subqueries, and analytic functions such as RANK and LAG, facilitating complex data analysis directly within Oracle, SQL Server, or MS Access environments.
Read more...

SQL Basics

 14 Hours
This guided instructional module on Latvia introduces SQL fundamentals for newcomers, covering essential tasks such as data extraction, filtering, summarization, and table integration. Through interactive lectures and practical labs, learners are equipped to craft efficient SQL queries suited for practical database analysis and reporting.
Read more...

SQL: Basics to Intermediate

 35 Hours

This instructor-led live training, delivered in Latvia (either online or on-site), is tailored for data analysts, database professionals, and software developers with beginner to intermediate expertise who seek to proficiently manage databases using SQL.

By the end of this session, participants will be capable of:

  • Understanding and deploying essential SQL commands and queries.
  • Creating and managing database tables and structures.
  • Utilizing SQL to sort, filter, and aggregate data sets.
  • Implementing complex logic through joins, subqueries, and set operations.
  • Applying intermediate techniques such as optimizing with indexes, creating views, and managing stored procedures and triggers.
Read more...

SQL Fundamentals to Advanced Querying

 10 Hours
This instructor-led SQL training in Latvia guides beginners through advanced querying, joins, and aggregation. Build practical skills with hands-on exercises and real datasets to manipulate data, create reports, and optimize performance for effective, modern database management.
Read more...

SQL Fundamentals

 14 Hours
This instructor-led training in Latvia equips participants with the practical abilities needed to extract and analyse data from any relational database. You will master the art of writing SQL queries, gain a deep understanding of database structures, and learn to leverage different SQL dialects to produce effective reports.
Read more...

SQL Intermediate

 14 Hours
Live instructor-led Latvia training designed for intermediate users. Develop expertise in complex SQL queries, data manipulation, and performance optimization via advanced methodologies. Features practical exercises and a live lab to facilitate the effective application of skills in real-world contexts.
Read more...

SQL language in MSSQL

 14 Hours
This practical SQL training in Latvia focuses on writing efficient queries for Microsoft SQL Server. It examines relational models, data retrieval, filtering, and aggregation. Participants will master multi-table joins, subqueries, and DML operations to confidently manipulate business intelligence datasets.
Read more...

Data Analysis with SQL, Python, and Tableau

 14 Hours

This instructor-led, live training in Latvia (online or on-site) is tailored for data scientists and developers aiming to integrate SQL, Python, and Tableau to handle complex data analysis, processing, and visualization tasks.

Upon completion, participants will be able to:

  • Set up the required environment for data analysis with SQL, Python, and Tableau.
  • Understand key software integration concepts such as data, servers, clients, APIs, and endpoints.
  • Review the fundamentals of Python and SQL.
  • Execute data pre-processing techniques using Python.
  • Learn to link Python with SQL for enhanced data analysis.
  • Produce insightful visualizations and charts in Tableau.
Read more...

Business Intelligence with SSAS

 14 Hours
This hands-on training in Latvia delves into SQL Server Analysis Services for advanced BI and data modeling. Participants will learn to design OLAP cubes, utilize MDX queries, and deploy robust solutions, acquiring practical skills to facilitate data-driven decision-making for modern business operations.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This live, instructor-led course in Latvia (delivered online or onsite) is designed for beginner-level data professionals aiming to learn how to design, implement, and manage SSIS packages for data integration and transformation tasks.

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

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

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

 14 Hours

This instructor-led program in Latvia is dedicated to the design of advanced SSIS data flows and transformations. Participants will gain mastery over Slowly Changing Dimensions, learn to manage complex data sources, and deploy robust packages to streamline data warehousing and migration workflows.

Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server
SQL
SQL