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

Essential Database Objects

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

Query Performance Analysis

  • Foundations of query execution and optimization
  • Interpretation of Execution Plans
  • Analysis of table and index statistics
  • Application of query hints

Introductory Data Warehousing Methods

  • Application of Indexed Views
  • Implementation of Dimension and fact tables
  • Designing Star and Snowflake schemas

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
Tours, Les Rives Public Garden
1550 EUR (Online)
1750 EUR (Classroom)

Transact SQL Advanced

2026-10-29 09:30
7 hours
Limoges, City Center
1550 EUR (Online)
1750 EUR (Classroom)

Transact SQL Advanced

2026-11-12 09:30
7 hours
Paris, Opera Bourse
1550 EUR (Online)
1750 EUR (Classroom)

Transact SQL Advanced

2026-11-26 09:30
7 hours
Lyon, Swisslife Tower
1550 EUR (Online)
1750 EUR (Classroom)

Transact SQL Advanced

2026-12-10 09:30
7 hours
Lille, Gare Flandres
1550 EUR (Online)
1750 EUR (Classroom)

Transact SQL Advanced

2026-12-24 09:30
7 hours
Toulouse, City Center
1550 EUR (Online)
1750 EUR (Classroom)

Related Courses

Administering in Microsoft SQL Server

 21 Hours
In France, this training equips administrators with the skills to manage SQL Server with precision. Participants will master database creation, SQL syntax for data manipulation, and essential security protocols. The curriculum also delves into advanced features such as replication, automation, and BI to facilitate the development of sophisticated, real-world solutions.
Read more...

SQL Advanced

 14 Hours

This instructor-led, live training in France (online or onsite) is aimed at 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 instructor-led live training in France empowers data engineers to seamlessly 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 training in France focuses on advanced SQL database management and design. Participants will gain proficiency in query commands, joins, and transaction management, while developing robust schemas through entity relationship modeling and the application of ACID properties to ensure system reliability.
Read more...

SQL Advanced level for Analysts

21 Hours
This France course offers a deep dive into advanced SQL techniques for analysts, focusing on efficient data selection, filtering, and sorting. Learners will gain proficiency in joins, subqueries, and analytic functions such as RANK and LAG, enabling them to perform complex data analysis natively within Oracle, SQL Server, or MS Access environments.
Read more...

SQL Basics

 14 Hours
This live instructor-led session in France covers the fundamentals of SQL for beginners, focusing on data retrieval, filtering, aggregation, and joins. Through interactive lectures and practical labs, participants learn to craft effective SQL statements for real-world querying and reporting.
Read more...

SQL: Basics to Intermediate

 35 Hours

This live, instructor-led training in France (online or on-site) targets beginner to intermediate-level data analysts, database professionals, and software developers who aim to learn SQL for effective database management.

By the end of this course, participants will be able to:

  • Comprehend and utilize core SQL commands and queries.
  • Create and modify tables and databases.
  • Sort, filter, and summarize data using SQL.
  • 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 course in France takes learners from beginner concepts to advanced querying, joins, and aggregation. Through hands-on exercises and real datasets, participants 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 program in France empowers learners to develop practical abilities for extracting and analyzing data from any relational database. You will gain the expertise to craft SQL queries, comprehend database architecture, and leverage diverse SQL dialects to produce comprehensive reports.
Read more...

SQL Intermediate

 14 Hours
Facilitated live instruction in France tailored for intermediate learners. Acquire skills in crafting complex SQL queries, managing data manipulation, and optimizing performance via advanced methodologies. The course features practical drills and a live lab to apply these abilities to practical, real-world situations.
Read more...

SQL language in MSSQL

 14 Hours
This practical MSSQL course in France focuses on optimizing SQL query performance for Microsoft SQL Server. It addresses core concepts including relational architectures, data extraction, filtering, and aggregation techniques. Learners will gain command over complex joins, subqueries, and DML procedures to effectively manage business intelligence datasets.
Read more...

Data Analysis with SQL, Python, and Tableau

 14 Hours

This instructor-led, live training in France (online or onsite) is aimed at data scientists and developers who wish to use 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 on France delves into SQL Server Analysis Services for advanced BI and data modeling. Learners will master the design of OLAP cubes, the use of MDX queries, and the deployment of robust solutions, acquiring the essential skills 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 France (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 program on France specializes in the creation of advanced SSIS data flows and transformations. Learners will gain proficiency in implementing Slowly Changing Dimensions, managing complex data sources, and deploying robust packages to streamline data warehousing and migration initiatives.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server
SQL
SQL