Training for Microsoft MCITP Database Administrator DBA Boot Camp Class for Microsoft SQL 2005 Certification
 Microsoft Certified IT Professional Database Administrator MCITP Boot Camp
class for SQL Server 2005 is the premier certification for database server administrators. This training confirms that you are fully qualified to manage your enterprise business solutions.
Certified Database administrators MCITP need to know how to install or configure Microsoft SQL Server and manage or maintain databases or multidimensional
databases, user accounts, database availability, recovery, and reporting. They also design or implement security or server automation and monitor and
troubleshoot SQL Server activity. This course proves that you have what it takes in a competitive and ever-changing IT landscape.
Our MCITP Certification DBA program is a lab-intensive, residential course, designed for information technology professionals that require effective, real-world
skill-building and timely certification. You will live, learn, and test on-site.
Our Certification DBA Class:
- Allows you to achieve your certification in a fraction of the time of 'traditional training' while delivering industry-leading exam passing percentages.
- Helps students grasp complex technical concepts more easily by identifying and catering to individual student learning styles through a mixed visual, auditory and kinesthetic-tactual delivery system.
- Enhances retention by employing accelerated learning techniques focused on committing information to long-term memory.
Our Boot Camp offers the highest quality technical education in an all-inclusive course package specifically designed
for the needs and ease of our students. We attend to every detail so our students can focus solely on their educational objectives.
Our Microsoft MCITP Database Administrator Accelerated 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 Five (5) 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 for Database Administration DBA.
- Examination Passing Policy.
- Out Boot Camp Class has dedicated, well-equipped educational facilities where you will attend instruction and labs and have access to comfortable study and lounging rooms.
- Our Microsoft Certified Trainers teach to accommodate every student's learning needs through individualized
instruction, hands-on labs, lab partner and group exercises, independent study, self-testing, question and answer drills, and friendly competitions between concurrently running classes.
- Students will have 24-hour access to quality personal workstations, audiovisual equipment, supplies, and lab equipment.
- Examination Passing Policy. Should a student complete our Boot Camp Program without having successfully
passed all vendor examinations, the student may re-attend that program for a period of one year. Students will only be responsible for accommodation and vendor exam fees.
Students who are successful in accelerated SQL 2005 certification training may possess:
- 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 Boot Camp is an intense training environment. You must have an attitude aimed for success. The above
prerequisites are guidelines, but many students with less experience have other background or traits that have enabled their success in accelerated training through our classes.
Boot Camp Class Curriculum
|
Days
|
MCITP Module Description
|
Exam
|
|
1
|
Writing Queries
|
|
|
2
|
Implementing a Microsoft SQL Server 2005 Database
|
|
|
3
|
Maintaining a Microsoft SQL Server 2005 Database
|
|
|
4
|
Introduction to SQL Server Services
|
|
|
5
|
EXAM: MCTS SQL Implementation and Maintenance
|
70-431
|
|
6
|
Designing a infrastructure. Designing Security
|
|
|
7
|
Designing High Availability Database Solutions
|
|
|
8
|
EXAM: Designing a Database Server Infrastructure
|
70-443
|
|
9
|
Troubleshooting and Optimizing Database Servers
|
|
|
10
|
EXAM: Optimizing and Maintaining a Database Administration Solution by
|
70-444
|
|
Installing and Configuring
- Install SQL Server 2005.
- Configure 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.
The 70-443 certification exam measures your ability to design a database server infrastructure. This program shall prepare students in the job skills listed in the following matrix:
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.
The 70-444 certification exam measures your ability to optimize and maintain a database administration solution. This program shall prepare students in the job skills listed in the following matrix:
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 Databases
- 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.
Boot Camp Class Schedule
5/10/2010 5/19/2010
Denver, CO
Philadelphia, PA
|
