• Introduction to Data Storage with SQL Server
• Managing Storage for System and user Databases
• Configuring the Buffer Pool Extension and Hybrid buffer pool
• Lab: Managing Database Storage

• Ensuring Database Integrity
• Tempdb Configuration and Memory-optimized TempDB Metadata
• Maintaining Indexes
• Lab: Performing Ongoing Database Maintenance

• Connections to SQL Server
• Privileges and permissions to Logins with Database
• Authorization Across Servers
• Lab: Authenticating Users

• Working with Server Roles
• Working with Fixed Database Roles
• User-Defined Database and Server Roles
• Lab: Assigning Server and Database Roles

• Creating and Granting User Access to Objects
• Authorizing Users to Execute Code
• Configuring Permissions at the Schema and Database level
• Lab: Authorizing Users to Access Resources

• Auditing Data Access in SQL Server
• Implementing SQL Server Audit
• Managing SQL Server Audit
• Lesson 4: Always Encrypted with Secure Enclaves, Database classification function on 2019
• Lab: Using Auditing and Encryption

• Understanding Backup Strategies
• SQL Server Transaction Logs
• Planning Backup Strategies
• Lab: Understanding SQL Server Recovery Models

• Backing Up Databases and Transaction Logs
• Managing Database Backups
• Advanced Database Options
• Lab: Backing Up Databases

• Understanding the Restore Process
• Restoring SQL Databases
• Point-in-time Recovery with Advance Restore Scenario
• Accelerated Database Recovery
• Lab: Restoring SQL Server Databases

• Automating SQL Server Management
• Working with SQL Server Agent
• Managing SQL Server Agent Jobs with Security Contexts
• Lab: Automating SQL Server Management

• Extended Events Core Concepts
• Working with Extended Events
• Lab: Extended Events

• Monitoring Activity
• Capturing and Managing Performance Data
• Query Execution and Query Plan Analysis
• Statistics Internal
• Query Store
• Lab: Monitoring SQL Server

• Monitoring SQL Server Errors
• A Troubleshooting Methodology for SQL Server
• Resolving Blocking and Locking in SQL Server
• Resolving Connectivity and Login Issues
• Lab: Troubleshooting Common Issues

• Transferring Data to and from SQL Server
• Importing and Exporting Table Data
• bulk copy program and BULK INSERT to Import Data
• Lab: Importing and Exporting Data

A: Participants should have a basic understanding of relational databases and SQL concepts. Familiarity with the SQL Server environment and experience with database management systems is beneficial but not mandatory.

A: The training covers a wide range of topics, including SQL Server architecture, installation and configuration, database creation and management, query performance optimization, SQL Server security, and backup and recovery operations.

A: Yes, the training is designed to cater to both beginners and experienced professionals. It provides a solid foundation in SQL Server administration and progresses to more advanced topics. Beginners will gain a comprehensive understanding of SQL Server 2019 and its administration principles, while experienced professionals can enhance their skills and stay updated with the latest features and best practices.

A: With the increasing demand for SQL Server database administrators, completing this training can open up various career opportunities. Participants can pursue roles such as SQL Server database administrator, database developer, system administrator, or data analyst in organizations that utilize SQL Server as their database management system.

A: Yes, the training includes hands-on labs and exercises that provide participants with practical experience in administering SQL Server 2019 databases. These hands-on activities allow participants to apply the concepts learned in real-world scenarios.

A: The duration of the training may vary depending on the format and delivery method. Typically, this training spans multiple days, with each day consisting of several hours of instruction, hands-on exercises, and discussions.

A: Yes, participants will receive comprehensive course materials, including slides, lab guides, and additional reference materials to support their learning during and after the training

A: This training does not include a specific certification. However, it provides valuable knowledge and skills that can contribute to your professional growth and enhance your capabilities in managing Active Directory services.

A: This training can be customized to address specific organizational needs. We can discuss customization options based on your requirements.

A: The training is delivered by experienced instructors who have expertise in Active Directory services and Windows Server administration. These instructors possess practical knowledge and industry experience to provide relevant and valuable insights during the training sessions.