Training Syllabus

NCMCITP002 - MCITP 70-450 Designing Optimizing and Maintaining SQL Server 2008 Database

 

Durasi : 5 hari

  • Overview of SQL Server 2008
  • Designing an Administrative Solution
  • System Requirements for SQL Server 2008
  • Configuring Instances in SQL Server 2008
  • Planning for Database Files and Transaction Logs
  • Planning for Partitioning
  • Designing a Strategy for Maintaining a Database
  • Designing a Policy-Based Management Strategy
  • Controlling Resource Usage by Using Resource Governor
  • Managing SQL Server Agent
  • Automating Administrative Tasks in SQL Server
  • Securing SQL Server 2008 Instances
  • Planning Database Security
  • Overview of Monitoring SQL Server 2008
  • Monitoring SQL Server Instances
  • Distributing Data in SQL Server 2008
  • Working with Distributed Queries