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

  • 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

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

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.

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:

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

Download

Questions

Choose your date