
Administering a SQL Database
MS-764(4 days)
Administering a SQL Database
21.000 DKK
(excl. VAT)
- Home
- Databases, BI & SQL
- SQL Server
- Administering a SQL Database
Course calendar
Description
This course is designed for those who administer on-premises SQL Server environments, whether you work in operations, maintenance or performance optimization.
You'll learn to handle the core administration tasks in SQL Server, including installation, security, monitoring, backup and recovery. The course gives you the knowledge and tools you need to keep SQL Server running stably and securely in an on-premises infrastructure.
In the course, you'll learn how to:
- Authenticate and authorize users
- Assign server and database roles
- Authorize users to access resources
- Protect data with encryption and auditing features
- Work with recovery models and backup strategies
- Back up SQL Server databases
- Restore SQL Server databases
- Automate database administration
- Configure security for SQL Server Agent
- Manage alerts and notifications
- Administer SQL Server with PowerShell
- Trace access to SQL Server
- Monitor SQL Server
- Troubleshoot SQL Server
- Import and export data
You'll gain both the theoretical understanding and the practical experience you need through a combination of instruction and hands-on labs, so you're equipped to administer a SQL Server database infrastructure effectively.
Prerequisites
To get the most out of the course, we recommend experience or knowledge equivalent to:
Next steps
If you want to build on your skills, these may be relevant:
Module overview
This module describes SQL Server security models, logins, users, partially contained databases, and cross-server authorization.
Lessons
Authenticating Connections to SQL Server
Authorizing Logins to Connect to databases
Authorization Across Servers
Partially Contained Databases
Lab 1: SQL Server Security
Authenticating Connections to SQL Server
Authorizing Connections to databases
Authorization across server instances
Authorizing Connections to databases
This module explains how to use roles at the server and database level to manage user permissions.
Lessons
Working with Server Roles
Working with Fixed Database Roles
User-Defined Database Roles
Lab 1: Assigning Server and Database Roles
Using Server Roles
Using Database Roles
Using User-defined Database Roles & Application Roles
This module explains how to authorize users to access server and database roles. It also describes how to manage permissions at different levels in a SQL Server instance.
Lessons
Authorizing User Access to Objects
Authorizing Users to Execute Code
Configuring Permissions at the Schema Level
Lab 1: Authorizing Users to Access Resources
Assigning Fixed and User-Defined Server Roles
Managing Database Roles and Users
Configure Permissions at the Schema Level
This module describes the available options for auditing and how to manage audit features. It also describes how to configure and implement data encryption.
Lessons
Options for auditing data access in SQL Server
Implementing SQL Server Audit
Managing SQL Server Audit
Protecting Data with Encryption
Lab 1: Using Auditing and Encryption
Auditing with Temporal Tables
Using SQL Server Audit
View Audit Output
Using Dynamic Data Masking
In this module, you will learn how to use the available backup features for databases and transaction logs to create backup strategies.
Lessons
Understanding Backup Strategies
SQL Server Transaction Logs
Planning Backup Strategies
Lab 1: Understanding SQL Server Recovery Models
Backup Databases
Transaction Log Backups
Shrinking a database
In this module, you will learn how to apply various backup strategies.
Lessons
Backing Up Databases and Transaction Logs
Managing Database Backups
Advanced Database Options
Lab 1: Backing Up Databases
Backing Up Databases
Verifying Backups
Using Advanced Backup Features
In this module, you will see how to restore user and system databases and how to implement point-in-time recovery.
Lessons
Understanding the Restore Process
Restoring Databases
Advanced Restore Scenarios
Point-in-Time Recovery
Lab 1: Restoring SQL Server Databases
Determining the order of restores
Restoring databases
Restore encrypted backup
Point-in-Time restore
This module describes how to use SQL Server Agent to automate jobs, how to configure security contexts for jobs, and how to implement multi-server jobs.
Lessons
Automating SQL Server management
Working with SQL Server Agent
Managing SQL Server Agent Jobs
Multi-server Management
Lab 1: Automating SQL Server Management
Using SQL Server Agent
Scripting SQL Server Agent jobs
Viewing job history
Multimaster management
This module explains how to configure SQL Server Agent to use a minimal privilege security environment and how to use credentials and proxy accounts to run jobs securely.
Lessons
Understanding SQL Server Agent Security
Configuring Credentials
Configuring Proxy Accounts
Lab 1: Configuring SQL Server Agent
Assigning a security context to job steps
Create credentials
Create a proxy account
This module covers the configuration of Database Mail, alerts, and notifications for a SQL Server instance, and the configuration of alerts for Microsoft Azure SQL Database.
Lessons
Monitoring SQL Server Errors
Configuring Database Mail
Operators, Alerts, and Notifications
Alerts in Azure SQL Database
Lab 1: Monitoring SQL Server with Alerts and Notifications
Working with Database Engine Error Logs
Configuring Database Mail
Configure Operators and Alerts
Configuring Alerts in Azure SQL Database (Optional)
This module explains how to use Windows PowerShell with Microsoft SQL Server and Azure SQL Database. It also describes how to improve efficiency and reliability by scripting tasks and jobs.
Lessons
Getting Started with Windows PowerShell
Configure SQL Server using PowerShell
Administer and Maintain SQL Server with PowerShell
Managing Azure SQL Databases using PowerShell
Lab 1: Using PowerShell to Manage SQL Server
Exploring SQL Server Management Objects (SMOs)
Configure database and Instance features with PowerShell
Manage logins and backups with PowerShell
Create an Azure SQL Database with PowerShell
Free course advice
We care a lot about helping you find the course path that creates the most value for you and your workplace. Get in touch with our course advisors — they're ready to help you, free of charge and with no obligation.

I can't give anything less than 5 stars across the board. Either you're truly in a class of your own, or I've just been to the wrong course venues before. Fantastic place and atmosphere.... once you've learned to find your way around :-)
Your instructors are exceptional; skilled, competent and good at teaching - so you have everything you need to get off to a good start.
You have fantastic facilities, good food and lovely people throughout the building.
A really good, in-depth course. Your course facilities at Karlebogaard are nothing short of fantastic. A beautiful historic house with lots of fun stories and great course rooms. The course itself was very useful. I learned everything I had hoped to and then some. My instructor was damn good and really funny. He made it a pleasure, and the hours flew by.
Probably the best course I've ever taken and the best instructor I've ever had!! Really good depth and thorough explanations, and on top of that, fantastic food!!!
Delicious food, cozy facilities, good structure and atmosphere. I'll be back when I can.
Absolutely the best course I've ever taken!
The course venue is so inviting and welcoming that it has been a pleasure to be here. Clean, tidy and full of charm. I attended a course where all the individual parts came together into a greater whole that can hardly be described.
I got a lot out of the course. It opened my eyes to possibilities I didn't know existed. I'm sure this won't be the last time we're in touch with SuperUsers.
I never in my wildest dreams imagined that a course venue could be so beautiful. I don't know if it's true, but I have a feeling that the surroundings rub off on the people who work here, so everyone seems incredibly happy.
There's a really great atmosphere. All the way from the woman at the reception desk to the people who work in the kitchen.
The instructor tailored the course to my level to a very large extent and was flexible. I had very high expectations, and they were exceeded.
Great precision, good exercises, good pace, a great atmosphere and maximum learning.
The instructor was very pleasant and the exercises were extremely good. I really learned a lot about the topics the course covered.
On top of that, really nice, calm and green surroundings with good catering - especially good food. I would like to take my courses here again next time.
It was a real pleasure to take a course at SuperUsers. The week we spent on the course was worth the money and means that we can now save many consultant hours. It's always nice to have the knowledge in-house.
There is a relaxed atmosphere in the classroom, lovely surroundings in the building itself, and skilled instructors who do a really good job.
I started using all the knowledge I soaked up on the course almost right away, and now we are well underway with developing our future cloud solution.
There is no doubt about who we will turn to if we need other courses.
This is my first time at SuperUsers. It has been a really good experience. The instructor seems very experienced and competent.
The instructor's strong technical background made the course and the in-depth answers to questions a good experience.
A really nice course venue in pleasant surroundings that make for a good setting for focused learning. The instructor came across as well prepared, with extensive knowledge of the relevant topics.
The instructor also showed a strong ability to answer any questions that came up during the course.
I'll be back the next time I need to take a course. It's a lovely place, the food is fantastic, and the instructor is very knowledgeable and happy to share that knowledge!
The technical depth of the course was really good. The instructor's knowledge went much deeper than the curriculum necessarily requires.
You could throw all kinds of curveballs at the instructor, and he had it all under control - he also made the content exciting.
We have now completed Microsoft 365 courses for a total of 5 people here in our department. Everyone agrees that it was an excellent course with a skilled instructor and communicator who could discuss and explain things at the right level, while also being efficient and bringing humor.
It has been a really good experience.
It's calm and quiet at SuperUsers' country venue. Good atmosphere and catering. Some thought has gone into healthy eating when it comes to food and cake, so it doesn't get completely out of hand.
The instructor is knowledgeable about the topics and readily puts them in a broader perspective by relating them to other relevant areas. It's rewarding that this is possible too, and it gives you ideas for further study.
In addition, the instructor was engaged and entertaining to have presenting the content.
As always, it was a great experience, and you learn a lot in a short time from some very skilled instructors.
I work in Azure almost every day, and both courses have been really good at helping me understand Azure better.
The instructor is very presentation-oriented and gets you involved in the teaching and the material. He is good at varying the teaching so it never gets monotonous.
It is clear that the instructor has hands-on experience and not just the theory, with many good examples that related to real-world challenges we might encounter.
Good facilities and good food, without drowning in unhealthy habits.
Very good course, the instructor was the best. I've been here at SuperUsers before, now I'm here again, and hopefully coming back another time.
The instructor seemed very competent and has extensive knowledge of his field. He was good at explaining things in a clear and humorous way. There were also simple exercises that gave a good understanding.
The instructor was really good at going in depth while still making sure everyone was keeping up. A really nice venue and room, and great food.
There was no doubt that the instructor knew exactly what he was talking about, and even the simplest questions were answered gladly, without anyone being made to feel stupid.
A lovely, cozy place where the receptionist, the kitchen and the instructors make you feel at home. A good setting makes for good learning. Really good food that helps round out the whole experience of taking a course at SuperUsers.
Really happy with the venue and the stay over in the horse stable. I'll see if I can come back here for the next course I take. A really beautiful building, and great to experience a place like this. A fantastic place to hold a course.