Introduction to SQL Server DBA Certificate


(更多资料和具体参加方法) 
 
Microsoft Certified IT Professional - Database Administrator (MCITP-DBA)
Course Outline
 
1. Introduction
1.1. Benefits of Obtaining MCITP SQL Server 2008 DBA Certificate
 
1.2. MCITP SQL Server 2008 DBA Certificate Path
 
- MCTS (Microsoft Certified Technology Specialist)
- MCITP (Microsoft Certified IT Professional)
- Upgrade: Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008 DBA
 
1.3. MCTS: SQL Server 2008, Implementation and Maintenance (70-432)
 
- Working with SQL Server 2008 for database administrator tasks: installing, configuring & maintaining
 
1.4. MCITP: Database Administrator 2008 (70-450)
 
- Designing, Optimizing and Maintaining a Database Server Infrastructure using SQL Server 2008
 
1.5. Upgrade (70-453)
 
- Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008 DBA
 
1.6. How to Prepare and Take MCTS/MCITP Exams
 
1.7. SQL Server 2008 New Features
 
 
2. MCTS - SQL Server 2008, Implementation and Maintenance
 
2.1. Installing and Configuring SQL Server 2008
 
- Install SQL Server 2008 and related services
- Configure SQL Server instances
- Configure SQL Server services
- Configure additional SQL Server components
- Implement database mail
- Configure full-text indexing
 
2.2. Maintaining SQL Server Instances
 
- Manage SQL Server Agent jobs
- Manage SQL Server Agent alerts
- Manage SQL Server Agent operators
- Implement the declarative management framework (DMF)
- Back up a SQL Server environment
 
2.3. Managing SQL Server Security
 
- Manage logins and server roles
- Manage users and database roles
- Manage SQL Server instance permissions
- Manage database permissions
- Manage schema permissions and object permissions
- Audit SQL Server instances
- Manage transparent data encryption
- Configure surface area
 
2.4. Maintaining a SQL Server Database
 
- Back up databases
- Restore databases
- Manage and configure databases
- Manage database snapshots
- Maintain database integrity
- Maintain a database by using maintenance plans
 
2.5. Performing Data Management Tasks
 
- Import and export data
- Manage data partitions
- Implement data compression
- Maintain indexes
- Manage collations
 
2.6. Monitoring and Troubleshooting SQL Server
 
- Identify SQL Server service problems
- Identify concurrency problems
- Identify SQL Agent job execution problems
- Locate error information
 
2.7. Optimizing SQL Server Performance
 
- Implement Resource Governor
- Use the Database Engine Tuning Advisor
- Collect trace data by using SQL Server Profiler
- Collect performance data by using Dynamic Management Views (DMVs)
- Collect performance data by using System Monitor
- Use Performance Studio
 
2.8. Implementing High Availability
 
- Implement database mirroring
- Implement a SQL Server clustered instance
- Implement log shipping
- Implement replication
 
3. MCITP - Database Administrator
 
            Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008
           
   3.1. Designing a SQL Server Instance and a Database Solution
 
- Design for CPU, memory, and storage capacity requirements
- Design SQL Server instances
- Design physical database and object placement
- Design a migration, consolidation, and upgrade strategy
 
3.2. Designing a Database Server Security Solution
 
- Design instance authentication
- Design instance-level security configurations
- Design database, schema, and object security parameters
- Design a security policy and an audit plan
- Design an encryption strategy
 
3.3. Designing a Database Solution for High Availability
 
- Design a failover clustering solution
- Design database mirroring
- Design a high-availability solution that is based on replication
- Design a high-availability solution that is based on log shipping
- Select high-availability technologies based on business requirements
 
3.4. Designing a Backup and Recovery Solution
 
- Design a backup strategy
- Design a recovery strategy
- Design a recovery test plan
 
3.5. Designing a Monitoring Strategy
 
- Design a monitoring solution at the operating system level
- Design a monitoring solution at the instance level
- Design a solution to monitor performance and concurrency
 
3.6. Designing a Strategy to Maintain and Manage Databases
 
- Design a maintenance strategy for database servers
- Design a solution to govern resources
- Design policies by using Policy-Based Management
- Design a data compression strategy
- Design a management automation strategy
 
3.7. Designing a Strategy for Data Distribution
 
- Administer SQL Server Integration Services (SSIS) packages
- Design a strategy to use linked servers
- Design a replication strategy for data distribution
 

(更多资料和具体参加方法)
本页最后更新: | -- | 网站设计和虚拟主机服务 WECAN.ca CMS