Administering a SQL Database
Course M55316
Course M55316
This five-day course provides delegates who manage SQL Server and Azure SQL databases with the knowledge and skills required to manage a SQL Server database infrastructure. The course is also aimed at people who develop applications that deliver content from SQL Server databases. This material updates and replaces course MOC20764.
Pn this course, participants will gain the following skills:
SQL Server Security
Assigning server and database roles
Authorising users to access resources
Protecting data with encryption and auditing
Recovery models and backup strategies
Backing up SQL Server databases
Restoring SQL Server Databases
Automating SQL Server Management
Configuring security for the SQL Server Agent
Monitoring SQL Server with alarms and notifications
Introduction to managing SQL Server using PowerShell
Tracking Access to SQL Server with Advanced Events
Monitoring SQL Server
Troubleshooting SQL Server
Import and export data
This course is primarily aimed at people who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility or work in environments where databases play a key role in their primary job.
The secondary audience for this course is individuals who develop applications that deliver content from SQL Server databases.
The course price includes:
- Training materials in English and digital form
- Refreshments during breaks in the classroom training: drinks, pastries and lunch.
We are also happy to conduct this training as an in-house seminar. Please request your individual offer.
The course is offered in German and English.
SoftwareONE
IT CAMPUS
Customer Training Solutions