SQL Server 2022 Administration

SQL Server and its Toolset - The SQL Server Platform - SQL Server Tools - SQL Server Services

SQL Server installation - SQL Server architecture - Planning server resources - Testing before installation - Preparing for installation - Installing SQL Server - Upgrading and automating installation

SQL Server databases - role and structure of SQL Server databases - files and file groups

SQL Server Backup and Recovery - Backup Strategies - SQL Server Transaction Logging - Backup Databases and Transaction Logs - Managing Database Backups - Restoring SQL Server Databases

SQL Server Import and Export of Data

SQL Server and database roles - Working with server roles - Fixed database roles - Custom database roles

SQL Server permissions management - User access to objects - Authorizing users to execute code - Configuring schema-level permissions

Automating SQL Server Administration - SQL Server Agent - SQL Server Agent Jobs

SQL Server Agent - Configuring permissions - Configuring proxy accounts - Starting the agent automatically - Configuring the agent

Monitoring SQL Server with alerts and notifications

SQL Server database maintenance - Ensuring database integrity - Index maintenance - Automating routine tasks

SQL Server Monitoring and Auditing - Recording activity using SQL Server Profiler - Improving performance with Database Engine Tuning Advisor - Tracking options - DMVs (Dynamic Management Views) - Recording and managing performance data - Analyzing collected data

Managing multiple SQL Servers - Working with multiple servers - Virtualizing SQL Server - Deploying and upgrading data tier applications

SQL Server Tuning - RAID Level, Database Partitioning - Indexes

Troubleshooting common SQL Server administration problems

We conduct this seminar online for you. You can book the training as a public seminar or as a company seminar. The practical exercises are carried out in our Remotelab and make up 40-50 percent of the seminar.

We offer seminars with a high practical relevance. The contents and exercises are geared to your daily tasks in the company and completely dispense with advertising references to other products of the software manufacturer.

All our training courses are manufacturer-independent. This enables us to offer critical considerations of the products themselves and comparisons with competitors of the manufacturer in the seminar. The course contents are our own and derived from the practical experience of our trainers in projects.

Of course, the contents of company seminars can be individually adapted to your needs. Please do not hesitate to contact us.

• Implementation guarantee - Implementation guarantee for two or more participants
• Mobile classrooms - the ideal complement for company seminars
• Free support - for questions after the seminar
• Delivery on account - no prepayment required
• Interview with the trainer / quality assurance - get to know and assess the trainer in advance
• Clarify seminar requirements - review your knowledge with the trainer
• Assistance with travel costs - we cover part of the costs of hotel accommodation
• Meals - all day cold / hot drinks and a full lunch in the restaurant
• Location of training centres - always centrally located and easily accessible
• Discount - we have attractive prices, take advantage of our additional discounts
• Remotelabs - rent our Remotelabs for your own seminars or as a complement to your company seminars