Microsoft MCSE MCITP Dual Certification Training
 Our Dual MCSE MCITP Certification training brings you the best of two worlds.
Microsoft Certified IT Professional: Database Administrator (MCITP: Database Administrator) is the premier certification for database server administrators. This
certification training teaches you to maintain your enterprise business solutions 24 hours a day, 7 days a week. With the MCSE added you will also have the
knowledge to maintain Windows 2003 Enterprise Servers as well.
Being a Database administrators you will learn to install, configure Microsoft SQL Server and manage or maintain databases or multidimensional databases,
user accounts, database availability, recovery, and reporting. Your training will also teach you to design and implement security or server automation and monitor
and troubleshoot SQL Server activity. Database administrators are typically employed by mid-size to large organizations.
MCSE MCITP Training Includes
- Exam 70–290: Managing and Maintaining a Microsoft Windows Server 2003 Environment
- Exam 70-291: Implementing, Managing, and Maintaining a Windows Server 2003 Network Infrastructure
- Exam 70-293: Planning and Maintaining a Windows Server 2003 Network Infrastructure
- Exam 70-294: Planning, Implementing, and Maintaining a Windows Server 2003 Active Directory Infrastructure
- Exam 70-270: Installing, Configuring, and Administering Microsoft Windows XP Professional
or
Exam 70–620: TS: Microsoft Windows Vista, Configuring
- Exam 70-298: Designing Security for a Windows Server 2003 Network
- Exam 70–431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance
- Exam 70–443: PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
- Exam 70–444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005
We also offer Live Boot Camp Classes for MCSE and MCSA
Our Dual Certification Training Course
|
Multi
Media
|
Our training is done in a full multi-media flash format. Easy navigational interface allows you to find any subject matter in seconds.
|
|
Learn
and Do
|
Labs and interactive exercises are first shown to you and then allows you to perform them
|
|
Review
|
Our Training comes with printable transcripts -allowing easy review of any topic. Review questions throughout the training are used to test your level of comprehension
|
|
Exam
Preps
|
Online Simulated Certification Exams- Our test preps are online providing you the most updated questions possible.
|
|
Mentoring
|
Instructors available 24 x 7 online to answer any of your training questions
|
|
Course Hours
|
This courses has over 180+ hours of instructional lessons.
|
|
Pass
|
Our Guarantee to Pass. Call for details
|
|
Testimonials
|
List of Testimonials and Customers
|
|
Online Dual MCSE MCITP Training
One Year Access
|
knmcseiton
|
$825.00
|
|
|
CD-ROMS Dual MCSE MCITP Training
|
knmcseitcd
|
$995.00
|
|
How to earn your MCITP: Database Administrator
To earn this certification, you must pass three exams: one Microsoft Certified Technology Specialist (MCTS) prerequisite exam and two Professional Series exams.
There is a transition path of only two exams for a Microsoft Certified Database Administrator (MCDBA).
This certification requires a periodic update so that you can demonstrate your continued expertise in the latest technology and best practices.
You will learn to
Installing and Configuring SQL Server 2005
- 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 by using Microsoft SQL
Server 2005. 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 by
using Microsoft SQL Server 2005. 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 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.
|
