SQL Server Administration

21 hours
Intermediate SQL

This comprehensive SQL Server Administration course takes you from the fundamentals to advanced techniques, equipping you with the skills to install, configure, maintain, and optimize SQL Server databases in enterprise environments. You'll explore database architecture, security management, and core concepts like backup and recovery, performance tuning, and high availability to ensure reliable, efficient database operations.

Through hands-on exercises and real-world scenarios, you'll learn database maintenance, monitoring, troubleshooting, and automation using T-SQL and PowerShell. By the end of the course, you'll be confident managing SQL Server instances, implementing security policies, and maintaining optimal database performance for mission-critical applications.

Prerequisites

  • Basic understanding of relational databases
  • Familiarity with T-SQL queries
  • Comfortable working with Windows Server environments

Audience

  • Database administrators
  • System administrators
  • Anyone interested in managing and maintaining SQL Server databases

What You'll Learn

SQL Server Fundamentals

  • SQL Server Architecture and Components
  • Installation and Configuration
  • SQL Server Editions and Licensing
  • System Databases
  • SQL Server Management Studio (SSMS)
  • Configuration Manager

Database Management

  • Creating and Configuring Databases
  • Database Files and Filegroups
  • Transaction Log Management
  • Database Properties and Options
  • Shrinking and Growing Databases
  • Database Snapshots
  • Contained Databases

Security and Permissions

  • Authentication Modes (Windows vs. SQL)
  • Login and User Management
  • Server and Database Roles
  • Permissions and Securables
  • Schema-Based Security
  • Transparent Data Encryption (TDE)
  • Always Encrypted
  • Row-Level Security
  • Auditing and Compliance

Backup and Recovery

  • Backup Types (Full, Differential, Transaction Log)
  • Recovery Models (Simple, Full, Bulk-Logged)
  • Backup Strategies and Planning
  • Restore Operations
  • Point-in-Time Recovery
  • Backup Compression and Encryption
  • Disaster Recovery Planning

Performance Tuning

  • Execution Plans and Query Analysis
  • Index Design and Optimization
  • Statistics Management
  • Query Store
  • Dynamic Management Views (DMVs)
  • Wait Statistics Analysis
  • Memory Configuration
  • Tempdb Optimization
  • Performance Monitoring Tools

High Availability and Disaster Recovery

  • Always On Availability Groups
  • Failover Cluster Instances
  • Database Mirroring
  • Log Shipping
  • Replication (Snapshot, Transactional, Merge)
  • Automatic and Manual Failover
  • Read-Only Replicas

Automation and Maintenance

  • SQL Server Agent Jobs
  • Maintenance Plans
  • Index Maintenance Strategies
  • Database Integrity Checks (DBCC)
  • PowerShell for SQL Server Administration
  • Automated Monitoring and Alerts
  • Policy-Based Management
  • Resource Governor
  • Database Mail Configuration
Training Options
Number of Participants
Training Type

per participant

This course requires a minimum of 4 participants. Contact us for custom pricing for smaller groups.

Course Features

  • Expert instruction
  • Interactive lectures
  • Hands-on labs and exercises
  • Comprehensive course materials
  • Lifetime access to materials

Request Training Quote

Course
Participants
Training Type
Price per Participant

Request Received!

Thank you for your interest!

We'll contact you shortly with a detailed quote for SQL Server Administration.