+49 (911) 80 10 30

Give us a call or have us call you back!

Simply leave a message with your callback appointment

Your Name *

Your phone number *

Callback date *

Callback time *

Your request *

In order to process your request, it is necessary to process the data you provide. This means that by submitting the contact form, you consent to your data being processed (see Privacy Policy). You can object to the processing of your data at any time.

* All fields marked with an asterisk are mandatory fields.
Send a message

Your Name *

Your email *

Your phone number

Your request *

In order to process your request, it is necessary to process the data you provide. This means that by submitting the contact form, you consent to your data being processed (see Privacy Policy). You can object to the processing of your data at any time.*

* All fields marked with an asterisk are mandatory fields.
Social Media

Share page

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.

Appointment selection

Appointments in German language (2)


Hybrid training	2025-11-03 \| 10:00 am	2025-11-07 \| 01:30 pm	Nürnberg
Hybrid training	2026-03-16 \| 10:00 am	2026-03-20 \| 01:30 pm	Nürnberg

Possible course languages: German

Request prefered appointment period:

Your Name *

Your email *

Your phone number

Preferred period from *

Preferred period to *

Number of participants *

Your message

* All fields marked with an asterisk are mandatory fields.

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

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:

Your Name *

Your email *

Your phone number

Preferred period from *

Preferred period to *

Number of participants *

Your message

* 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.