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
  • Application of ranking functions

Essential Database Objects

  • Core principles of index utilization
  • Creating and maintaining indexes
  • Implementing clustered tables
  • Implementing partitioned tables
  • Utilizing metadata within the master database

Query Performance Monitoring

  • Fundamentals of query execution and optimization
  • Utilizing Execution Plans
  • Leveraging table and index statistics
  • Applying hints

Foundational Data Warehouse Techniques

  • Implementing Indexed Views
  • Working with Dimension and fact tables
  • Applying 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-19 09:30
7 hours
Business Center Plovdiv
270 EUR (Online)
1120 EUR (Classroom)

Transact SQL Advanced

2026-12-03 09:30
7 hours
Crystal Business Center
270 EUR (Online)
470 EUR (Classroom)

Transact SQL Advanced

2026-12-17 09:30
7 hours
Central Point Varna
270 EUR (Online)
470 EUR (Classroom)

Transact SQL Advanced

2026-12-31 09:30
7 hours
Business Center Plovdiv
270 EUR (Online)
1120 EUR (Classroom)

Transact SQL Advanced

2027-01-14 09:30
7 hours
Crystal Business Center
270 EUR (Online)
470 EUR (Classroom)

Related Courses

Administering in Microsoft SQL Server

 21 Hours
In Bulgaria, this course equips administrators with the proficiency needed to manage SQL Server with confidence. Participants will gain mastery over database creation, leveraging SQL syntax for efficient data retrieval, and implementing robust security protocols. Furthermore, the curriculum delves into advanced capabilities such as replication, automation, and Business Intelligence, enabling the construction of complex, real-world solutions.
Read more...

SQL Advanced

 14 Hours

This instructor-led, live training in Bulgaria (available online or onsite) is designed for intermediate-level database administrators, developers, and analysts who want 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 in Bulgaria empowers data engineers to seamlessly integrate LLMs into their SQL environments. Participants will develop natural language pipelines, apply AI-driven optimization techniques, and design secure enterprise workflows for automated data analysis.

Read more...

SQL DATABASE MANAGEMENT AND DESIGN - Bespoke

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

SQL Advanced level for Analysts

21 Hours
This Bulgaria course equips analysts with advanced SQL skills, covering data selection, filtering, and sorting. Learners will gain proficiency in joins, subqueries, and analytic functions such as RANK and LAG, enabling them to perform sophisticated data analysis directly within Oracle, SQL Server, or MS Access databases.
Read more...

SQL Basics

 14 Hours
This instructor-guided session on Bulgaria introduces SQL essentials for newcomers, covering data extraction, filtering, aggregation, and joining techniques. Through interactive instruction and practical labs, participants gain the skills to craft efficient SQL queries for real-world database analysis and reporting.
Read more...

SQL: Basics to Intermediate

 35 Hours

This instructor-led, live training in Bulgaria (online or onsite) is designed for beginner to intermediate-level data analysts, database professionals, and software developers aiming to master SQL for effective database management.

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

  • Understand and utilize core SQL commands and queries.
  • Create and manipulate tables and databases.
  • Employ SQL to sort, filter, and summarize data.
  • Execute complex operations such as joins, subqueries, and set operations.
  • Apply intermediate techniques including indexes, views, stored procedures, and triggers.
Read more...

SQL Fundamentals to Advanced Querying

 10 Hours
This instructor-led SQL training in Bulgaria takes beginners on a journey to advanced querying, joins, and aggregation. Develop practical skills through hands-on exercises and real datasets to manipulate data, generate reports, and optimize performance for effective, modern database management.
Read more...

SQL Fundamentals

 14 Hours
This instructor-led session on Bulgaria enables learners to develop hands-on proficiency in retrieving and analyzing data from any relational database. You will master the composition of SQL queries, comprehend database architecture, and utilize various SQL dialects to generate effective reports.
Read more...

SQL Intermediate

 14 Hours
Guided live instruction in Bulgaria tailored for intermediate practitioners. Develop proficiency in complex SQL queries, data alteration, and speed optimization through advanced methodologies. The program features practical tasks and a live lab environment to apply competencies to practical business situations.
Read more...

SQL language in MSSQL

 14 Hours
This practical SQL course in Bulgaria focuses on crafting efficient queries for Microsoft SQL Server. It addresses relational models, data extraction, filtering, and aggregation strategies. Students gain proficiency in multi-table joins, subqueries, and DML commands to confidently manage business intelligence data.
Read more...

Data Analysis with SQL, Python, and Tableau

 14 Hours

This instructor-led live training, located in Bulgaria (offered online or onsite), targets data scientists and developers who wish 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:

  • Set up the required environment to perform data analysis with SQL, Python, and Tableau.
  • Understand the key concepts of software integration (data, servers, clients, APIs, endpoints, etc.).
  • Receive 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 training in Bulgaria delves into SQL Server Analysis Services for sophisticated BI and data modeling. Learners will acquire the skills to architect OLAP cubes, utilize MDX queries, and implement robust solutions, thereby gaining the practical capabilities necessary to facilitate data-driven decision-making for contemporary business operations.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led, live training in Bulgaria (online or onsite) is aimed at 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 training in Bulgaria emphasizes the design of advanced SSIS data flows and transformations. Participants will gain mastery over Slowly Changing Dimensions, manage complex data sources, and deploy resilient packages to support efficient data warehousing and migration scenarios.

Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server
SQL
SQL