SQL Server Training

SQL Server Training

Designing, Optimizing, and Maintaining a Database Administrative Solution for Microsoft SQL Server 2008

Microsoft 50400

Microsoft Certification

Length: 5 Days
Published: June 01, 2010
Language(s): English
Audience(s): IT Professionals
Level: 300
Technology: Microsoft SQL Server 2008
Type: Course
Delivery Method: Instructor-led (classroom)
About this Course
This five-day instructor-led course provides the knowledge and skills to design, optimize, and maintain a database administrative solution for Microsoft SQL Server 2008.
Audience Profile
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.
The students should have experience in the following areas:
  • Administering databases
  • Designing logical database schema solutions
  • Defining high-availability solutions
  • Automating administrative tasks
  • Defining security solutions
  • Monitoring and troubleshooting the database server
  • Designing and executing deployments
  • Defining the infrastructure (storage, hardware, and number of servers or instances, etc.)
At Course Completion
After completing this course, students will be able to:
  • Implement an administrative solution for SQL Server 2008.
  • Deploy SQL Server 2008.
  • Design the physical structure for SQL Server 2008.
  • Design a strategy for maintaining SQL Server 2008.
  • Design a strategy for managing SQL Server 2008.
  • Automate the database managing strategy for SQL Server 2008.
  • Design a strategy for securing databases in SQL Server 2008.
  • Design a strategy for monitoring SQL Server 2008.
  • Design a strategy for content distribution in SQL Server 2008.
  • Design a strategy for replication in SQL Server 2008.
  • Design a high availability solution for SQL Server 2008.
  • Design a strategy for backup and recovery in SQL Server 2008.
Microsoft Training Discount Price Match Guarantee Microsoft Training Locations Redeem your Microsoft Training Vouchers here!