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.
Duration 28 hours
Course Outline
Intermediate SQL Server Administration
- Configuring instances and managing services
- Overseeing databases, files, and filegroups
- Automating tasks via SQL Server Agent
SQL Server Security
- Oversight of user accounts, roles, and permission sets
- Comparing Windows and SQL authentication methods
- Implementing auditing protocols and data encryption
Monitoring and Performance Optimization
- Leveraging Activity Monitor and Dynamic Management Views (DMVs)
- Analyzing execution plans and statistics
- Tuning queries and optimizing indexes
Backup and Recovery
- Developing backup strategies (full, differential, and transaction log)
- Executing point-in-time restores and recovering damaged databases
- Streamlining backup plans through automation
Advanced SQL Server Administration
- Ensuring high availability through Clustering, Log Shipping, and Database Mirroring
- Utilizing AlwaysOn Availability Groups
- Implementing Replication (Snapshot, Transactional, and Merge)
Advanced Performance Management
- Diagnosing locks, deadlocks, and blocking issues
- Managing workloads using Resource Governor
- Tuning performance across multi-instance setups
Troubleshooting and Auditing
- Identifying critical issues via logs and system utilities
- Enforcing comprehensive auditing policies
- Employing advanced diagnostic and forensic analysis tools
Summary and Next Steps
Requirements
- Fundamental understanding of SQL Server and core database principles
- Practical experience utilizing SQL Server Management Studio
- Proficiency in basic database administration routines
Target Audience
- Database Administrators (DBAs)
- Data Engineers
- IT professionals overseeing SQL Server environments
Testimonials (4)
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 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
