Need some help?
Name Name
Contact Number Contact Number 1
Contact Number Contact Number 2
e-mail e-mail
Basic/ Office Courses
View Basic to Advanced Computer Training Courses
CompTIA Courses
View CompTIA Training Courses
Microsoft Courses
View Technical Microsoft Training Courses
Cisco Courses
View Cisco Training Courses
Web Design Courses
View Web Design Training Courses
Other IT Courses
View all other IT Training Courses

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
 
Buy Microsoft SQL Server 2005 Admin Training Free IT Training Demo Live Labs Tutor Support Contact e-careers computer training


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
11 Practice Exam 1

Duration 1 hour
12 Practice Exam 2

Duration 1 hour
13 Practice Exam 3

Duration 1 hour

  If you would like some advice on training or the special deals available then complete your details below.

Query

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

Career Training Helpline