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
- Handling databases, files, and filegroups
- Automating tasks via SQL Server Agent
SQL Server Security
- Oversight of user accounts, roles, and permissions
- Distinguishing between Windows and SQL authentication
- Auditing processes and data encryption
Monitoring and Performance Optimization
- Utilizing Activity Monitor and Dynamic Management Views (DMVs)
- Analyzing execution plans and statistics
- Refining query optimization and index tuning
Backup and Recovery
- Implementing backup strategies (full, differential, transaction log)
- Executing point-in-time restores and recovering damaged databases
- Streamlining backup schedules through automation
Advanced SQL Server Administration
- Achieving high availability through Clustering, Log Shipping, and Database Mirroring
- Leveraging AlwaysOn Availability Groups
- Deploying Replication (Snapshot, Transactional, Merge)
Advanced Performance Management
- Diagnosing locks, deadlocks, and blocking issues
- Managing workloads with Resource Governor
- Tuning performance across multi-instance environments
Troubleshooting and Auditing
- Identifying critical problems using logs and system utilities
- Establishing comprehensive auditing policies
- Applying advanced diagnostics and forensic analysis tools
Summary and Next Steps
Requirements
- Foundational understanding of SQL Server and core database concepts
- Practical experience utilizing SQL Server Management Studio
- Proficiency in basic database administration duties
Target Audience
- Database Administrators (DBAs)
- Data Engineers
- IT specialists managing 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
