Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Intermediate SQL Server Administration
- Instance configuration and service management
- Managing databases, files, and filegroups
- Task automation with SQL Server Agent
SQL Server Security
- Managing user accounts, roles, and permissions
- Windows vs SQL authentication
- Auditing and data encryption
Monitoring and Performance Optimization
- Using Activity Monitor and Dynamic Management Views (DMVs)
- Execution plans and statistics
- Query optimization and index tuning
Backup and Recovery
- Backup strategies (full, differential, transaction log)
- Point-in-time restores and damaged database recovery
- Automating backup plans
Advanced SQL Server Administration
- High availability: Clustering, Log Shipping, Database Mirroring
- AlwaysOn Availability Groups
- Replication implementation (Snapshot, Transactional, Merge)
Advanced Performance Management
- Locks, deadlocks, and blocking diagnosis
- Resource Governor and workload control
- Performance tuning in multi-instance environments
Troubleshooting and Auditing
- Detecting critical issues using logs and system tools
- Implementing auditing policies
- Advanced diagnostics and forensic analysis tools
Summary and Next Steps
Requirements
- Basic knowledge of SQL Server and database concepts
- Experience using SQL Server Management Studio
- Familiarity with basic database administration tasks
Audience
- Database Administrators (DBAs)
- Data Engineers
- IT professionals responsible for SQL Server environments
28 Hours
Testimonials (5)
The training was well structured and interactive
kgotla Moncho - Martin Engineering Africa
Course - MS 20761 : Querying Data with Transact SQL
Being human and talking to us as understandable possible
Sorin
Course - Database Administration Fundamentals for MS SQL Server
It allowed us to have an applied hands on sproc to our company database.
Corneliu Buculei - Standard Building Supplies Ltd
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
the in depth knowledge and customize approach
Julius Mapili - SYKES Asia, Inc.
Course - Administering in Microsoft SQL Server
The thorough / hands-on knowledge the trainer has.
