Course details

This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database.

Outline

  • Module 1: Introduction to SQL Server 2012 and its Toolset
  • Module 2: Preparing Systems for SQL Server 2012
  • Module 3: Installing and Configuring SQL Server 2012
  • Module 4: Working with Databases
  • Module 5: Understanding SQL Server 2012 Recovery Models
  • Module 6: Backup of SQL Server 2012 Databases
  • Module 7: Restoring SQL Server 2012 Databases
  • Module 8: Importing and Exporting Data
  • Module 9: Authenticating and Authorizing Users
  • Module 10: Assigning Server and Database Roles
  • Module 11: Authorizing Users to Access Resources
  • Module 12: Auditing SQL Server Environments
  • Module 13: Automating SQL Server 2012 Management
  • Module 14: Configuring Security for SQL Server Agent
  • Module 15: Monitoring SQL Server 2012 with Alerts and Notifications
  • Module 16: Performing Ongoing Database Maintenance
  • Module 17: Tracing Access to SQL Server 2012
  • Module 18: Monitoring SQL Server 2012
  • Module 19: Managing Multiple Servers
  • Module 20: Troubleshooting Common SQL Server 2012 Administrative Issues
Updated on 08 November, 2015

About HeroTec

Herotec is network professional training provider, founded 2007 to focus on IT professional training. 
Herotec provides professional training programs  at their premises or onsite training (client premises) 
their exclusive specialization in the field of IT & network professional training with both sectors) technical & management) gives us the advantage to be the leader in identifying unique training opportunities for both corporate & individuals. 
See all HeroTec courses
Are you from HeroTec ? Claim your course!
Courses you can instantly connect with... Do an online course on MCSA starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or