Get in Touch

Course Outline

Analytical Functions

  • Applying advanced summary functions
  • Implementing hierarchical queries
  • Leveraging analytical summary functions, such as moving averages and running totals
  • Utilizing ranking functions

Essential Database Objects

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

Query Performance Tracing

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

Foundational Data Warehousing

  • Implementing Indexed Views
  • Working with Dimension and fact tables
  • Utilizing Star and Snowflake schema designs
 7 Hours

Need help picking the right course?
southafrica@nobleprog.co.za or +27 (0)10 005 5793

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-02 09:30
7 hours
Garden Court South Beach

Transact SQL Advanced

2026-11-16 09:30
7 hours
Sheraton Pretoria Hotel

Transact SQL Advanced

2026-11-30 09:30
7 hours
Pretoria - Brooklyn Bridge

Transact SQL Advanced

2026-12-14 09:30
7 hours
Cape Town - City Lodge Hotel Victoria and Alfred Waterfront

Related Courses

SQL Advanced

 14 Hours

This instructor-led, live training in South Africa (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 South Africa empowers data engineers to seamlessly integrate LLMs into SQL environments. Learners will construct natural language pipelines, apply AI-driven optimization techniques, and design secure enterprise workflows to facilitate automated data analysis.

Read more...

SQL DATABASE MANAGEMENT AND DESIGN - Bespoke

 14 Hours
This instructor-led training in South Africa focuses on advanced SQL database management and design. Learners will gain expertise in query commands, joins, and transaction management, while developing the skills to construct robust schemas using entity relationship modeling and ACID principles to ensure system reliability.
Read more...

Oracle Database 19c Performance Management and Tuning

 28 Hours

This instructor-led live training in South Africa (online or onsite) is designed for intermediate-level database administrators and IT professionals seeking to optimise the performance of Oracle Database 19c.

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

  • Comprehend the concepts of Oracle Database 19c performance tuning.
  • Effectively utilise performance management tools.
  • Optimise database performance through various tuning techniques.
  • Troubleshoot and resolve performance-related issues.
Read more...

SQL Advanced level for Analysts

21 Hours
This South Africa course provides analysts with advanced SQL skills, focusing on data selection, filtering, and sorting techniques. Participants will gain proficiency in executing joins, subqueries, and analytic functions such as RANK and LAG, enabling them to perform intricate data analysis directly within Oracle, SQL Server, or MS Access environments.
Read more...

SQL Basics

 14 Hours
This live, instructor-led program in South Africa introduces SQL basics for novices, covering data retrieval, filtering, aggregation, and joins. Through interactive discussions and practical labs, participants learn to craft effective SQL queries for real-world database reporting and analysis.
Read more...

SQL: Basics to Intermediate

 35 Hours

This instructor-led, live training in South Africa (online or onsite) is targeted at beginner 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 summarise 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 For Data Science and Data Analysis

 14 Hours
This live training in South Africa enables developers and analysts to master SQL for big data environments. Participants gain the skills to efficiently query large datasets using MySQL, Postgres, HiveQL, and Redshift, while exploring data modeling and NoSQL systems to effectively transform data for reporting tools.
Read more...

SQL Fundamentals to Advanced Querying

 10 Hours
This instructor-led SQL training in South Africa assists beginners in progressing 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 facilitated training session on South Africa equips learners with the practical abilities needed to retrieve and analyse data from any relational database. You will develop the ability to construct SQL queries, comprehend database architectures, and apply various SQL dialects to produce insightful reports.
Read more...

SQL Intermediate

 14 Hours
Live, instructor-led training in South Africa for intermediate users. Develop expertise in complex SQL queries, data manipulation, and performance optimization through advanced techniques. The course includes hands-on exercises and a live lab to apply skills to real-world scenarios with effectiveness.
Read more...

SQL language in MSSQL

 14 Hours
This practical SQL workshop in South Africa focuses on crafting optimized queries for Microsoft SQL Server. It explores relational structures, data fetching, filtering mechanisms, and aggregation techniques. Participants will acquire the skills to handle multi-table joins, subqueries, and DML statements, enabling them to manipulate business intelligence data with precision and confidence.
Read more...

Business Intelligence with SSAS

 14 Hours
This practical training in South Africa delves into SQL Server Analysis Services for advanced BI and data modeling. Learners will master the design of OLAP cubes, the application of MDX queries, and the deployment of robust solutions, equipping them with the practical skills necessary to drive data-informed decision-making for contemporary business operations.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led, live training in South Africa (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 South Africa centres on designing advanced SSIS data flows and transformations. Participants will gain mastery over Slowly Changing Dimensions, manage complex data sources, and deploy robust packages to support efficient data warehousing and migration scenarios.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server
SQL
SQL