Database Administration · PPL

Microsoft SQL Server Administration Certification

A professional program designed to develop practical skills in SQL Server installation, configuration, security, backup, recovery, monitoring, maintenance, and database administration.

  • ⏱3 DaysDuration
  • ◈PPLAccredited
  • ◐3 LanguagesArabic · English · Hindi
  • ◆₹10,999.00 Per delegate

This course is accredited by PPL

This is for all ppl accredited courses
2M+ Delegates trained worldwide
15,000+ Corporate clients
490+ Training locations
4.8 ★ Average learner rating
20% OFF Limited-time launch offer
— The journey

Course Outline

What the programme covers, module by module.

Module 1: Introduction to SQL Server Administration

  • SQL Server overview
  • Database administration responsibilities
  • SQL Server ecosystem
  • Database environments
  • Administration lifecycle
  • Common administrative tasks

Module 2: SQL Server Architecture

  • Database engine
  • SQL Server instances
  • System databases
  • Database files
  • Memory architecture
  • SQL Server services

Module 3: Installing SQL Server

  • Installation planning
  • Hardware considerations
  • Software requirements
  • SQL Server setup
  • Feature selection
  • Installation validation

Module 4: SQL Server Configuration

  • Instance configuration
  • Server properties
  • Database settings
  • Service configuration
  • Network configuration
  • Configuration best practices

Module 5: SQL Server Management Studio

  • SSMS environment
  • Object Explorer
  • Query Editor
  • Server properties
  • Activity monitoring
  • Administrative workflows

Module 6: Creating & Managing Databases

  • Database creation
  • Database properties
  • Data files
  • Log files
  • Filegroups
  • Database modification

Module 7: Database Storage Management

  • Pages and extents
  • Data storage
  • File growth
  • Autogrowth
  • Storage allocation
  • Capacity planning

Module 8: SQL Server Security Fundamentals

  • Authentication
  • Windows authentication
  • SQL Server authentication
  • Logins
  • Users
  • Security principles

Module 9: Roles & Permissions

  • Server roles
  • Database roles
  • Object permissions
  • GRANT
  • DENY
  • REVOKE

Module 10: Backup Fundamentals

  • Backup strategies
  • Full backups
  • Differential backups
  • Transaction log backups
  • Backup destinations
  • Backup verification

Module 11: Database Restore & Recovery

  • Restore concepts
  • Full database restore
  • Differential restore
  • Transaction log restore
  • Recovery options
  • Recovery validation

Module 12: Recovery Models

  • Simple recovery
  • Full recovery
  • Bulk-logged recovery
  • Transaction logs
  • Recovery objectives
  • Recovery model selection

Module 13: Database Integrity Management

  • Database consistency
  • DBCC CHECKDB
  • Integrity checks
  • Corruption concepts
  • Maintenance strategies
  • Integrity monitoring

Module 14: Index Administration

  • Index fundamentals
  • Clustered indexes
  • Non-clustered indexes
  • Index fragmentation
  • Rebuilding indexes
  • Reorganizing indexes

Module 15: Statistics & Query Performance

  • SQL Server statistics
  • Query optimizer
  • Execution plans
  • Statistics updates
  • Slow queries
  • Performance fundamentals

Module 16: SQL Server Monitoring

  • Activity Monitor
  • Dynamic Management Views
  • Sessions
  • Connections
  • Resource utilization
  • Performance monitoring

Module 17: SQL Server Agent

  • SQL Server Agent
  • Jobs
  • Job steps
  • Schedules
  • Job history
  • Automated administration

Module 18: Maintenance Plans

  • Maintenance planning
  • Backup automation
  • Integrity checks
  • Index maintenance
  • Statistics maintenance
  • Maintenance scheduling

Module 19: Transactions, Locking & Blocking

  • Transactions
  • Locks
  • Blocking
  • Isolation levels
  • Long-running transactions
  • Blocking analysis

Module 20: High Availability & Disaster Recovery

  • Availability concepts
  • Failover concepts
  • Log shipping
  • Database mirroring concepts
  • Always On availability concepts
  • Disaster recovery planning

Module 21: SQL Server Troubleshooting

  • Service failures
  • Connectivity problems
  • Authentication issues
  • Database availability
  • Storage problems
  • Performance troubleshooting

Module 22: SQL Server Administration Workshop

  • Instance configuration
  • Database creation
  • User and permission management
  • Backup and recovery
  • Maintenance configuration
  • Monitoring and troubleshooting
— 01.2 · Is it right for you?

Who it's for & what's included

Pick a delivery method to see exactly who it suits and everything you receive.

Who it's for

Classroom

Best for learners who want face-to-face tuition and to network with peers in person.

What's included

Everything you get

  • ✓ Live instructor on-site
  • ✓ Printed workbook & materials
  • ✓ Group exercises & case studies
Who it's for

Online Instructor-Led

Best for learners who want a live instructor and a fixed schedule, without the travel.

What's included

Everything you get

  • ✓ Live instructor via video call
  • ✓ Digital workbook & resources
  • ✓ Session recordings
Who it's for

Self-Paced

Best for self-motivated learners who need maximum flexibility around work and life.

What's included

Everything you get

  • ✓ On-demand video lessons
  • ✓ Interactive quizzes
  • ✓ 24/7 access on any device
— What you will master

Course Objectives

01

Understand Microsoft SQL Server architecture and core administration components.

02

Install and configure SQL Server environments effectively.

03

Create, configure, and manage databases and storage resources.

04

Implement authentication, users, roles, and database permissions.

05

Develop reliable database backup, restore, and recovery strategies.

06

Maintain database integrity, indexes, statistics, and routine administrative operations.

07

Monitor SQL Server resources and automate recurring tasks using SQL Server Agent.

08

Troubleshoot common SQL Server availability, connectivity, security, and performance issues.

— Questions answered

Frequently Asked Questions

What is Microsoft SQL Server Administration?
Microsoft SQL Server Administration involves configuring, securing, monitoring, maintaining, backing up, recovering, and troubleshooting SQL Server database environments.
Who should attend this course?
The course is suitable for database administrators, database engineers, SQL Server administrators, IT professionals, technical support professionals, and working professionals managing database systems.
Do I need previous SQL experience?
Basic SQL and relational database knowledge is recommended because the program focuses primarily on database administration and operational management.
Which administrative areas are covered?
The course covers installation, configuration, database management, storage, security, permissions, backup and recovery, indexing, monitoring, automation, maintenance, high availability, and troubleshooting.
What practical skills will I develop?
You will develop skills in configuring SQL Server, managing databases and users, performing backup and recovery, maintaining database health, monitoring resources, automating tasks, and troubleshooting common issues.
— Trusted by learners

What our delegates say

★★★★★

"The structure, the practice exams, the instructor — all top tier. Passed first try."

AS
Aarti SharmaSenior Project Manager · TCS
★★★★★

"Best training I have attended. The content is exactly what modern projects need."

JD
James DonovanProgramme Director · Capgemini
★★★★★

"24/7 support actually means 24/7 — got help on my mock exam at 2am. Worth every dollar."

MO
Maya OkaforPMO Lead · Standard Bank

★ 4.8 / 5 from 12,000+ verified learner reviews on Trustpilot & Google.

PPL Academy enquiry form

Get the course
that's right for you.

Our advisors respond within one business day.

Full name
Work email
Contact number
Message (optional)
Your details are never shared with third parties.
< 24h Response
Live & online Delivery
Certified Instructors