Course

Introduction SQL Server Administration («SQLADM»)

Using a practice-focussed approach, this course teaches the fundamental concepts and skills required to get started with administering a SQL Server On-Prem Database Infrastructure.
Duration 2 days
Price 1'800.–
Course documents Digicomp courseware (English; digital)

Course facts

Key Learnings
  • Getting a practical introduction to the concepts and skills required to get started with SQL Server on-premises administration
  • Focusing on the key areas of security, backup/restore and the job engine with a hands-on approach (skills apply to all versions of SQL Server (2012-2022))
  • Using tools such as SQL Server Management Studio, Azure Data Studio and the sqlcmd utility
Content

1 SQL Server Security

  • Concepts
    • Server Instances
    • System and User Databases
    • Windows and SQL Server Authentication
    • Impersonation
    • Principles, Permissions, Securables
    • Server Logins and Roles
    • Database Users and Roles
    • Object and Schema Permissions
    • Orphaned users
  • Skills Practiced
    • Administer Logins and Users
    • Assign Server and Database Roles
    • Assign Server, Database, and Object Level Permissions
    • Impersonate using EXECUTE AS
    • Handle Orphaned Users
    • Troubleshoot Permission Issues

2 Backup/Restore

  • Concepts
    • Transactions, Data Modification
    • Data Pages, Log and Data Files
    • Buffer Cache, Write-Ahead Logging
    • Recovery, Recovery Models
    • Backup Strategies
  • Skills Practiced
    • Full, Incremental, and Differential Backups
    • Copy-Only Backups
    • Restore
    • Point-In-Time Restore
    • WITH MOVE, REPLACE options
    • View Backup History

3 SQL Server Agent Jobs

  • Concepts
    • Agent Service
    • Jobs, Job Steps, Schedules
    • Credentials and Proxies
    • msdb
  • Skills Practiced
    • Creating Jobs, Job Steps, and Schedules
    • Assigning Security Contexts to Job Steps
    • View Job status
    • View Job History
    • Troubleshoot Jobs

4 Optional Topics (Time Permitting)

  • Database Engine and Agent Logs
  • Processes, Locks, Deadlocks, Blocking
  • Profiler/Extended Events
  • SQL Server Auditing
  • Encryption
  • Configuration Manager
Target audience

The primary audience for this course is individuals who want a solid introduction to managing and maintaining SQL Server on-prem databases.

The secondary audience for this course is individuals developing applications that serve content from SQL Server databases.

Requirements

Basic knowledge of the Microsoft Windows operating system and its basic features is required, as well as basic knowledge of relational databases.

You will also need practical knowledge of Transact-SQL, as covered in the following course:

    Standard SQL-3 («SQL»)

    2 days
    • Basel, Berne, Geneva, Lausanne, Virtual Training, Zürich
    CHF
    1'800.–
Additional information

The concepts and skills learned in this course are applicable to all versions of SQL Server (2012-2022).

Download

Questions

Any questions?
First name
Last name
Company optional
Email
Phone
I would like to book this course as a company course
First name
Last name
Company optional
Email
Phone
Number of participants
Desired course location
Start date (DD.MM.YYYY)
End date (DD.MM.YYYY)

Choose your date

22
May
2025
23
May
2025
Zürich
German
Timetable
If you register now, this course is guaranteed to take place!
CHF 1’800.-
exkl. 8.1% Mwst.
If you register now, this course is guaranteed to take place!
CHF 1’800.-
exkl. 8.1% Mwst.
22
May
2025
23
May
2025
Basel
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
28
Aug
2025
29
Aug
2025
Zürich
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
28
Aug
2025
29
Aug
2025
Berne
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
28
Aug
2025
29
Aug
2025
Basel
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
5
Nov
2025
6
Nov
2025
Zürich
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
5
Nov
2025
6
Nov
2025
Berne
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
5
Nov
2025
6
Nov
2025
Basel
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
Next date
22
May
2025
23
May
2025
Zürich
German
Timetable
If you register now, this course is guaranteed to take place!
CHF 1’800.-
exkl. 8.1% Mwst.
If you register now, this course is guaranteed to take place!
CHF 1’800.-
exkl. 8.1% Mwst.