Course Delivery & Instructor Access: Software Tutorial Services
Course Authoring & LMS Packaging: Courseware Studio
Duration: 5 Days
Modules: 15 (Plus 1 Optional Module)
Audience Level: Intermediate
Format: Instructor-Led / Bootcamp
This five-day course provides students with the knowledge and skills required to administer a SQL Server 2025 database infrastructure. Students learn how to deploy and configure SQL Server instances, manage database objects, implement security, monitor performance, and automate administrative tasks using SQL Server Management Studio 22, PowerShell, and command-line tools.
AI Chat Assistant: This course features an integrated, interactive AI Tutor available 24/7 directly within the courseware platform at no additional cost. Learners can ask questions in real time to explore core administration concepts, investigate role-based security configurations, examine backup and recovery strategies, administrative automation workflows, and all other course topics.
After completing this course, students will be able to:
- Configure and deploy SQL Server 2025 instances using SQL Server Management Studio 22, PowerShell, and command-line tools
- Administer database objects and implement comprehensive security models
- Manage user permissions and role-based access control
- Monitor database performance and optimize query execution
- Automate administrative tasks using SQL Server Agent, PowerShell scripts, and command-line utilities
- Implement backup, recovery, and disaster recovery strategies to protect business-critical data
Students attending this course should have:
- Basic knowledge of the Microsoft Windows operating system
- Working knowledge of Transact-SQL
- Working knowledge of relational databases
- Familiarity with previous versions of SQL Server Management Studio
- Experience with database design
Duration: 129 min
- SQL Server Security Fundamentals
- Implementing SQL Server Authentication and Login Management
- Configure Windows and SQL Server authentication modes using SSMS 22
- Create and manage SQL Server logins and security principals
- Implement password policies and security best practices
- Evaluate security implications of different authentication methods
Duration: 134 min
- Understanding Server and Database Roles
- Configuring Role-Based Security
- Identify and assign fixed server roles using SSMS 22
- Configure fixed database roles and custom database roles
- Implement role-based security using least-privilege principles
- Manage role membership and permissions effectively
Duration: 139 min
- SQL Server Permission Model
- Implementing Granular Access Control
- Grant, deny, and revoke permissions on database objects
- Configure schema-level and object-level permissions
- Implement effective permission hierarchies
- Troubleshoot permission-related access issues using SSMS 22
Duration: 124 min
- Data Encryption Strategies in SQL Server 2025
- Configuring Database Encryption
- Implement Transparent Data Encryption (TDE) for database files
- Configure Always Encrypted for column-level encryption using SSMS 22
- Manage encryption keys and certificates
- Evaluate encryption performance and security implications
Duration: 129 min
- SQL Server Auditing Fundamentals
- Implementing SQL Server Auditing
- Create and configure SQL Server audit objects
- Implement server audit specifications for instance-level events
- Configure database audit specifications for data access tracking
- Review and analyze audit logs using SSMS 22 and T-SQL
Duration: 144 min
- Advanced Compliance and Auditing Features
- Implementing Advanced Compliance Controls
- Implement fine-grained auditing for specific user actions
- Configure dynamic data masking for sensitive data protection
- Create custom audit policies using T-SQL and PowerShell
- Automate compliance reporting using audit data
Duration: 115 min
- Recovery Models and Backup Strategy Design
- Planning and Configuring Backup Strategies
- Evaluate recovery models: Simple, Full, and Bulk-Logged
- Configure database recovery models using SSMS 22
- Design backup strategies aligned with recovery requirements
- Calculate recovery objectives and backup schedules
Duration: 134 min
- SQL Server Backup Operations
- Implementing Database Backups
- Perform full database backups using SSMS 22 and T-SQL
- Execute differential backups and understand their dependencies
- Create transaction log backups for point-in-time recovery
- Verify backup integrity using RESTORE VERIFYONLY and checksums
Duration: 129 min
- Database Restore Strategies and Procedures
- Performing Database Recovery Operations
- Restore full database backups to original and alternate locations
- Perform differential restore operations
- Execute point-in-time recovery using transaction log backups
- Troubleshoot common restore errors and issues
Duration: 120 min
- Data Import and Export Techniques
- Bulk Data Operations
- Import data using SQL Server Import and Export Wizard in SSMS 22
- Export data to various file formats using SSMS tools
- Use the bcp utility for high-performance bulk operations
- Implement BULK INSERT and OPENROWSET for programmatic data import
Duration: 134 min
- SQL Server Agent Fundamentals
- Implementing Job Automation
- Create and configure SQL Server Agent jobs using SSMS 22
- Define job steps with T-SQL, PowerShell, and operating system commands
- Implement job schedules with recurring and event-driven triggers
- Monitor job execution history and troubleshoot failures
Duration: 124 min
- Alerts and Notifications Architecture
- Implementing Alerting and Notification Systems
- Create SQL Server Agent alerts for errors and performance conditions
- Configure operators and notification delivery methods
- Implement Database Mail for email notifications
- Design notification escalation and response procedures
Duration: 144 min
- PowerShell for SQL Server Administration
- Automating Administration with PowerShell
- Connect to SQL Server instances using the SqlServer PowerShell module
- Execute T-SQL queries using the Invoke-Sqlcmd cmdlet
- Automate database administration tasks with PowerShell scripts
- Manage SQL Server configuration using PowerShell cmdlets
Duration: 134 min
- Performance Monitoring Tools and Techniques
- Implementing Performance Monitoring
- Create and configure Extended Events sessions using SSMS 22
- Query Dynamic Management Views (DMVs) to identify performance bottlenecks
- Analyze wait statistics and resource consumption patterns
- Implement proactive monitoring strategies using DMVs
Duration: 124 min
- SQL Server Troubleshooting Methodology
- Resolving SQL Server Issues
- Diagnose and resolve connectivity and authentication issues
- Troubleshoot blocking and deadlock situations
- Identify and resolve slow query performance problems
- Detect and repair database corruption using DBCC commands
Duration: 143 min
- SQL Server 2025 Innovation Overview
- Hands-On with SQL Server 2025 New Features
- Identify AI and machine learning capabilities in SQL Server 2025
- Utilize SSMS 22 enhancements for improved productivity
- Implement new JSON and T-SQL functionality
- Distinguish between new features and improvements from prior versions
- Live Corporate Training Delivery: To schedule this 5-day bootcamp delivered by Microsoft Certified Trainers for your team, visit Software Tutorial Services.
- AI Course Authoring & SCORM Exports: Need to adapt this syllabus, generate tailored student manuals, create PowerPoint slide decks, or export interactive LMS packages? Use Courseware Studio.
- Instructor Classroom Tools: Pacing lab sessions? Use our free Timer3 presentation timer.