• This 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.

Who Should Attend

  • The primary audience for this course is individuals who administer and maintain SQL Server databases. This course can also be helpful for individuals who develop applications that deliver content from SQL Server databases.


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

Whether you need a one-day onsite training course, full-service consulting, or if you are not really sure which solution will work, we can help.
ITBCG is a leading and innovative learning provider with over twenty years’ experience of providing best in-class learning solutions. We work in partnership with our customers to deliver flexibility, value and service. We develop innovative programs to ensure that every aspect of the learning development, delivery and administration of courses work to our clients’ benefit.
We provide IT and business skills learning to both the private and public sector companies and organizations. Our core training is focused on Cisco, Microsoft, CompTIA Citrix, EC-Council, Oracle, and ISC2 and best practice. This includes ITIL® Service Management and ISO, and PMI which is tied into business process improvement, project management, and business analysis and leadership development.
See all IT & Business Consulting Group courses

Contact information not available.

Courses you can instantly connect with...
Querying Microsoft SQL Server New Horizons Egypt Mastering PHP & MySQL Helper Learning MCTS: SQL Server 2008, Database Development Helper Learning

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?