 MCITP  Database Administrator (DBA) SQL Server 2005 Boot Camp
 Microsoft Certified IT Professional: Database Administrator (MCITP: DBA) Boot Camp for SQL Server 2005 is the premier certification for database server administrators. The certification confirms that you are fully qualified to manage your enterprise business solutions.
The MCITP: DBA certification is recognized as a prestigious credential indicating the database administrator's skill level The primary responsibilities of the database administrator is: to install or configure Microsoft SQL Server and manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting. Additionally, they also design or implement security or server automation and monitor and troubleshoot SQL Server activity
During the 10-day MCITP: DBA SQL 2005 Boot Camp, you will take the following exams:
Prerequisites
Basic Knowledge of Microsoft Windows operating system and its core functionality, working knowledge of Transact_SQL, working knowledge of relational databases, some experience with database design
Our MCITP: Database Administrator Certification Program includes:
- Intensive Hands-on Training by Microsoft Certified Trainers utilizing our (Lecture | Lab | Review)™ Delivery.
- Blended-Learning Instruction comprised of comprehensive study materials and pre-class mentoring, customized Microsoft Official Curriculum, comprehensive lab manuals, and Self-Test Testing Software
- Deluxe Package of Ten (10) Days of Hotel Accommodations, Breakfast and Lunch, Unlimited Beverages, Snacks, and Freshly-brewed Coffee.
- 24-Hour Lab and Instructor Access.
- Examination Vouchers & On-site Certification Testing.
- Examination Passing Policy.
MCITP DBA SQL Server 2005 Schedule for 2010
1/4/2010 1/17/2010
San Francisco, CA
1/18/2010 1/31/2010
Bushkill, PA
2/1/2010 2/14/2010
Los Angeles Metro
2/15/2010 2/28/2010
Washington, D.C. Metro
3/1/2010 3/14/2010
Bushkill, PA
3/15/2010 3/28/2010
Chicago, IL
4/12/2010 4/25/2010
Dallas, TX
4/26/2010 5/9/2010
Bushkill, PA
5/10/2010 5/23/2010
San Francisco, CA
5/24/2010 6/6/2010
Orlando, FL
6/7/2010 6/20/2010
Bushkill, PA
7/12/2010 7/25/2010
Atlanta, GA
7/26/2010 8/8/2010
Bushkill, PA
8/9/2010 8/22/2010
Los Angeles Metro
8/23/2010 9/5/2010
Chicago, IL
9/6/2010 9/19/2010
Bushkill, PA
9/20/2010 10/3/2010
Washington, D.C. Metro
10/4/2010 10/17/2010
Dallas, TX
10/18/2010 10/31/2010
San Francisco, CA
11/1/2010 11/14/2010
Bushkill, PA
11/29/2010 12/12/2010
Los Angeles Metro
Curriculum
Day 1 Writing Queries Using Microsoft SQL Server 2005 Transact-SQL
Day 2 Implementing a Microsoft SQL Server 2005 Database
Day 3 Maintaining a Microsoft SQL Server 2005 Database
Day 4 Introduction to SQL Server Services
Day 5 EXAM: MCTS SQL Server 2005 Implementation and Maintenance 70-431
Day 6 Designing a Microsoft SQL Server 2005 Infrastructure. Designing Security for Microsoft SQL Server 2005
Day 7 Designing High Availability Database Solutions Using Microsoft SQL Server
Day 8 EXAM: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 70-443
Day 9 Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005
Day 10 EXAM: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 70-444
Exam 70-431- MCTS SQL Server 2005 Implementation and Maintenance
Installing and Configuring SQL Server 2005
Install SQL Server 2005.
Configure SQL Server 2005 instances and databases.
Configure SQL Server security.
Configure linked servers by using SQL Server Management Studio (SSMS).
Implementing High Availability and Disaster Recovery
Implement database mirroring.
Implement log shipping.
Manage database snapshots.
Supporting Data Consumers
Retrieve data to support ad hoc and recurring queries.
Manipulate relational data.
Manage XML data.
Implement an HTTP endpoint.
Implement Service Broker components.
Import and export data from a file.
Manage replication.
Maintaining Databases
Implement and maintain SQL Server Agent jobs.
Manage databases by using Transact-SQL.
Back up a database.
Restore a database.
Move a database between servers.
Monitoring and Troubleshooting SQL Server Performance
Gather performance and optimization data by using the SQL Server Profiler.
Gather performance and optimization data by using the Database Engine Tuning Advisor.
Monitor and resolve blocks and deadlocks.
Diagnose and resolve database server errors.
Monitor SQL Server Agent job history.
Gather performance and optimization data by using DMVs.
Creating and Implementing Database Objects
Implement a table.
Implement a view.
Implement triggers.
Implement functions.
Implement stored procedures.
Implement constraints.
Implement indexes.
Create user-defined types.
Implement a full-text search.
Implement partitions.
Exam 70-443 - Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
Designing a Database Server Infrastructure
Design for capacity requirements.
Specify software versions and hardware configurations.
Design physical storage.
Design instances.
Design a database consolidation strategy.
Designing Security for a Database Server Solution
Analyze business requirements.
Integrate database security with enterprise-level authentication systems.
Develop Microsoft Windows server-level security policies.
Modify the security design based on the impact of network security policies.
Analyze the risk of attacks to the server environment and specify mitigations.
Design SQL Server service-level security.
Design database-level security.
Design object-level security.
Designing a Physical Database
Modify an existing database design based on performance and business requirements.
Design tables.
Design file groups.
Design index usage.
Design views.
Create database conventions and standards.
Create database change control procedures.
Designing a Database Solution for High Availability
Select high-availability technologies based on business requirements.
Develop a strategy for migration to a highly available environment.
Design a highly available database storage solution.
Design a database-clustering solution.
Design database mirroring.
Design a high-availability solution that is based on replication.
Design log shipping.
Designing a Data Recovery Solution for a Database
Specify data recovery technologies based on business requirements.
Design backup strategies.
Create a disaster recovery plan.
Designing a Strategy for Data Archiving
Select archiving techniques based on business requirements.
Design the format of archival data.
Specify what data to archive.
Plan for data archival and access.
Design the topology of replication for archiving data.
Design the type of replication for archiving data.
Exam 70-444 Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005
Optimizing the Performance of Database Servers and Databases
Troubleshoot physical server performance.
Troubleshoot instance performance.
Troubleshoot database performance.
Troubleshoot and maintain query performance.
Troubleshoot concurrency issues.
Optimizing and Implementing a Data Recovery Plan for a Database
Diagnose causes of failures. Failure types include database failures, physical server failures, and SQL Server service failures.
Plan for fault-tolerance.
Recover from a failure of SQL Server 2005.
Recover from a database disaster.
Salvage good data from a damaged database by using restoration techniques.
Designing a Strategy to Monitor and Maintain a Database Solution
Define and implement monitoring standards for a physical server.
Choose the appropriate information to monitor.
Create and implement a maintenance strategy for database servers.
Design a database maintenance plan.
Design a strategy to manage Reporting Services.
Designing a Database Data Management Strategy
Design and manage SQL Server Integration Services (SSIS) packages.
Enforce data quality according to business requirements.
Design data integrity.
Design a strategy to manage data across linked servers.
Design a strategy to manage replication.
Optimize a database control strategy to meet business requirements.
Designing a Strategy to Manage and Maintain Database Security
Perform a security audit of the existing security infrastructure based on the security plan.
Maintain a server-level security strategy.
Maintain a user-level security strategy.
Prepare for respond to threats and attacks.
|
