Course details

Introduction

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additional it will be of use to individuals who develop applications that deliver content from SQL Server databases.

Course Content

  • Module 1: Authenticating and Authorizing Users
  • Module 2: Assigning Server and Database Roles
  • Module 3: Authorizing Users to Access Resources
  • Module 4: Protecting Data with Encryption and Auditing
  • Module 5: SQL Server Recovery Models
  • Module 6: Backup of SQL Server Databases
  • Module 7: Restoring SQL Server Databases
  • Module 8: Automating SQL Server Management
  • Module 9: Configuring Security for SQL Server Agent
  • Module 10: Monitoring SQL Server with Alerts and Notifications
  • Module 11: Introduction to Managing SQL Server by using PowerShell
  • Module 12: Tracing Access to SQL Server
  • Module 13: Monitoring SQL Server
  • Module 14: Troubleshooting SQL Server
  • Module 15: Importing and Exporting Data
Updated on 01 September, 2016

About Torque IT

About Torque IT

With over 20 years of experience, Torque IT is recognised throughout the globe as the principal InformationCommunication Technology (ICT) training solutions provider to blue chip companies and the public sector.

The Torque IT business is based on a culture of customer service and an unwavering commitment to always providing the highest quality product and service available. Torque IT offers completely customizable training and enablement solutions that are tailored to your specific requirements whilst retaining the quality and credibility associated with standard vendor authorized training courses. 

See all Torque IT courses
Are you from Torque IT ? Claim your course!
Courses you can instantly connect with... Do an online course on SQL Server starting now. See all courses

Is this the right course for you?

Didn't find what you were looking for ?

or