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 40 hours
Course Outline
Introduction to SQL Server
- Comprehensive analysis of SQL Server architectural components
- Overview of software versions and licensing editions
- Available administrative tools and user interfaces
Installation and Configuration
- Mandatory system prerequisites
- Procedures for installing SQL Server and SQL Server Management Studio
- Initial setup protocols and security hardening
Database Management
- Creation and lifecycle management of databases
- Definition of tables, indexes, and data constraints
- Protocols for backup and restoration operations
User and Security Administration
- Authentication mechanisms and modes
- Role-based access control and permission assignment
- Audit trails and regulatory compliance measures
Performance Monitoring and Tuning
- Utilization of monitoring utilities and reporting features
- Foundational principles of query optimization
- Strategies for index management and optimization
Automation and Maintenance
- Configuration of SQL Server Agent and scheduled jobs
- Implementation of structured maintenance plans
- Automation of backup routines and alert systems
Troubleshooting and Recovery
- Analysis of error logs and diagnostic procedures
- Understanding and configuring recovery models
- Foundations of high availability architectures
Summary and Next Steps
Requirements
- Fundamental understanding of database concepts
- Demonstrated experience with Windows operating systems
- Familiarity with basic SQL query syntax
Target Audience
- Database administrators
- IT systems managers
- Technical support staff
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 training was well structured and interactive
kgotla Moncho - Martin Engineering Africa
Course - MS 20761 : Querying Data with Transact SQL
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.