Introduction SQL Server Administration («SQLADM»)

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:

COURSE
Standard SQL-3 («SQL»)
2 days
• Basel, Berne, Geneva, Lausanne, Virtual Training, Zürich
CHF
1'800.–
Learn more

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