IT practice: SQL Server 2019/2017/2016 Administration

Course PW28

  • Duration:
    • 4 days

Dates:

  • Implementation planned - places still available
  • Implementation - probability high - still places available
  • There are no more seats available. For many courses, it may still be possible to participate online, via virtual classroom.
  • Course times: As a rule, our seminars are held from 10:00 am to 5:00 pm on day 1 and from 9:00 am to 4:00 pm on the following days. Changes are possible. The concrete seminar times you will find in the binding order confirmation.
27.01.2025 - 30.01.2025 Virtual Classroom Zoom
  • 2690 EUR / Person
German
07.04.2025 - 10.04.2025 Virtual Classroom
  • 2690 EUR / Person
 German
07.07.2025 - 10.07.2025 Cologne
  • 2690 EUR / Person
 German
10.11.2025 - 13.11.2025 Virtual Classroom
  • 2690 EUR / Person
 German

The course provides the basic knowledge required to plan, deploy and administer SQL Server of the current versions (2022 as soon as available, 2019, 2017 or 2016). It covers planning and operation in small and medium-sized environments as well as in enterprise environments. The central administrative activities are covered, providing comprehensive practical knowledge and identifying typical pitfalls.
The course serves to acquire practical knowledge and to exchange experiences. Vendor certification is not provided.

Overview and planning

  • Editions, version overview and requirements
  • Components and services (Agent, SSIS, SSAS, SSRS, Power BI)
  • Instances and high-availability installation scenarios

Installation and configuration

  • Installation of the SQL Server, explanation of the parameters
  • Initial configuration of the SQL Server instance - important configuration options

Working with databases

  • Basic knowledge of databases - file types, file groups, special features
  • Creating and managing databases - resizing, deleting, moving

SQL Server security

  • Security configuration of SQL instances - SPNs, domain integration, delegation, Kerberos
  • Authenticating and authorising users
  • Assigning server and database roles
  • Managing access authorisations
  • Presentation of further protection options - encryption, audit

Backing up and restoring databases

  • Recovery models, backup types and backup strategy
  • Backing up SQL Server databases
  • Restoring SQL Server databases
  • Recovery of system databases

Automation of SQL Server administration tasks

  • Maintenance plans
  • Working with SQL Server Agent - jobs, alerts and operators
  • Configuring the SQL Server Agent service - notifications, email configuration
  • Configuring security - understanding agent security, credentials and proxy accounts

Basic monitoring and troubleshooting

  • Monitoring the current activity
  • Troubleshooting approaches
  • Service related issues - relevant protocols
  • Connectivity issues

Administrators of MS SQL Server environments; IT and system managers; database developers

  • Basic knowledge of databases
  • Basic knowledge of Windows server platform and network basics

This course serves to acquire practical knowledge and to exchange experiences. Manufacturer certification is not provided.

The course price includes

  • Break catering for face-to-face training: drinks, biscuits and lunch

We are also happy to organise this training as an in-house seminar. Ask for your individual offer.

The course is offered in German.

Contact us

SoftwareONE

IT CAMPUS
Customer Training Solutions

Blochstraße 1
D-04329 Leipzig
*The services of SoftwareONE Deutschland GmbH directly serving school and educational purposes are predominantly VAT-exempt according to § 4 No. 21 a) bb) UStG. Contact us - we are happy to help!