DB300: MS SQL Server 2022 Administration

Training: Microsoft™ - Databases

System and database administrators learn installation and administration of SQL Server 2022. The course covers architecture, database and security management, backup and recovery, as well as automation of administrative tasks. It provides performance tuning with indexes, the use of admin tools, and new features compared to previous versions. A strong practical component ensures direct applicability in daily work.

Hybrid training Hybrid training

Start: 2025-11-03 | 10:00 am

End: 2025-11-07 | 01:30 pm

Location: Nürnberg

Price: 3.450,00 € plus VAT.

Hybrid training Hybrid training

Start: 2026-03-16 | 10:00 am

End: 2026-03-20 | 01:30 pm

Location: Nürnberg

Price: 3.450,00 € plus VAT.

Request prefered appointment period:

* All fields marked with an asterisk are mandatory fields.

Agenda:

  • Installation
    • Architecture and components
    • New installation of a database instance

  • Managing databases and files
    • Planning and creating databases
    • Managing files and file groups
    • Creating database snapshots
    • Using immediate data initialization

  • Managing SQL Server security
    • Setting up users at server and database level
    • Creating roles
    • Assigning rights
    • Setting up monitoring

  • Planning and creating indexes
    • Creating and managing indexes
    • Use of the Database Optimization Advisor

  • Advanced techniques in SQL Server
    • Central management servers
    • Policy-based management
    • Resource Governor (workload prioritization)
    • Transparent database encryption
    • Data collection (collection of performance data)

  • Disaster recovery
    • SQL Server recovery models
    • Backing up and restoring user-defined databases
    • Backing up and restoring system databases
    • Backup compression

  • Automating administrative tasks
    • Using SQL Server Agent
    • Creating jobs, operators and alerts
    • Setting up jobs
    • Using maintenance plans

  • High availability of databases
    • Database mirroring and availability groups

  • Replication of databases
    • Overview of different replication types in SQL Server

  • Overview of new features in SQL Server 2022
    • Monitoring data changes (ledger)
    • New features in assigning rights in SQL Server 2022
    • Calculating the maximum server working memory in SQL Server 2022

  • Extensive hands-on component

Objectives:

In the seminar DB300 MS SQL Server 2022 Administration participants learn the administration and configuration of Microsoft™'s MS SQL 2022 Server. The course also explains the new features and advantages of MS SQL Server 2022 compared to earlier versions of Microsoft™ DB.

Additional trainings for SQL programming are:

Target audience:

The workshop DB300 MS SQL Server 2022 Administration is targeted at:

  • System Administrators
  • Database Administrators
  • SQL Users

Prerequisites:

To be able to follow the learning pace and content of the training DB300 MS SQL Server 2022 Administration effectively, Windows Server 2016 as well as Active Directory knowledge is required. Basic knowledge of relational databases is advantageous.

Description:

In the fundamentals workshop DB300 MS SQL Server 2022 Administration, system administrators and database administrators learn hands-on installation and management of SQL Server 2022. The course covers architecture, installation, database and security management as well as backup and recovery of databases. Special focus is on automation of administrative tasks, performance optimization through indexes and the use of administration and configuration tools.

Additionally, new features of version 2022 compared to predecessors are presented. Prerequisites are Windows Server 2016 and Active Directory knowledge as well as basic knowledge of relational databases. The high practical component makes the course ideal for beginners and users who want to professionally administer SQL Server.
check-icon

Guaranteed implementation:

from 2 Attendees

Booking information

Price:

3.450,00 € plus VAT.

(including lunch & drinks)

Testimonials:

Cheerful male participant, representative of all customers who have provided feedback on qSkills' services.
#Testimonials
If qualification, then qSkills™

Authorized training partner

NetApp Partner Authorized Learning
Commvault Training Partner
CQI | IRCA Approved Training Partner
Veeam Authorized Education Center
Acronis Authorized Training Center
AWS Partner Select Tier Training
ISACA Accredited Partner
iSAQB
CompTIA Authorized Partner
EC-Council Accredited Training Center

Memberships

Allianz für Cyber-Sicherheit
TeleTrust Pioneers in IT security
Bundesverband der IT-Sachverständigen und Gutachter e.V.
Bundesverband mittelständische Wirtschaft (BVMW)
Allianz für Sicherheit in der Wirtschaft
NIK - Netzwerk der Digitalwirtschaft
BVSW
Bayern Innovativ
KH-iT
CAST
IHK Nürnberg für Mittelfranken
eato e.V.
Sicherheitsnetzwerk München e.V.