Mastering SQL Server for Database Administrators

Course Summary

Training levelSQL Server Master Courses
Duration5 days / 40 Hours
Delivery methodIn Class
List price950 Euro VAT Excl.

Click Tabs for Detailed info

The courses of SQL Server Mastering series consist intensive and modules which are comparatively complicated regarding the technical level and which are designed and intended for professionals in the field of SQL Server.  Trainings include solid theoretical material, part of which comes directly from the programme team, who develops SQL Server in Microsoft, numerous demonstrations from the “workshop” of SQL Server, unpublished tuning techniques for increase of SQL Server performance.

  • Professionals in DBA role who manage multiple instances and are responsible for their maintenance
  • DB Administrators who work in other platforms
  • Maintain multiple SQL Server instances and complex SQL Server solutions
  • Use advanced tools to implement auditing, resource control and encryption
  • Find and isolate problems and optimize SQL Server performance
  • Understand in details architecture and the way SQL Server components work, which allow attendance to find the root cause of problems and more – to avoid them before they happen
  • Configure SQL Server at all levels in order to achieve the maximum performance
  • Understand in details how SQL Server processes work
  • Understand and know the data and index structure internals
  • Choose and work with proper tools for the job
  • Isolate and find problems that could reduce availability and do proactive steps to avoid them
  • Use advanced tools for monitoring and troubleshooting – xEvents, Event Notifications, DMVs
  • Work and tune the Policy Based Management, Resource Governor, Auditing
  • Find and isolate security subsystem problems, understand why they occur
  • Operate replication solutions and HA environments

Module 1: SQL Server Architecture, SQLOS, Resource Management and Configurations

Module 2: SQL Server Data and Index Structures Internals, Partitioning and Data Compression

Module 3: SQL Server Logging and Transaction Log Internals, TempDB

Module 4: Advanced Database Maintenance

Module 5: Advanced Backup and Recovery techniques

Module 6: Monitoring and Troubleshooting

Module 7: Solutions for Managing SQL Server Workloads – SQL Server Auditing, PBM, RGov

Module 8: Security Subsystem and Security Management

Module 9: MultiServer Administration, PowerShell

Module 10: Transactional Replication Overview

Next planned dates:

Trainer: Rozalina Zaharieva


Reserve your seat

Subscribe me to your mailing list

Reserving a seat does not imply any obligations for payment

Next training starts in:
Stay tuned for the next training date