Course
Digicomp Code SQLADM
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.
Vendor code
SQLADM
Duration
3 days
Price
2'550.–
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
- 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
- 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
- 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
- Database Engine and Agent Logs
- Processes, Locks, Deadlocks, Blocking
- Profiler/Extended Events
- SQL Server Auditing
- Encryption
- Configuration Manager
- Database Migration
- SQL Server System Databases
- Indexes and Statistics
- Overview SQL Server Maintenance
The primary audience for this course are individuals who want to get a solid introduction to administering and maintaining SQL Server On-Prem databases.
The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.
- Basic knowledge of the Microsoft Windows operating system and its core functionality
- Working knowledge of Transact-SQL as in the course Standard SQL-3
- Working knowledge of relational databases
The concepts and skills learned in the course apply to all versions of SQL Server (2012-2022)