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

Essential Database Objects

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

Query Performance Tracing

  • Foundations of query execution and optimization
  • Utilization of Execution Plans
  • Application of table and index statistics
  • Use of query hints

Foundational Data Warehouse Techniques

  • Implementation of Indexed Views
  • Application of Dimension and fact tables
  • Use 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-06 09:30
7 hours
Milan
1050 EUR (Online)
1250 EUR (Classroom)

Transact SQL Advanced

2026-10-20 09:30
7 hours
Naples
1050 EUR (Online)
1250 EUR (Classroom)

Transact SQL Advanced

2026-11-03 09:30
7 hours
Turin
1050 EUR (Online)
1250 EUR (Classroom)

Transact SQL Advanced

2026-11-17 09:30
7 hours
Genoa
1050 EUR (Online)
1250 EUR (Classroom)

Transact SQL Advanced

2026-12-01 09:30
7 hours
Bologna
1050 EUR (Online)
1250 EUR (Classroom)

Related Courses

Administering in Microsoft SQL Server

 21 Hours
In Italy, this training equips administrators with the skills to manage SQL Server with confidence. Participants will master database creation, apply SQL syntax for data retrieval, and implement security best practices. Additionally, you will explore advanced features such as replication, automation, and BI to construct complex, real-world solutions.
Read more...

SQL Advanced

 14 Hours

This instructor-led, live training in Italy (online or onsite) is designed for intermediate-level database administrators, developers, and analysts who wish to master advanced SQL functionalities for complex data operations and database management.

Upon completing this training, participants will be capable of:

  • Executing advanced querying techniques utilizing unions, subqueries, and complex joins.
  • Accurately adding, updating, and deleting data, tables, views, and indexes.
  • Maintaining data integrity via transactions and manipulating database structures.
  • Creating and managing databases efficiently to ensure 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 Italy empowers data engineers to seamlessly integrate LLMs into their SQL ecosystems. Participants will develop natural language pipelines, apply AI-driven optimization techniques, and design secure enterprise workflows to automate data analysis.

Read more...

SQL DATABASE MANAGEMENT AND DESIGN - Bespoke

 14 Hours
This instructor-led training in Italy delves into advanced SQL database management and design. Learners will gain mastery over query commands, join operations, and transaction handling, while acquiring the skills to construct robust schemas through entity-relationship modeling and ACID property enforcement for system reliability.
Read more...

SQL Advanced level for Analysts

21 Hours
This course in Italy focuses on advanced SQL capabilities for analysts, covering core topics such as data extraction, filtering, and sorting. Participants will gain proficiency in executing joins, subqueries, and utilizing analytic functions like RANK and LAG. These skills enable the execution of sophisticated data analysis tasks directly within Oracle, SQL Server, or MS Access databases.
Read more...

SQL Basics

 14 Hours
This instructor-led Italy session provides a foundational overview of SQL for beginners. It covers key concepts such as data retrieval, filtering, aggregation, and joins. Through interactive lectures and hands-on lab work, participants will learn to craft effective SQL statements for practical database querying and reporting scenarios.
Read more...

SQL: Basics to Intermediate

 35 Hours

This instructor-led, live training in Italy (online or onsite) targets data analysts, database professionals, and software developers from beginner to intermediate levels who wish to learn 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 instructor-led SQL course in Italy leads learners from fundamental concepts to advanced querying, joins, and aggregation. Participants develop practical competencies through hands-on exercises and real-world datasets, enabling them to manipulate data, generate reports, and enhance performance for modern database management.
Read more...

SQL Fundamentals

 14 Hours
This instructor-led session on Italy equips attendees with the practical competencies needed to retrieve and examine data from any relational database. You will master the art of writing SQL queries, comprehend database architecture, and navigate various SQL dialects to produce efficient reports.
Read more...

SQL Intermediate

 14 Hours
Professional live instruction in Italy designed for mid-level practitioners. Gain proficiency in complex query formulation, data management, and performance tuning via advanced methodologies. The curriculum incorporates 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 Italy focuses on crafting efficient queries for Microsoft SQL Server. It encompasses relational models, data retrieval, filtering, and aggregation techniques. Learners will develop proficiency in multi-table joins, subqueries, and DML operations to confidently manage business intelligence datasets.
Read more...

Data Analysis with SQL, Python, and Tableau

 14 Hours

This instructor-led live training in Italy (available online or on-site) is designed for data scientists and developers who wish to utilize and integrate SQL, Python, and Tableau to perform complex data analysis, processing, and visualization.

By the end 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 practical training in Italy delves into SQL Server Analysis Services for advanced BI and data modeling. Participants will master the design of OLAP cubes, utilize MDX queries, and deploy robust solutions, acquiring the practical skills needed to drive data-driven decision-making in modern business operations.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led, live training in Italy (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 Italy specializes in the design of advanced SSIS data flows and transformations. Participants will gain mastery over Slowly Changing Dimensions, manage complex data sources, and deploy robust packages to facilitate efficient data warehousing and migration strategies.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server
SQL
SQL