Microsoft SQL Server 2005 Admin MCITP 70-444 Training Online Course
Microsoft SQL Server 2005 Admin MCITP 70-444 Training Online Course Total Time: 13 hour(s)
This online training course provides you with a study guide to prepare to become certified as a Microsoft Certified IT Professional: Database Administrator. PRO: Optimising and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 (70-444), will cover your ability to maintain everyday operations of enterprise Microsoft SQL Server 2005 databases. Practice exams are also included, which will allow you to answer questions in the same format that the test will use on exam day, and will provide in-depth instructional feedback on each question to thoroughly cover every subject you'll need to master.
| |
Try A Free Demo
|
Live Labs Available
|
24/7 Tutor Available
|
Need help? Click Here
|
| |
 |
 |
 |
 |
 |
Microsoft SQL Server 2005 Admin MCITP 70-444 Training Online Course Lessons:
1 Optimising the Performance of Databases and Database Servers
- Troubleshoot physical server performance
- Troubleshoot instance performance
- Troubleshoot database performance
|
Duration 1 hour |
2 Optimising the Performance of Queries
- Identify poorly performing queries
- Analyse a query and plan to detect inefficiencies in query logic
- Maintain and Optimise indexes
- Enforce appropriate stored procedure logging and output
|
Duration 1 hour |
3 Optimising and Implementing a Data Recovery Plan for a Database
- Diagnose causes of failures
- Plan for fault-tolerance
- Recover from a database disaster
- Salvage good data from a damaged database by using restoration techniques
|
Duration 1 hour |
4 Designing a Strategy to Monitor a Database Solution
- Define and implement monitoring standards for a physical server
- Choose the appropriate information to monitor
|
Duration 1 hour |
5 Designing a Strategy to Maintain a Database Solution
- Create and implement a maintenance strategy for database servers
- Design a database maintenance plan
- Design a strategy to manage Reporting Services
|
Duration 1 hour |
6 Designing and Managing SSIS Packages
|
Duration 1 hour |
7 Designing a Database Data Management Strategy
- Enforce data quality according to business requirements
- Design data integrity
|
Duration 1 hour |
8 Designing a Strategy to Manage Replication
|
Duration 1 hour |
9 Protecting Your SQL Server from Attack
- Optimise 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
|
Duration 1 hour |
10 Designing a Strategy to Manage and Maintain Database Security
- Maintain a server-level security strategy
- Maintain a user-level security strategy
|
Duration 1 hour |
|
Duration 1 hour |
|
Duration 1 hour |
|
Duration 1 hour |
|
Telephone: 0871 222 8790
Alternate Number: 01279 814 876
Fax: 01279 816 093
E-Mail: info@e-careers.co.uk
Address:
10 Riverside Business Park,
Stony Common Road,
Stansted Mountfitchet,
Essex,
CM24 8PL
|
|
