Get in Touch
 Duration 7 hours

Course Outline

Analytical Functions

  • Application of advanced aggregate functions
  • Implementation of hierarchical queries
  • Utilization of analytical aggregate functions, such as moving averages and running totals
  • Application of ranking functions

Useful Database Objects

  • Fundamental concepts of utilizing indexes
  • Procedures for creating and maintaining indexes
  • Application of clustered tables
  • Implementation of partitioned tables
  • Leveraging metadata within the master database

Query Performance Tracing

  • Core principles of query execution and optimization
  • Interpretation of Execution Plans
  • Application of table and index statistics
  • Utilization of query hints

Basic Data Warehouse Techniques

  • Application of Indexed Views
  • Utilization of Dimension and fact tables
  • Implementation of Star and Snowflake schema designs

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 Botswana (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.

Upon completion of this training, participants will be capable of:

  • Executing advanced querying techniques using unions, subqueries, and complex joins.
  • Precisely adding, updating, and deleting data, tables, views, and indexes.
  • Ensuring data integrity through transactions and manipulating database structures.
  • Efficiently creating and managing databases 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 Botswana empowers data engineers with the expertise to embed LLMs into SQL environments. Participants will develop natural language pipelines, execute AI-driven optimization, and design secure enterprise workflows for automated data analysis.

Read more...

SQL DATABASE MANAGEMENT AND DESIGN - Bespoke

 14 Hours
This instructor-led training on Botswana delves into advanced SQL database management and design. Attendees will gain mastery over query commands, joins, and transaction management, while developing robust schemas through 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 Botswana (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 Botswana course focuses on advanced SQL techniques for analysts, covering data retrieval, filtering, and sorting. Participants will gain proficiency in joins, subqueries, and analytic functions such as RANK and LAG, allowing for sophisticated data analysis directly within Oracle, SQL Server, or MS Access environments.
Read more...

SQL Basics

 14 Hours
This hands-on introductory course for Botswana focuses on core SQL concepts, covering data extraction, refinement, summarization, and table connections. Through engaging discussions and practical laboratory sessions, it assists participants in crafting precise SQL commands for practical database retrieval and reporting activities.
Read more...

SQL: Basics to Intermediate

 35 Hours

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

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

  • Comprehend and utilize core SQL commands and queries.
  • Create and modify tables and databases.
  • Employ 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 Botswana enables developers and analysts to master SQL for big data applications. Participants gain the skills to query large datasets efficiently using MySQL, Postgres, HiveQL, and Redshift, while exploring data modeling and NoSQL systems to effectively process data for reporting tools.
Read more...

SQL Fundamentals to Advanced Querying

 10 Hours
This instructor-led SQL training in Botswana guides beginners through advanced querying, joins, and aggregation. Build practical skills with hands-on exercises and real datasets to manipulate data, create reports, and optimize performance for effective, modern database management.
Read more...

SQL Fundamentals

 14 Hours
This instructor-led training in Botswana equips participants with practical abilities to extract and analyse data from any relational database. Learners will gain the competence to write SQL queries, comprehend database architecture, and navigate various SQL dialects to produce effective reports.
Read more...

SQL Intermediate

 14 Hours
Professional live instruction in Botswana tailored for intermediate-level users. Gain proficiency in intricate SQL queries, data management, and efficiency enhancement via sophisticated methods. The curriculum features practical drills and a live laboratory to apply competencies to practical, real-world situations effectively.
Read more...

SQL language in MSSQL

 14 Hours
This practical SQL course within Botswana focuses on crafting optimized queries for Microsoft SQL Server. It delves into relational data models, data retrieval, filtering, and aggregation techniques. Learners will gain proficiency in multi-table joins, subqueries, and DML operations to ensure reliable management of business intelligence datasets.
Read more...

Business Intelligence with SSAS

 14 Hours
This hands-on training in Botswana delves into SQL Server Analysis Services for advanced BI and data modeling. Participants will gain proficiency in designing OLAP cubes, leveraging MDX queries, and deploying robust solutions, acquiring the practical skills necessary to drive data-informed decision-making for modern business operations.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led, live training in Botswana (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 session in Botswana emphasizes the creation of advanced SSIS data flows and transformations. Learners will gain mastery over Slowly Changing Dimensions, navigate complex data sources, and deploy robust packages to streamline data warehousing and migration processes.

Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server
SQL
SQL