|
Course |
Microsoft SQL Server 2019 Administration & Performance Optimization MasterClass |
|
Duration |
05 Days |
|
Venue |
Bangkok, Thailand |
|
Dates |
May 11-15,2026 |
|
Contacts |
+66 94 7800 807 |
Course Objectives:
This program is designed to enable participants to:
- Master SQL Server 2019 architecture and core components
- Install, configure, and manage SQL Server environments efficiently
- Optimize database performance, indexing, and query execution
- Implement high availability (HA) and disaster recovery (DR) solutions
- Secure databases using advanced security and compliance techniques
- Monitor, troubleshoot, and maintain enterprise database systems
- Automate administrative tasks for improved operational efficiency
Personal & Organizational Impacts:
Personal Impact:
- Gain hands-on expertise in database administration and tuning
- Strengthen skills in query optimization and troubleshooting
- Enhance career prospects in DBA, data engineering, and IT operations roles
- Develop confidence in managing mission-critical database systems
Organizational Impact:
- Improve database performance and application responsiveness
- Reduce downtime through robust HA/DR strategies
- Strengthen data security, compliance, and governance
- Optimize resource utilization, reducing infrastructure costs
- Enable faster decision-making through efficient data management
Course Modules:
SQL Server Fundamentals & Architecture
Module 1: Introduction to SQL Server 2019
- Editions, features, and capabilities
- SQL Server ecosystem
Module 2: SQL Server Architecture Deep Dive
- Database engine, storage engine, query processor
- Memory and I/O architecture
Module 3: Installation & Configuration
- System requirements
- Installation best practices
Module 4: Database Concepts & Structures
- Files, filegroups, tables, schemas
- System vs user databases
Module 5: SQL Server Management Tools
- SSMS, Azure Data Studio
- Command-line utilities
Administration & Configuration
Module 6: Instance Configuration & Server Settings
- Configuration options
- Resource management
Module 7: Database Creation & Management
- Creating and modifying databases
- Storage allocation
Module 8: Security & Access Control
- Logins, users, roles
- Authentication modes
Module 9: Backup & Restore Strategies
- Full, differential, log backups
- Recovery models
Module 10: Automation & Job Scheduling
- SQL Server Agent
- Maintenance plans
Performance Optimization & Tuning
Module 11: Query Processing & Execution Plans
- Query optimizer
- Reading execution plans
Module 12: Indexing Strategies
- Clustered vs non-clustered indexes
- Index design best practices
Module 13: Performance Monitoring Tools
- DMVs, Performance Monitor
- Query Store
Module 14: Query Optimization Techniques
- Writing efficient queries
- Avoiding common pitfalls
Module 15: Resource Optimization
- CPU, memory, and disk tuning
- TempDB optimization
High Availability, Disaster Recovery & Troubleshooting
Module 16: High Availability Concepts
- Failover clustering
- Always On Availability Groups
Module 17: Disaster Recovery Planning
- Backup strategies
- Replication basics
Module 18: Troubleshooting Performance Issues
- Identifying bottlenecks
- Deadlocks and blocking
Module 19: Error Handling & Logging
- SQL Server logs
- Extended Events
Module 20: Database Maintenance Best Practices
- Index maintenance
- Statistics updates
Advanced Features & Enterprise Integration
Module 21: Data Security & Encryption
- Transparent Data Encryption (TDE)
- Always Encrypted
Module 22: Auditing & Compliance
- SQL Server Audit
- Compliance frameworks
Module 23: Integration with BI Tools
- SSIS, SSRS, SSAS overview
- Data pipelines
Module 24: SQL Server in Cloud & Hybrid Environments
- Azure SQL integration
- Hybrid deployments
Module 25: Case Studies & Capstone Project
- Real-world performance tuning scenarios
- Group exercise and presentation
Course Methodologies:
The training adopts a practical, hands-on, and results-driven approach:
- Instructor-led expert sessions
- Hands-on labs for configuration, tuning, and troubleshooting
- Real-world case studies and enterprise scenarios
- Interactive discussions and peer learning
- Live demonstrations using SQL Server tools
- Simulation exercises for performance issues
- Capstone project for end-to-end database management
Important Takeaways:
Participants will be able to:
- Install, configure, and manage SQL Server 2019 environments confidently
- Optimize database performance using advanced tuning techniques
- Implement high availability and disaster recovery solutions
- Secure databases and ensure compliance with industry standards
- Monitor, troubleshoot, and maintain enterprise-grade systems
- Apply best practices for efficient and scalable database operations