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 utilization
  • Methods for creating and maintaining indexes
  • Utilization of clustered tables
  • Utilization of partitioned tables
  • Use of metadata within the master database

Query Performance Tracing

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

Foundational Data Warehouse Techniques

  • Application of Indexed Views
  • Utilization of Dimension and fact tables
  • Application of Star and Snowflake design patterns
 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-30 09:30
7 hours
Oslo
1500 EUR (Online)
1700 EUR (Classroom)

Transact SQL Advanced

2026-11-13 09:30
7 hours
Oslo
1500 EUR (Online)
1700 EUR (Classroom)

Transact SQL Advanced

2026-11-27 09:30
7 hours
Oslo
1500 EUR (Online)
1700 EUR (Classroom)

Transact SQL Advanced

2026-12-11 09:30
7 hours
Oslo
1500 EUR (Online)
1700 EUR (Classroom)

Related Courses

Administering in Microsoft SQL Server

 21 Hours
In Norway, this training equips administrators with the expertise to manage SQL Server effectively. Participants will master database creation, apply SQL syntax for efficient data retrieval, and enforce critical security protocols. Additionally, you will delve into advanced features like replication, automation, and BI to construct sophisticated, real-world solutions.
Read more...

SQL Advanced

 14 Hours

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

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

  • Execute 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 Norway empowers data engineers to seamlessly integrate LLMs into SQL environments. Learners will develop natural language pipelines, execute AI-driven optimizations, and design secure enterprise workflows for automated data analysis.

Read more...

SQL DATABASE MANAGEMENT AND DESIGN - Bespoke

 14 Hours
This instructor-led training in Norway focuses on advanced SQL database management and design. Learners will gain proficiency in query commands, joins, and transaction management while mastering the creation of robust schemas through entity relationship modeling and ACID properties to ensure system reliability.
Read more...

SQL Advanced level for Analysts

21 Hours
This Norway course delivers advanced SQL skills for analysts, focusing on data selection, filtering, and sorting. Participants will gain proficiency in joins, subqueries, and analytic functions such as RANK and LAG, enabling sophisticated data analysis directly within Oracle, SQL Server, or MS Access environments.
Read more...

SQL Basics

 14 Hours
This guided training in Norway provides an introductory SQL experience for beginners, focusing on data extraction, filtering, aggregation, and joins. Through interactive instruction and practical lab work, participants learn to craft effective SQL queries for real-world database analysis and reporting.
Read more...

SQL: Basics to Intermediate

 35 Hours

This instructor-led, live training in Norway (online or onsite) is aimed at beginner-level to intermediate-level data analysts, database professionals, and software developers who wish to learn SQL to manage databases effectively.

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 SQL training in Norway walks beginners through advanced querying, joins, and aggregation. Develop practical competencies via hands-on exercises and real-world datasets to manipulate data, generate reports, and optimize performance for effective, contemporary database administration.
Read more...

SQL Fundamentals

 14 Hours
This instructor-led Norway training helps learners develop practical capabilities for retrieving and analysing data from any relational database. You will master writing SQL queries, comprehending database architecture, and utilising various SQL dialects to produce effective reports.
Read more...

SQL Intermediate

 14 Hours
Instructor-led live training in Norway tailored for intermediate users. Develop expertise in complex SQL queries, data manipulation, and performance optimization through advanced methodologies. The course includes hands-on exercises and a live lab to effectively apply skills to real-world scenarios.
Read more...

SQL language in MSSQL

 14 Hours
This hands-on course in Norway equips learners with the skills to write efficient queries for Microsoft SQL Server. It covers core concepts such as relational models, data retrieval, filtering, and aggregation. Participants will gain proficiency in executing multi-table joins, constructing subqueries, and performing DML operations to ensure the reliable manipulation of business intelligence datasets.
Read more...

Data Analysis with SQL, Python, and Tableau

 14 Hours

This instructor-led, live training Norway (online or onsite) is intended for data scientists and developers who aim to utilize and integrate SQL, Python, and Tableau to execute complex data analysis, processing, and visualization.

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

  • Set up the required environment for data analysis with SQL, Python, and Tableau.
  • Grasp key concepts of software integration (data, servers, clients, APIs, endpoints, etc.).
  • Refresh their knowledge of Python and SQL fundamentals.
  • Execute 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 immersive training on Norway delves into SQL Server Analysis Services, focusing on advanced BI and data modeling. Learners will master the design of OLAP cubes, utilize MDX queries, and deploy robust solutions, acquiring the practical expertise needed to drive data-informed decision-making in modern business environments.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led live training in Norway (online or onsite) is tailored for 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 Norway concentrates on the design of sophisticated SSIS data flows and transformations. Learners will gain proficiency in implementing Slowly Changing Dimensions, navigating complex data sources, and deploying sturdy packages to support high-efficiency data warehousing and migration workflows.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server
SQL
SQL