◊ MICROSOFT SQL SERVER 2005 ADMIN MCITP 70-444 ONLINE TRAINING SERIES
Online Microsoft SQL Server 2005 Admin MCITP 70-444 Training
Database » SQL Server
Check out these great money-saving course packages:
Only $99.95
Microsoft SQL Server 2005 Admin MCITP 70-444 Series (13 hours)
ONLINE COURSE FEATURES
- Learn online with these interactive online elearning courses.
- Affordable Pricing (Only $99.95 for the complete series)
- A full year to complete the elearning courses
- Retake the elearning courses as many times as you like
- Measure your progress with assessment tests after each elearning course
- Earn completion certificates after passing each assessment test
1. Optimizing the Performance of Databases and Database Servers
Time: 1 hours
This course covers optimizing database performance at the server, instance, and database levels.
Objectives
- Troubleshoot physical server performance
- Troubleshoot instance performance
- Troubleshoot database performance
2. Optimizing the Performance of Queries
Time: 1 hours
This course covers optimizing and maintaining query performance. It also addresses troubleshooting concurrency issues.
Objectives
- Identify poorly performing queries
- Analyze a query and plan to detect inefficiencies in query logic
- Maintain and optimize indexes
- Enforce appropriate stored procedure logging and output
3. Optimizing and Implementing a Data Recovery Plan for a Database
Time: 1 hours
This course covers optimizing and implementing a data recovery plan for databases.
Objectives
- Diagnose causes of failures
- Plan for fault-tolerance
- Recover from a database disaster
- Salvage good data from a damaged database by using restoration techniques
4. Designing a Strategy to Monitor a Database Solution
Time: 1 hours
This course covers designing monitoring strategies. It also addresses baselines, thresholds, and notifications.
Objectives
- Define and implement monitoring standards for a physical server
- Choose the appropriate information to monitor
5. Designing a Strategy to Maintain a Database Solution
Time: 1 hours
This course covers the design and implementation of a proactive maintenance solution that will ensure that your database solutions are optimal.
Objectives
- Create and implement a maintenance strategy for database servers
- Design a database maintenance plan
- Design a strategy to manage Reporting Services
6. Designing and Managing SSIS Packages
Time: 1 hours
This course covers designing and managing SSIS Packages.
Objectives
- Design and manage SAL Server Integration Services (SSIS) packages
7. Designing a Database Data Management Strategy
Time: 1 hours
This course covers enforcing data quality according to business requirements and designing for data integrity.
Objectives
- Enforce data quality according to business requirements
- Design data integrity
8. Designing a Strategy to Manage Replication
Time: 1 hours
This course covers recommendations for designing a replication management strategy.
Objectives
- Design a strategy to manage data across linked servers
Topics
- Design a strategy to manage replication
9. Protecting Your SQL Server from Attack
Time: 1 hours
This course covers considerations for protecting your SQL server.
Objectives
- Optimize a database control strategy to meet business requirements
- Perform a security audit of the existing security infrastructure based on the security plan
- Prepare for and respond to threats and attacks
10. Designing a Strategy to Manage and Maintain Database Security
Time: 1 hours
This course covers maintaining monitoring strategies at the server and user levels.
Objectives
- Maintain a server-level security strategy
- Maintain a user-level security strategy
11. Practice Exam 1
Time: 1 hours
This course presents questions that will help you prepare for the MCITP 70-444 PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.
Objectives
- Complete the practice exam questions
12. Practice Exam 2
Time: 1 hours
This course presents questions that will help you prepare for the MCITP 70-444 PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.
Objectives
- Complete the practice exam questions
13. Practice Exam 3
Time: 1 hours
This course presents questions that will help you prepare for the MCITP 70-444 PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.
Objectives
- Complete the practice exam questions
Resources for Microsoft SQL Server 2005 Admin MCITP 70-444
- Know of a good resource for Microsoft SQL Server 2005 Admin MCITP 70-444 Online Training? Please Let Us Know.
