Microsoft SQL Server Administration (for versions 2012-2022)
.svg)
.svg)
.svg)
Machine Learning Engineer
1. SQL server security
- Concepts:
- Server instances
- System and user databases
- Windows and SQL Server authentication
- Change of identity
- Principles, authorizations, security objects
- Server logins and roles
- Database users and roles
- Object and schema authorizations
- Orphaned users
- Practical skills
- Manage logins and users
- Assigning server and database roles
- Assign server, database and object level authorizations
- Change of identity with EXECUTE AS
- Elimination of authorization problems
- Dealing with orphaned users
2. backup/restore
- Concepts
- Transactions, data changes
- Data pages, log and data files
- Buffer cache, write-ahead logging
- Recovery, recovery models
- Backup strategies
- Practical skills
- Full, incremental and differential backups
- Copy-only backups
- Restoration
- Point-In-Time Restore
- WITH MOVE, REPLACE Options
- Show backup history
3. SQL Server Agent Jobs
- Concepts
- Agent service
- Jobs, job steps, schedules
- Login information and proxies
- msdb
- Practical skills
- Creating jobs, job steps and schedules
- Assigning security contexts to job steps
- Show job status
- Show job history
- Solving job problems
4. optional topics (depending on time availability)
- Database engine and agent protocols
- 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
Requirements:
Basic knowledge of the Microsoft Windows operating system and its basic functions as well as basic knowledge of relational databases are required. You will also have practical knowledge of Transact-SQL.
Additional info:
The concepts and skills acquired in the course apply to all SQL Server versions (2012-2022).
- You will receive a practical introduction to the concepts and skills required to get started with the administration of SQL Server On-Prem.
- The focus is on the key areas of security, backup/restore and job engine with a hands-on approach (skills apply to all SQL Server versions from 2012 to 2022).
- Tools such as SQL Server Management Studio, Azure Data Studio and the sqlcmd utility are used.
This course consists of training training and is led by a trainer who supervises the participants live. Theory and practice are taught with live demonstrations and practical exercises. The video conferencing software Zoom is used.
The primary audience for this course is individuals who want a solid introduction to managing and maintaining SQL Server on-prem databases.
The secondary target audience for this course is individuals who develop applications that serve content from SQL Server databases.
.svg)
