Training on Database Management using Microsoft SQL Server
Master SQL Server administration, T-SQL, and performance tuning for professional database management.
Next intake
20 Jul 2026 · Nakuru
Duration
5 days
Live instruction
Delivery
Physical + Virtual
Cohort based
Level
Intermediate
Working professionals
Certification
NITA reimbursable
For Kenyan cohorts
Language
English
All materials
About this programme
Microsoft SQL Server is one of the most widely used relational database management systems, supporting enterprise applications, business operations, and data analytics. This course equips participants with practical skills to design, manage, secure, and optimize SQL Server databases for efficient and reliable performance.
Participants will learn database creation and administration, SQL querying, backup and recovery, performance tuning, and security management through hands on exercises and real world scenarios. The course also explores high availability features and best practices for maintaining secure and scalable database environments.
Duration
5 Days
Who Should Attend
-
Database administrators (DBAs) and IT professionals
-
Data analysts and developers working with SQL Server
-
System administrators managing business applications
-
Software engineers integrating SQL databases into solutions
-
Professionals seeking to strengthen SQL database management skills
What you'll walk away with
By the end of this course, participants will be able to:
-
Understand SQL Server architecture and core components.
-
Create, manage, and query relational databases using T-SQL.
-
Implement database security, user management, and permissions.
-
Perform backups, restores, and recovery processes.
-
Monitor performance and apply tuning techniques.
-
Configure high availability and disaster recovery solutions.
What we cover, module by module
Module 1: Introduction to SQL Server and Databases
-
SQL Server architecture and editions
-
Database design concepts and data modeling
-
Creating and managing databases in SQL Server
-
Case study: Setting up a customer database for a retail business
Module 2: Querying and Managing Data with T-SQL
-
Writing SELECT queries, filtering, and sorting data
-
Joins, subqueries, and set operations
-
Creating views, stored procedures, and functions
-
Case study: Building reports using T-SQL queries for sales analysis
Module 3: Database Administration and Security
-
User roles, authentication, and permissions
-
Securing databases with encryption and auditing
-
Managing schemas and objects
-
Case study: Implementing role-based access in a financial database
Module 4: Backup, Recovery, and Performance Tuning
-
Backup strategies and restore operations
-
Indexing, query optimization, and execution plans
-
Monitoring performance with SQL Server tools
-
Case study: Optimizing a slow-running database query
Module 5: High Availability and Advanced Features
-
Configuring replication, clustering, and Always On availability groups
-
Database mirroring and log shipping
-
Integration with BI and reporting tools
-
Case study: Designing a high-availability database for an e-commerce platform
Where the change lands
Organisation Impact
-
Improved data management and reliability through optimized SQL Server practices
-
Reduced downtime with effective backup, recovery, and disaster recovery strategies
-
Enhanced security and compliance through strong database governance
-
Increased efficiency in application performance with database tuning
-
Stronger business intelligence capabilities through well-structured data systems
Individual Impact
-
Practical skills to manage SQL Server databases confidently
-
Career advancement opportunities in database administration and IT infrastructure
-
Improved efficiency in managing queries, reports, and applications
-
Ability to design secure and scalable databases for real-world use
-
Confidence in troubleshooting and resolving database issues
Dates and locations
Upcoming intakes
Every intake is limited to a small cohort. Booking closes when a date fills or three weeks before the start, whichever comes first.
| City | Starts | Ends | Delivery | Book |
|---|---|---|---|---|
NakuruNext | 20 Jul 2026 | 24 Jul 2026 | In-Person | Book |
Kigali | 20 Jul 2026 | 24 Jul 2026 | In-Person | Book |
Accra | 20 Jul 2026 | 24 Jul 2026 | In-Person | Book |
Kisumu | 27 Jul 2026 | 31 Jul 2026 | In-Person | Book |
Johannesburg | 27 Jul 2026 | 31 Jul 2026 | In-Person | Book |
Dakar | 27 Jul 2026 | 31 Jul 2026 | In-Person | Book |
- NakuruNext
20 Jul → 24 Jul·In-Person
Book this intake - Kigali
20 Jul → 24 Jul·In-Person
Book this intake - Accra
20 Jul → 24 Jul·In-Person
Book this intake - Kisumu
27 Jul → 31 Jul·In-Person
Book this intake - Johannesburg
27 Jul → 31 Jul·In-Person
Book this intake - Dakar
27 Jul → 31 Jul·In-Person
Book this intake
Common questions.
Still not sure? Send us a note and a facilitator will get back to you within a business day.
You may also like.
Programmes in the same discipline that participants often pair with this course.
Hybrid5 daysTraining for SACCO ICT Managers: Master strategic planning, cybersecurity, and digital transformation to protect your institution and drive growth.
Hybrid5 daysLearn AI automation, RPA, workflow design, and chatbot integration to streamline operations, reduce costs, and drive digital transformation.
Hybrid5 daysLearn AI-driven financial automation with ChatGPT to enhance analysis, forecasting, and workflow efficiency.
Course finder
Find the right course for you
Prefer to talk it through? Send us an enquiry and a facilitator will scope a fit within a business day.
For corporate teams
Training 10+ professionals?
We deliver Training on Database Management using Microsoft SQL Server in-house at your offices, at a venue we arrange, or fully virtual. Customise the curriculum against your KPIs, and get a bespoke price for the cohort size you need.