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

Essential Database Objects

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

Query Performance Tracing

  • Fundamentals of query execution and optimization
  • Interpretation of Execution Plans
  • Management of table and index statistics
  • Application of query hints

Foundational Data Warehousing Techniques

  • Implementation of Indexed Views
  • Use of Dimension and fact tables
  • Adoption 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 Kenya (online or onsite) is tailored 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 able to:

  • Execute advanced querying techniques utilizing unions, subqueries, and complex joins.
  • Precisely add, update, and delete data, tables, views, and indexes.
  • Guarantee data integrity through transactions and manipulate database structures.
  • Efficiently create and manage databases 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 Kenya empowers data engineers to integrate LLMs into SQL environments. Participants will learn to construct natural language pipelines, apply AI-driven optimization, and design secure enterprise workflows to support automated data analysis.

Read more...

SQL DATABASE MANAGEMENT AND DESIGN - Bespoke

 14 Hours
This instructor-led training in Kenya focuses on advanced SQL database management and design. Participants will acquire mastery over query commands, joins, and transaction management, while developing the ability to construct resilient 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 Kenya (online or on-site) 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
This Kenya course offers a deep dive into advanced SQL techniques for analysts, focusing on data extraction, filtering, and sorting. Participants will develop expertise in joins, subqueries, and analytic functions such as RANK and LAG, allowing them to perform sophisticated data analysis within Oracle, SQL Server, or MS Access databases.
Read more...

SQL Basics

 14 Hours
This live-led course in Kenya introduces SQL essentials for beginners, focusing on data extraction, filtering, aggregation, and joining. Through interactive discussions and practical lab sessions, learners will develop the skills to craft effective SQL queries for practical database analysis and reporting.
Read more...

SQL: Basics to Intermediate

 35 Hours

This instructor-led, live training in Kenya (online or onsite) is targeted at beginner to intermediate-level data analysts, database professionals, and software developers 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 For Data Science and Data Analysis

 14 Hours
This live training on Kenya empowers developers and analysts to master SQL for big data applications. Learners will develop the skills to query extensive datasets efficiently using MySQL, Postgres, HiveQL, and Redshift, while gaining insights into data modeling and NoSQL systems to effectively consolidate data into reporting tools.
Read more...

SQL Fundamentals to Advanced Querying

 10 Hours
This guided SQL workshop in Kenya transitions beginners through advanced querying, joins, and aggregation. Gain practical proficiency by manipulating data, generating reports, and optimizing performance using hands-on exercises with real-world datasets, ensuring effective modern database management.
Read more...

SQL Fundamentals

 14 Hours
This instructor-led training in Kenya equips participants with the practical abilities needed to extract and analyse data from any relational database. You will master the art of writing SQL queries, understand database architecture, and navigate different SQL dialects to produce effective reports.
Read more...

SQL Intermediate

 14 Hours
Instructor-led live training in Kenya for intermediate users. Master complex SQL queries, data manipulation, and performance optimization through advanced techniques. Includes hands-on exercises and a live lab to apply skills to real-world scenarios effectively.
Read more...

SQL language in MSSQL

 14 Hours
This hands-on SQL training in Kenya teaches efficient query writing for Microsoft SQL Server. It covers relational models, data retrieval, filtering, and aggregation. Participants master multi-table joins, subqueries, and DML operations to reliably manipulate business intelligence datasets.
Read more...

Business Intelligence with SSAS

 14 Hours
This hands-on training in Kenya delves into SQL Server Analysis Services for advanced Business Intelligence and data modeling. Learners will gain the expertise to design OLAP cubes, utilize MDX queries, and implement robust solutions, acquiring the practical skills needed to enhance data-driven decision-making in modern business environments.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led, live training in Kenya (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 Kenya concentrates on 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 tailored for efficient data warehousing and migration workflows.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server
SQL
SQL