Skip to content

Microsoft SQL Server DBA Essential

Master the key concepts of SQL Server, then install, configure, administer and maintain it to best practices.

You want to master the concepts, installation, configuration, administration and maintenance of SQL Server? Then this DBA SQL Server Essential Skills course is for you. This course will teach you the key concepts of SQL Server databases. By the end of the course, you'll be able to understand, administer and maintain SQL Server databases according to best practices.

Objectives

  • Understand SQL Server concepts (operation, storage, security, administration)
  • Install & configure a GUI or command line instance, following best practices
  • Create and configure databases
  • Maintain an MSSQL environment: maintenance plan (indexes, data integrity, backups), SQL agent jobs and alerts, error log optimization
  • SQL Server prerequisites and best practices

Method

  • Presentations, practical exercises, case studies and question-oriented demonstrations
  • Discussion and networking during breaks and lunch (included)

Target groups

  • This Microsoft SQL Server DBA Essentials course is designed for Database Administrators (DBAs) as well as network, system and application administrators responsible for SQL Server databases or their support.

Prerequisites

  • Basic knowledge of Windows Server.

5% discount for SOUG, SwissPUG and DOAG members.

Overview

Database · Microsoft

Duration

3 Day(s)

Price

2700 CHF

Tue 24 – Thu 26 Nov 2026

Location

Zurich

Language

German

No places available

Wed 31 Mar – Fri 2 Apr 2027

Location

Nyon

Language

French

No places available

Tue 13 – Thu 15 Apr 2027

Location

Basel

Language

German

No places available

Tue 13 – Thu 15 Apr 2027

Location

Zurich

Language

German

No places available

Tue 13 – Thu 15 Apr 2027

Location

Bern

Language

German

No places available

Taught by the people who run it in prod.

Roger Schönmann

Roger Schönmann

Principal Consultant

Amine Haloui

Amine Haloui

Consultant

Nathan Courtine

Nathan Courtine

Senior Consultant and Technology Leader