Course Description

Course Overview

The Administering a SQL Database Infrastructure course is designed to provide participants with the knowledge and skills required to effectively administer and manage the infrastructure that supports a SQL database. The course covers various aspects of database infrastructure administration, including server installation and configuration, database maintenance, performance tuning, high availability, and disaster recovery. Participants will learn how to ensure the availability, security, and optimal performance of the SQL database infrastructure.

Prerequisites

Participants should have a solid understanding of SQL fundamentals, database concepts, and experience with administering SQL databases. Familiarity with Windows Server administration, networking concepts, and SQL Server or a similar relational database management system is recommended.

Methodology

The training program combines instructor-led lectures, demonstrations, hands-on labs, and interactive discussions to ensure a comprehensive and practical learning experience. Participants will have access to SQL database environments and infrastructure components to reinforce their understanding and gain hands-on experience.

Course Outline

• Introduction to Database Infrastructure Administration
• Understanding the role and responsibilities of a database infrastructure administrator
• Exploring the components and architecture of a SQL database infrastructure
• Assessing the considerations for database server installation and configuration
• Understanding different deployment options and high availability solutions
• Database Server Installation and Configuration
• Installing and configuring SQL Server instances and components
• Managing server settings, memory, and storage options
• Configuring server security and authentication modes
• Implementing database server upgrades and patching
• Database Maintenance and Monitoring
• Implementing database maintenance tasks and best practices
• Monitoring and managing database performance and resource utilization
• Configuring and managing database backup and recovery
• Automating maintenance tasks and scheduling jobs
• Performance Tuning and Optimization
• Identifying and resolving database performance bottlenecks
• Optimizing query execution plans and indexing strategies
• Monitoring and analyzing database performance metrics
• Configuring and managing database resources and performance counters
• High Availability and Disaster Recovery
• Implementing high availability and disaster recovery solutions
• Configuring database mirroring, log shipping, and Always On availability groups
• Managing failover and failback scenarios
• Implementing backup and restore strategies for disaster recovery

Outcome

Upon completing this training, participants will be able to:

• Understand the role and responsibilities of a database infrastructure administrator
• Install, configure, and upgrade SQL Server instances and components
• Implement database maintenance tasks, backup, and recovery strategies
• Monitor and optimize database performance and resource utilization
• Implement high availability and disaster recovery solutions for SQL databases

Labs

The training includes hands-on labs to provide participants with practical experience administering and managing a SQL database infrastructure. These labs may include exercises such as:

• Installing and configuring SQL Server instances and components
• Implementing database maintenance tasks and backup strategies
• Monitoring database performance and resource utilization
• Configuring high availability solutions such as database mirroring or availability groups
• Performing backup and restore operations for disaster recovery scenarios