SQL Server 2005: Microsoft SQL Server 2005 - Implementation and Maintenance MCTS (Exam 70-431)

See how a Course Works: Intro to Online Learning





Description

This collection of courses is recommended by Microsoft for students taking the MCTS Exam 70-431:

Microsoft SQL Server 2005 - Implementation and Maintenance.Course Length:

46 hoursSystem Requirements:

Pentium II 400 MHz or higher256MB RAM or moreMicrosoft Internet Explorer

6.0 or higher256k connection (broadband recommended)Windows XP, 2000 or higherFlash Player

7.0 or higherSpeakers and soundcardUnlimited access for 1 year

Outline

This collection contains the following courses:

Course 2936:

Installing and Securing Microsoft SQL Server 2005Course 3167 :

Designing a Highly Available Database Storage Solution Using Microsoft SQL Server 2005Course 3466:

Managing and Automating Microsoft SQL Server 2005 Databases and ServersCourse 3467:

Managing Microsoft SQL Server 2005 Supporting ServicesCourse 4326:

Getting Started with Databases and Transact-SQL in Microsoft SQL Server 2005Course 4327:

Performing Basic Queries in Microsoft SQL Server 2005Course 4328:

Grouping and Summarizing Data in Microsoft SQL Server 2005Course 4329:

Joining Data from Multiple Tables in Microsoft SQL Server 2005Course 4330:

Working with Subqueries in Microsoft SQL Server 2005Course 4331:

Modifying Data in Microsoft SQL Server 2005Course 4332:

Querying Metadata, XML, and Full-Text Indexes in Microsoft SQL Server 2005Course 4333:

Using Programming Objects for Data Retrieval in Microsoft SQL Server 2005Course 4334:

Using Advanced Querying Techniques in Microsoft SQL Server 2005Course 4326:

An Introduction to Transact-SQL in Microsoft SQL Server 2008Course 4327:

Querying and Filtering Data in Microsoft SQL Server 2008Course 4331:

Modifying Data in Tables with Microsoft SQL Server 2008Course 4332:

Integrated Full Text Search and Returning XML Result Sets in SQL Server 2008Course 4333:

An Introduction to Programming Objects in Microsoft SQL Server 2008Workshop 2980:

Building a Monitoring Solution for Microsoft SQL Server 2005 Performance IssuesWorkshop 2982:

Optimizing the Microsoft SQL Server 2005 Query Performance EnvironmentWorkshop 2984:

Troubleshooting Microsoft SQL Server 2005 Data Issues

Additional Info

Languages
English
Course Length
46.00 hours
Duration of Access

This collection is 46 hours.

Subscription: 1 year

Instructor

Self Study

Prerequisites/Audience
Requirements/Materials Included

System Requirements:
Pentium II 400 MHz or higher
256MB RAM or more
Microsoft Internet Explorer 6.0 or higher
256k connection (broadband recommended)
Windows XP, 2000 or higher
Flash Player 7.0 or higher
Speakers and soundcard