Get in Touch

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

Useful Database Objects

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

Query Performance Tracing

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

Basic Data Warehouse Techniques

  • 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-15 09:30
7 hours
Athens
304 EUR (Online)
504 EUR (Classroom)

Transact SQL Advanced

2026-10-29 09:30
7 hours
Kaminia
304 EUR (Online)
504 EUR (Classroom)

Transact SQL Advanced

2026-11-12 09:30
7 hours
Thessaloniki
304 EUR (Online)
304 EUR (Classroom)

Transact SQL Advanced

2026-11-26 09:30
7 hours
Nicosia
304 EUR (Online)
304 EUR (Classroom)

Transact SQL Advanced

2026-12-10 09:30
7 hours
Nicosia
304 EUR (Online)
504 EUR (Classroom)

Related Courses

Administering in Microsoft SQL Server

 21 Hours
In Greece, this program equips administrators to effectively manage SQL Server. Participants will master database creation, SQL syntax for data retrieval, and essential security protocols. Additionally, you will explore advanced features like replication, automation, and BI to construct complex, real-world solutions.
Read more...

SQL Advanced

 14 Hours

This instructor-led, live training in Greece (online or onsite) is designed for database administrators, developers, and analysts at an intermediate level 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 in Greece empowers data engineers with the expertise to integrate LLMs into SQL environments. Learners 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 program in Greece focuses on advanced SQL database administration and design. Learners will gain proficiency in executing complex queries, managing joins, and overseeing transactions. The course guides participants in constructing robust schemas through entity-relationship modeling and ACID property implementation to ensure system reliability.
Read more...

SQL Advanced level for Analysts

21 Hours
This course within the Greece category delivers advanced SQL training for analysts, focusing on data selection, filtering, and sorting techniques. Participants will gain proficiency in complex data analysis by mastering joins, subqueries, and analytic functions such as RANK and LAG, all executed directly within Oracle, SQL Server, or MS Access databases.
Read more...

SQL Basics

 14 Hours
This instructor-led session on Greece introduces the essentials of SQL for beginners, covering data retrieval, filtering, aggregation, and joins. Through interactive lectures and practical labs, participants learn to craft effective SQL queries to handle real-world database exploration and reporting.
Read more...

SQL: Basics to Intermediate

 35 Hours

This instructor-led, live training in Greece (online or onsite) is tailored for beginner to intermediate data analysts, database professionals, and software developers who aim to master SQL for effective database management.

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 live instructor-led SQL training in Greece supports beginners in progressing to advanced querying, joins, and aggregation. Through hands-on exercises with real datasets, participants will build practical skills to manipulate data, generate reports, and optimize performance for effective, modern database management.
Read more...

SQL Fundamentals

 14 Hours
This instructor-led session on Greece empowers participants with the hands-on capabilities needed to extract and analyse data from any relational database. The curriculum covers writing SQL queries, comprehending database architecture, and navigating different SQL dialects to produce impactful reports.
Read more...

SQL Intermediate

 14 Hours
Instructor-led live training in Greece tailored for intermediate users. Develop expertise in complex SQL queries, data manipulation, and performance optimization through advanced techniques. The program features hands-on exercises and a live lab to help you effectively apply your skills to real-world business scenarios.
Read more...

SQL language in MSSQL

 14 Hours
This practical SQL training in Greece focuses on writing efficient queries for Microsoft SQL Server. It addresses relational models, data retrieval, filtering, and aggregation techniques. Learners 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 Greece (online or onsite) targets data scientists and developers who wish to leverage and integrate SQL, Python, and Tableau for advanced data analysis, processing, and visualization.

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

  • Set up the necessary environment to perform data analysis with SQL, Python, and Tableau.
  • Understand the key concepts of software integration (data, servers, clients, APIs, endpoints, etc.).
  • Get 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 hands-on training in Greece 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, ultimately empowering data-driven decision-making for modern business operations.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led, live training in Greece (online or onsite) is designed for beginner-level data professionals seeking 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 session on Greece is dedicated to mastering the design of advanced SSIS data flows and transformations. Participants will gain expertise in implementing Slowly Changing Dimensions, managing complex data sources, and deploying robust packages tailored for high-efficiency data warehousing and migration projects.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server
SQL
SQL