感谢您发送咨询！我们的团队成员将很快与您联系。
感谢您发送预订！我们的团队成员将很快与您联系。
课程大纲
Intermediate SQL Server Administration
- Instance configuration and service management
- Managing databases, files, and filegroups
- Task automation with SQL Server Agent
SQL Server Security
- Managing user accounts, roles, and permissions
- Windows vs SQL authentication
- Auditing and data encryption
Monitoring and Performance Optimization
- Using Activity Monitor and Dynamic Management Views (DMVs)
- Execution plans and statistics
- Query optimization and index tuning
Backup and Recovery
- Backup strategies (full, differential, transaction log)
- Point-in-time restores and damaged database recovery
- Automating backup plans
Advanced SQL Server Administration
- High availability: Clustering, Log Shipping, Database Mirroring
- AlwaysOn Availability Groups
- Replication implementation (Snapshot, Transactional, Merge)
Advanced Performance Management
- Locks, deadlocks, and blocking diagnosis
- Resource Governor and workload control
- Performance tuning in multi-instance environments
Troubleshooting and Auditing
- Detecting critical issues using logs and system tools
- Implementing auditing policies
- Advanced diagnostics and forensic analysis tools
Summary and Next Steps
要求
- Basic knowledge of SQL Server and database concepts
- Experience using SQL Server Management Studio
- Familiarity with basic database administration tasks
Audience
- Database Administrators (DBAs)
- Data Engineers
- IT professionals responsible for SQL Server environments
28 小时
客户评论 (5)
菲利普非常友善，他解释SQL概念的风格非常出色。 我喜欢他给我们信息并回答不属于本课程的问题。
Stefan
课程 - SQL in SQL Server
机器翻译
Practical exercises for practice and understanding of the concept, clarification provided for any questions.
Safdar Abbas - Medtech Limited
课程 - T-SQL Fundamentals with SQL Server Training Course
It allowed us to have an applied hands on sproc to our company database.
Corneliu Buculei - Standard Building Supplies Ltd
课程 - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Interactive exercises
Matthew Viner - Thames Water Utilites Ltd
课程 - Transact SQL Basic
the in depth knowledge and customize approach
