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
  • Application of clustered tables
  • Implementation of partitioned tables
  • Leveraging metadata within the master database

Query Performance Tracing

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

Fundamental Data Warehousing Techniques

  • Implementation of Indexed Views
  • Use of Dimension and fact tables
  • Application of 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

Related Courses

SQL Advanced

 14 Hours

This instructor-led, live training in Nigeria (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.

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 interactive, live training in Nigeria empowers data engineers to seamlessly weave Large Language Models (LLMs) into their SQL environments. Attendees will learn to construct natural language pipelines, apply AI-driven optimization techniques, and architect secure, enterprise-grade workflows to automate data analysis.

Read more...

SQL DATABASE MANAGEMENT AND DESIGN - Bespoke

 14 Hours
This instructor-led training in Nigeria delves into advanced SQL database management and design. Participants will acquire expertise in query commands, joins, and transaction management while learning to construct robust schemas utilizing entity-relationship modeling and ACID properties to ensure system reliability.
Read more...

Oracle Database 19c Performance Management and Tuning

 28 Hours

This instructor-led, live training in Nigeria (online or onsite) is aimed at intermediate-level database administrators and IT professionals who wish to optimize the performance of Oracle Database 19c.

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

  • Understand Oracle Database 19c performance tuning concepts.
  • Use performance management tools effectively.
  • Optimize database performance through tuning techniques.
  • Troubleshoot and resolve performance issues.
Read more...

SQL Advanced level for Analysts

21 Hours
In this Nigeria course, you'll explore advanced SQL for analysts, learning how to select, filter, and sort data. You'll get comfortable with joins, subqueries, and analytic functions like RANK and LAG, which let you perform complex data analysis right inside Oracle, SQL Server, or MS Access.
Read more...

SQL Basics

 14 Hours
This instructor-led training in Nigeria introduces SQL fundamentals for beginners, covering data retrieval, filtering, aggregation, and joins. It employs interactive lectures and hands-on labs to assist participants in crafting effective SQL statements for practical database querying and reporting activities.
Read more...

SQL: Basics to Intermediate

 35 Hours

This instructor-led, live training in Nigeria (available online or onsite) is tailored for beginner to intermediate-level data analysts, database specialists, and software developers who wish to learn SQL to manage databases effectively.

Upon completing this training, participants will be able to:

  • Comprehend and apply fundamental SQL commands and queries.
  • Create and manipulate tables and databases.
  • Utilize SQL to sort, filter, and summarize data.
  • Execute complex operations such as joins, subqueries, and set operations.
  • Apply intermediate techniques including indexes, views, stored procedures, and triggers.
Read more...

SQL For Data Science and Data Analysis

 14 Hours
This live training in Nigeria empowers developers and analysts to master SQL for big data applications. Participants will learn to efficiently query large datasets using MySQL, Postgres, HiveQL, and Redshift, while exploring data modeling and NoSQL systems to effectively wrangle data into reporting tools.
Read more...

SQL Fundamentals to Advanced Querying

 10 Hours
This instructor-led SQL training in Nigeria takes beginners from foundational concepts to advanced querying, joins, and aggregation. Through hands-on exercises and real-world datasets, you will develop 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 Nigeria equips participants with the practical abilities needed to retrieve and interpret data from any relational database. You will gain the skills to construct SQL queries, comprehend database architectures, and navigate various SQL dialects to produce effective reports.
Read more...

SQL Intermediate

 14 Hours
Expert-led live training in Nigeria for intermediate users. Develop proficiency in complex SQL queries, data manipulation, and performance tuning through advanced methods. The course features hands-on exercises and a live lab to seamlessly apply skills to practical, real-world situations.
Read more...

SQL language in MSSQL

 14 Hours
This practical SQL training in Nigeria focuses on writing optimized queries for Microsoft SQL Server. It addresses relational models, data extraction, filtering, and aggregation strategies. Learners will gain proficiency in multi-table joins, subqueries, and DML operations to effectively manage business intelligence datasets.
Read more...

Business Intelligence with SSAS

 14 Hours
This practical training on Nigeria delves into SQL Server Analysis Services for advanced BI and data modeling. Participants will master the design of OLAP cubes, the application of MDX queries, and the deployment of robust solutions, acquiring the practical expertise needed to facilitate data-driven decision-making within contemporary business operations.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This live, instructor-led training in Nigeria (online or on-site) targets beginner-level data professionals keen on learning 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 training on Nigeria centers on the design of advanced SSIS data flows and transformations. Learners will gain proficiency in Slowly Changing Dimensions, manage complex data sources, and deploy robust packages to streamline data warehousing and migration workflows.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server
SQL
SQL