Mastering SQL Server for Database Administrators
Course Summary
Training level | SQL Server Master Courses |
Duration | 5 days / 40 Hours |
Delivery method | In Class |
Level | 400 |
Language | Bulgarian/English |
List price | 950 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
Reserving a seat does not imply any obligations for payment