Administering a SQL Database Infrastructure

Product information

IT

Reviews

4 out of 5 stars

(no reviews)

Level: Certificate

Inquire Now

Entry Requirement

Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of Transact-SQL. Working knowledge of relational databases. Some experience with database design.

Course Content

  • SQL Server Security
  • Assigning Server and Database Roles
  • Authorizing Users to Access Resources
  • Protecting Data with Encryption and Auditing
  • Recovery Models and Backup Strategies
  • Recovery Models and Backup Strategies
  • Restoring SQL Server 2016 Databases
  • Automating SQL Server Management
  • Configuring Security for SQL Server Agent
  • Monitoring SQL Server with Alerts and Notifications
  • Introduction to Managing SQL Server by using PowerShell
  • Tracing Access to SQL Server with Extended events
  • Monitoring SQL Server
  • Troubleshooting SQL Server
  • Importing and Exporting Data

Share

Inquire Now

Student Reviews

Share your thoughts

If you’ve follow this course, share your thoughts with other students.

Login to Write a review

Write your review

Please make sure the review is genuine and related to the course.

Related Courses