Get in Touch

Course Outline

Analytical Functions

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

Essential Database Objects

  • Foundational principles of index utilization
  • Procedures for creating and maintaining indexes
  • Application of clustered tables
  • Implementation of partitioned tables
  • Leveraging metadata within the master database

Query Performance Analysis

  • Core concepts of query execution and optimization
  • Interpretation of Execution Plans
  • Utilization of table and index statistics
  • Application of query hints

Introductory Data Warehouse Methodologies

  • Implementation of Indexed Views
  • Application of Dimension and Fact tables
  • Utilization of Star and Snowflake schema 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-19 09:30
7 hours
Iasi, City Center
248 EUR (Online)
448 EUR (Classroom)

Transact SQL Advanced

2026-11-02 09:30
7 hours
Bucharest, City Center
248 EUR (Online)
448 EUR (Classroom)

Transact SQL Advanced

2026-11-16 09:30
7 hours
ActiveOne Bucharest
248 EUR (Online)
448 EUR (Classroom)

Transact SQL Advanced

2026-11-30 09:30
7 hours
Brasov, Calea Bucuresti Street
248 EUR (Online)
448 EUR (Classroom)

Related Courses

SQL Advanced

 14 Hours

This instructor-led, live training in Romania (online or on-site) 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 live, instructor-led training in Romania provides data engineers with the necessary skills to integrate LLMs into SQL environments. Learners will construct 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 in Romania focuses on advanced SQL database management and design. Participants will master query commands, joins, and transaction management while learning to build robust schemas using entity-relationship modeling and ACID properties for reliable systems.
Read more...

SQL Advanced level for Analysts

21 Hours
This module in Romania equips analysts with advanced SQL skills, focusing on data extraction, filtering, and sorting. Learners will develop expertise in joins, subqueries, and analytic functions such as RANK and LAG, facilitating complex data analysis natively within Oracle, SQL Server, or MS Access environments.
Read more...

SQL Basics

 14 Hours
This guided program in Romania introduces SQL fundamentals for novices, covering key areas such as data extraction, filtering, aggregation, and joining tables. Through interactive instruction and practical lab work, participants gain the ability to craft efficient SQL queries for practical database querying and reporting scenarios.
Read more...

SQL: Basics to Intermediate

 35 Hours

This instructor-led, live training in Romania (available online or onsite) is designed for beginner to intermediate data analysts, database professionals, and software developers who wish to learn SQL for effective database management.

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

  • Comprehend and utilize essential SQL commands and queries.
  • Create and manipulate tables and databases.
  • Employ SQL to sort, filter, and summarize data.
  • Execute more complex operations, including 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 Romania leads beginners through advanced querying, joins, and aggregation. Develop practical competencies through hands-on exercises and real-world datasets, enabling you to manipulate data, generate reports, and optimize performance for robust, modern database administration.
Read more...

SQL Fundamentals

 14 Hours
This instructor-led training in Romania enables participants to develop hands-on capabilities for extracting and analyzing data from any relational database. Learners will master writing SQL queries, comprehend database architecture, and apply various SQL dialects to produce impactful reports.
Read more...

SQL Intermediate

 14 Hours
Live, instructor-led training in Romania tailored for intermediate users. Develop proficiency in complex SQL queries, data handling, and performance tuning via advanced methodologies. The course features practical exercises and a live lab to effectively apply skills to real-world challenges.
Read more...

SQL Intermediate to Advanced

 14 Hours

This instructor-led, live training (available online or onsite) is designed for intermediate to advanced users who want to deepen their SQL knowledge.

Course Format

  • Engaging lectures and interactive discussions.
  • Extensive exercises and hands-on practice.
  • Practical application within a live-lab setting.

Customization Options

  • To arrange customized training for this course, please get in touch with us.
Read more...

SQL language in MSSQL

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

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

  • Establish the necessary environment to perform data analysis using SQL, Python, and Tableau.
  • Comprehend core software integration concepts such as data, servers, clients, APIs, and endpoints.
  • Refresh their knowledge of Python and SQL fundamentals.
  • Execute data pre-processing techniques in Python.
  • Learn how to link Python and SQL for data analysis purposes.
  • Create meaningful data visualizations and charts with Tableau.
Read more...

Business Intelligence with SSAS

 14 Hours
This practical training on Romania delves into SQL Server Analysis Services for advanced Business Intelligence and data modeling. Learners will acquire the skills to design OLAP cubes, utilize MDX queries, and deploy robust solutions, thereby gaining the practical capabilities necessary to drive data-informed decision-making within modern business operations.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led, live training conducted Romania (online or on-site) is tailored for beginner-level data professionals eager to learn how to design, implement, and manage SSIS packages to execute data integration and transformation tasks.

By the conclusion 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 session in Romania emphasizes the design of sophisticated SSIS data flows and transformations. Learners will gain proficiency in implementing Slowly Changing Dimensions, managing intricate data sources, and deploying high-performance packages for streamlined data warehousing and migration initiatives.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server
SQL
SQL