6315 : Designing, Optimizing, and Maintaining SQL Server 2008
  • Overview
  • Course Outline
  • What is included
  • Schedule
  • Testimonials
  • View Comments

This course is targeted at the database professional who wants to be SQL Server 2008 Database Administrator. It teach you to make appropriate design and technology choice considerations for your SQL Server 2008 installations.

Candidates for this course work in an environment in which Microsoft SQL Server 2008 is used for database solutions. Candidates should have at least three years of experience administering databases in an enterprise-level organization and designing, deploying, optimizing, maintaining, and supporting database service life cycle. Candidates should also have experience with the following:
  • Defining high-availability solutions
  • Data distribution
  • Automating administrative tasks (for example, checking db stats, backups)
  • Maintaining administrative tasks (for example, determining index rebuild time, file groups for backup)
  • Defining security solutions
  • Monitoring and troubleshooting the database server
  • Performance optimization (for example, physical tuning, including hardware, operating system, instance-level tuning), PerfMon
  • Designing and executing deployments
  • Deployments and migration
  • Defining the infrastructure (for example, storage, hardware, and number of servers or instances)
Next Course Offer
  • Designing a SQL Server Instance and a Database Solution
  •  Designing a Database Server Security Solution
  •  Designing a Database Solution for High Availability
  •  Designing a Backup and Recovery Solution
  •  Designing a Monitoring Strategy
  •  Designing a Strategy to Maintain and Manage Databases
  •  Designing a Strategy for Data Distribution

Special Price Feature List
  • Training Books