Microsoft MCIPT Certification Training Optimizing Data Access for SQL 2005 70-444 Exam
 This MCITP Certification course contains training for Designing and
Optimizing Data Access By Using Microsoft SQL 2005 Training Exam 70-444
MCITP Certification path
MCITP candidates must first complete the requirements for the MCTS: SQL Server 2005 credential (one exam – 70-431). After earning this credential, candidates earn their MCITP: Database Developer by passing two required exams 70-443 & 70-444
Microsoft Certified IT Professional: Database Developer (MCITP: Database Developer) is the premier certification for database designers and developers. This credential demonstrates that you can design a
secure, stable, enterprise database solution by using Microsoft SQL Server 2005.
MCITP Course Designing and Optimizing Data Access By Using Microsoft SQL 2005 Training Exam 70-444
Our Training Course
- Full multi-media interactive training
- Available in CD-ROM or Online formats
- Learn at your own pace, anytime or anywhere
- Course time: 16 Hours
- Hands on interactive exercises
- 24 x 7 Online Mentoring Support to Trainer
- Practice Certification Exams
- MCITP Certification Information
After your training you will be able to:
- Optimizing SQL Server 2005 Performance.
- Optimizing a Database Data Recovery Plan.
- Monitoring and Maintaining a Database.
- Managing Data Between Servers and Databases.
- Managing and Maintaining Database Security.
- Managing Database Data in a SQL Server 2005 Environment
|
Online MCTS Microsoft SQL 70-444 Course One Year Access with Books
|
$245.00
|
sp444cd
|
|
|
CD-ROM MCTS Microsoft SQL 70-444 Course with Books
|
$295.00
|
sp444on
|
|
|
Online MCITP Certification Track Microsoft SQL 70-431, 70-443 and 70-444 courses with Books
|
$595.00
|
spmcipton
|
|
|
CD-ROM MCITP Certification Track Microsoft SQL 70-431, 70-443 and 70-444 courses with Books
|
$695.00
|
spmcipton
|
|
MCITP Course Content
Optimizing SQL Server 2005 Performance
- How to optimize server performance using memory configuration options.
- How to optimize server performance using I/O configuration options and Windows options.
- How to troubleshoot database performance in a given scenario.
- Training to troubleshoot the performance.
- Troubleshoot and analyze query performance.
- Optimize database indexes in a given scenario.
- How to optimize stored procedures in a given scenario.
- Considerations when managing concurrent data access in a given database scenario.
- Rroubleshoot query performance issues.
Optimizing a Database Data Recovery Plan
- Troubleshoot the causes of database failure in a given scenario.
- How to install failover clustering for high availability and fault tolerance.
- How to set up database mirroring for fault tolerance, given a scenario.
- Configure the appropriate fault tolerance plan for a scenario.
- Considerations for recovering from a database disaster in a given scenario.
- Implement the appropriate restore strategy to recover a database in a given scenario.
- How best to recover data following a given database disaster scenario.
Monitoring and Maintaining a Database Training
- The steps for establishing a performance baseline.
- SQL Server Profiler to monitor a database in a given scenario.
- How to tune a database using the Database Engine Tuning Advisor in a given scenario.
- Monitor and tune a database using SQL Server Profiler and Database Engine Tuning Advisor.
- How to automate database administration tasks using SQL Server Agent in a given scenario.
- How to create alerts and operators in a given scenario.
- Create and implement a database maintenance strategy for a given scenario.
- How to use the Maintenance Plan Wizard to automate database maintenance tasks.
- Manage reports.
- Configure reporting services.
Managing Data Between Servers and Databases
- Considerations for managing change in aenvironment.
- The appropriate change control strategy for a given scenario.
- How to configure a linked server in a given scenario.
- How to query data on a linked server.
- Work with linked serverso.
- How to monitor replication.
- How to modify replication configuration and resolve replication conflicts.
- Tune a replication configuration.
Managing and Maintaining Database Security
- Identify an appropriate strategy for auditing access to SQL Server at the server level.
- Considerations for choosing an encryption algorithm, and recognize how to use the Microsoft Baseline Security Analyzer and SQL Server Surface Area Configuration tools to secure SQL Server.
- Determine an appropriate strategy for monitoring and auditing access
- Strategies for auditing user access to SQL Server in a given scenario.
- How to verify account policies and user accounts.
- Use stored procedures and views to verify account policy and user account information.
- How to protect SQL Server against SQL injection and DoS attacks.
- How to protect Server against viruses, worms, and internal attacks.
- How to protect against and respond to attacks.
Managing Database Data
- How to create an SSIS package in a given scenario.
- How to run, configure, and troubleshoot SSIS packages in a given scenario.
- How to use DML and DDL triggers to enforce data quality.
- How to configure the page_verify option to enforce data quality.
- Configure database options to enforce data quality.
- How data types are used to enforce data integrity.
- How to enforce data integrity using constraints.
- Enforce data integrity within a database.
|
