You are leaving our Website
Using an external Link:
You are now leaving our website. The following page is operated by a third party. We accept no responsibility for the content, data protection, or security of the linked page..
URL:
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.
Start: 2025-11-03 | 10:00 am
End: 2025-11-07 | 01:30 pm
Location: Nürnberg
Price: 3.450,00 € plus VAT.
Start: 2026-03-16 | 10:00 am
End: 2026-03-20 | 01:30 pm
Location: Nürnberg
Price: 3.450,00 € plus VAT.
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
- Database mirroring and availability groups
- Replication of databases
- Overview of different replication types in SQL Server
- 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.
Guaranteed implementation:
from 2 Attendees
Booking information
Price:
3.450,00 € plus VAT.
(including lunch & drinks)
Appointment selection:
Testimonials:
Authorized training partner
Authorized training partner
Memberships
Memberships
Shopping cart
DB300: MS SQL Server 2022 Administration
was added to the shopping cart.