Delivered either online or on-site, these live, instructor-led Microsoft SQL Server (also referred to as MS SQL Server or simply SQL Server) training programmes utilise hands-on practice to demonstrate the core fundamentals of the platform.
Microsoft SQL Server training is offered as "online live training" or "onsite live training". Online live training (also known as "remote live training") is conducted through an interactive remote desktop connection. Onsite live training can be facilitated locally at your customer premises in Durban or within NobleProg’s corporate training centres in Durban.
NobleProg -- Your Local Training Provider
Garden Court South Beach
Durban, South Africa
Way to get there
From Durban city centre: follow the beachfront/Marine Parade south toward South Beach.
By car/taxi: give the driver the address 73 O.R. Tambo Parade, South Beach, Durban 4001.
From King Shaka International Airport: the hotel is roughly 30 km ;from the airport.
This instructor-led, live training in Durban (online or onsite) is aimed at intermediate-level database administrators who wish to learn the necessary skills and knowledge to effectively manage and administer SQL Server databases using SQL Server Management Studio.
By the end of this training, participants will be able to:
Understand system requirements and perform installations.
Create, configure, and manage databases using SSMS.
Manage logins, users, roles, and permissions.
Perform various types of backups and restore databases.
Create, schedule, and manage jobs using SQL Server Agent.
Implement best practices for efficient and secure SQL Server administration.
The DP-300T00: Administering Microsoft Azure SQL Solutions certification demonstrates an IT professional’s competence in managing and implementing database solutions within the Microsoft Azure cloud environment. It validates expertise in managing Azure SQL Server instances, databases, and the effective use of T-SQL. This certification is essential for industries pursuing digital transformation, as it confirms that the certified individual can efficiently manage data, perform migrations, and optimise performance in Azure environments. Earning the DP-300T00 certification boosts a professional’s credibility, making them a highly sought-after asset in the IT sector, particularly for roles focused on database administration and management.
This live, instructor-led course in Durban focuses on essential SQL Server administration competencies. Learners will gain skills in installing and configuring environments, managing databases, and monitoring performance. It is particularly suitable for IT professionals seeking practical experience in automation and troubleshooting.
This instructor-led, live training in Durban (online or onsite) is aimed at intermediate-level to advanced-level database administrators who wish to deepen their knowledge of SQL Server for efficient database management, performance tuning, high availability, and advanced troubleshooting.
By the end of this training, participants will be able to:
Administer and configure SQL Server instances using best practices.
Optimise the performance of queries and databases.
Implement high availability and disaster recovery strategies.
Diagnose and resolve complex issues in production environments.A
This instructor-led training in Durban 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.
This instructor-led, live training in Durban (online or onsite) is aimed at intermediate-level software developers and automation engineers who wish to build applications that communicate with PLCs and interact with SQL databases using Visual Studio.
By the end of this training, participants will be able to:
Develop .NET applications in Visual Studio for industrial automation.
Communicate with PLCs using industrial protocols such as OPC UA.
Implement database interactions with SQL Server for storing and retrieving PLC data.
Optimize application performance for real-time industrial environments.
This instructor-led, live training in Durban (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.
This advanced SQL course in Durban focuses on stored procedures, triggers, and error management for Microsoft SQL Server. It enables developers to construct complex, production-ready database solutions featuring efficient transaction control and procedural logic tailored for enterprise environments.
This advanced Transact SQL course based in Durban empowers participants to manage complex result sets and enhance database performance. It covers analytical functions, index management, query optimization, and fundamental data warehousing techniques for Microsoft SQL Server.
Gain proficiency in T-SQL fundamentals through this practical course in Durban. Participants will learn to navigate SQL Server Management Studio, construct tables using DDL and DML, and develop complex queries involving joins and subqueries. This course is ideal for beginners aiming to acquire core database competencies and gain hands-on experience with modern relational systems.
In Durban, this programme empowers administrators to manage SQL Server with confidence. Participants will gain proficiency in creating databases, using SQL syntax for data retrieval, and implementing robust security protocols. Additionally, you will explore advanced functionalities including replication, automation, and BI to construct sophisticated, real-world solutions.
This instructor-led course in Durban is tailored for delegates already familiar with SQL Server. It emphasises set-based querying, query optimisation, index management, and execution plan analysis. Participants will gain mastery over table expressions, ranking functions, and partitioned tables.
This course aims to equip participants with a comprehensive grasp of the advanced SQL syntax and capabilities inherent to Microsoft SQL Server. By gaining proficiency in analytical functions, table joins, subqueries, and aggregation methods, learners will discover how to execute data analysis tasks directly within the database layer, rather than relying on MS Excel. This strategy significantly enhances workflow efficiency and underpins the creation of robust IT solutions built on the Microsoft SQL Server platform.
This practical SQL workshop in Durban 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.
This instructor-led course in Durban explores the fundamentals of SQL within Microsoft SQL Server, enabling participants to excel in querying, database design, and normalization. Through practical, hands-on exercises, learners will develop proficient T-SQL skills to optimize data workflows and achieve seamless integration with Excel.
This practical training in Durban 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...
Last Updated:
Testimonials (6)
data was personalised to our organisations
Vincent Long - ASSMANG PTY LTD
Course - T-SQL Fundamentals with SQL Server Training Course
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training was well structured and interactive
kgotla Moncho - Martin Engineering Africa
Course - MS 20761 : Querying Data with Transact SQL
The instructor brought his A game again as he superbly took my staff through the customized training with expert timing, knowledge, support, and rapport with my staff.
James - Shawnee Mission School District
Course - Administering in Microsoft SQL Server
The lecture about cte
Glyssa Mae - Metropolitan Bank and Trust Company
Course - Transact SQL Advanced
Lot of content and exactly the requested one.
Pascal - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Online SQL Server training in Durban, Microsoft SQL Server training courses in Durban, Weekend Microsoft SQL Server courses in Durban, Evening MS SQL Server training in Durban, Microsoft SQL Server instructor-led in Durban, Online Microsoft SQL Server training in Durban, Microsoft SQL Server coaching in Durban, MS SQL Server instructor-led in Durban, Evening MS SQL Server courses in Durban, MS SQL Server instructor in Durban, Microsoft SQL Server on-site in Durban, Microsoft SQL Server trainer in Durban, MS SQL Server classes in Durban, Weekend SQL Server training in Durban, MS SQL Server one on one training in Durban, SQL Server boot camp in Durban, Microsoft SQL Server private courses in Durban
