Course details
Introduction
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to maintaining a database.
Course Content
- Module 1: Introduction to SQL Server 2008 R2 and its Toolset
- Module 2: Preparing Systems for SQL Server 2008 R2
- Module 3: Installing and Configuring SQL Server 2008 R2
- Module 4: Working with Databases
- Module 5: Understanding SQL Server 2008 R2 Recovery ModelS
- Module 6: Backup of SQL Server 2008 R2 Databases
- Module 7: Restoring SQL Server 2008 R2 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 2008 R2 Management
- Module 14: Configuring Security for SQL Server Agent
- Module 15: Monitoring SQL Server 2008 R2 with Alerts and Notifications
- Module 16: Performing Ongoing Database Maintenance
- Module 17: Tracing Access to SQL Server 2008 R2
- Module 18: Monitoring SQL Server 2008 R2
- Module 19: Managing Multiple Servers
- Module 20: Troubleshooting Common SQL Server 2008 R2 Administrative Issues
Course Location
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 coursesSQL Server Related Questions
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Computer Programming: SQL, JavaScript & C++ NextGen LearningAED 999Duration: Upto 50 Hours
- Oracle 12c OCP 120-061: SQL Fundamentals Study 365AED 195Duration: Upto 16 Hours
