Course details

Overview

This course provides students with the knowledge and skills to design, optimize, and maintain a database administrative solution for Microsoft SQL Server 2008.

Who Should Attend

The primary audience of this course is IT professionals who design and maintain SQL Server databases. The audience can also comprise technical architects and consultants who design and implement SQL Server solutions. Students taking this course are expected to have three or more years of experience working on databases for two or more of the following phases in the product lifecycle - design, development, deployment, optimization, maintenance, or support.

Outline

  • Lesson 1: Designing an Administrative Solution for SQL Server 2008
  • Lesson 2: Deploying SQL Server 2008
  • Lesson 3: Designing the Physical Structure of SQL Server 2008
  • Lesson 4: Designing a Strategy for Maintaining a Database in SQL Server 2008
  • Lesson 5: Designing Solutions for Managing SQL Server 2008
  • Lesson 6: Automating the Database Management Strategy for SQL Server 2008
  • Lesson 7: Designing a Strategy for Securing SQL Server 2008
  • Lesson 8: Designing a Strategy for Monitoring SQL Server 2008
  • Lesson 9: Designing a Strategy for Content Distribution in SQL Server 2008
  • Lesson 10: Designing a Strategy for Replication in SQL Server 2008
  • Lesson 11: Designing a High-Availability Solution for SQL Server 2008
  • Lesson 12: Designing a Backup and Recovery Strategy for SQL Server 2008
Updated on 08 November, 2015

About IT & Business Consulting Group

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
Are you from IT & Business Consulting Group ? 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?

Rate this page

Didn't find what you were looking for ?

or