Gatlin International

Description

This great value collection of online courses will provide you with the core skills and knowledge you need for the MCITP:

Database Developer Certification (70-431, 70-441 and 70-442).Course Length:

64 hours Unlimited access for 1 yearSystem 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 soundcard

Outline

This collection contains the following collections/courses:

Collection 2781:

Designing Microsoft SQL Server 2005 Server-Side Solutions:

Course 3175:

Selecting Microsoft SQL Server 2005 Services to Support Business NeedsCourse 3176:

Designing a Security Strategy for a Microsoft SQL Server 2005 Database SolutionCourse 3177:

Designing a Data Model Strategy for a Microsoft SQL Server 2005 SolutionCourse 3178:

Designing a Transaction Strategy for a Microsoft SQL Server 2005 SolutionCourse 3179:

Designing a Notification Services Solution Using SQL Server 2005 Notification ServicesCourse 3180:

Designing Asynchronous, Queued Operations Using SQL Server 2005 Service BrokerCourse 3181:

Planning for Source Control, Unit Testing, and Deployment Using SQL Server 2005Course 3182:

Applying Advanced Query Techniques in Microsoft SQL Server 2005Collection 2782:

Designing Microsoft SQL Server 2005 Databases:

Course 3300:

Approaching Database Design Systematically Using Microsoft SQl Server 2005Course 3301:

Modeling a Database at the Logical Level with Microsoft SQL Server 2005Course 3302:

Modeling a Database at the Physical Level with Microsoft SQL Server 2005Course 3303:

Designing for Database Performance with Microsoft SQL Server 2005Course 3304:

Designing a Database Access Strategy with Microsoft SQL Server 2005Course 3305:

Modeling Database Dependencies with Microsoft SQL Server 2005Collection 2783:

Designing the Data Tier for Microsoft SQL Server 2005:

Course 4350:

Choosing Data Access Technologies and an Object Model for Microsoft SQL Server 2005Course 4351:

Designing an Exception Handling Strategy for Microsoft SQL Server 2005Course 4352:

Choosing a Cursor Strategy for Microsoft SQL Server 2005Course 4353:

Designing Query Strategies Using Multiple Active Result Sets in Microsoft SQL Server 2005Course 4354:

Designing Caching Strategies for Microsoft SQL Server 2005 Database AppliationsCourse 4355:

Designing a Scalable Data Tier for Microsoft SQL Server 2005 Database ApplicationsCollection 2784:

Tuning and Optimizing Queries Using Microsoft SQL Server 2005:

Workshop 4370:

Measuring Database Performance Using Microsoft SQL Server 2005Workshop 4371:

Optimizing Physical Database Design Using Microsoft SQL Server 2005Workshop 4372:

Optimizing Queries for Performance Using Microsoft SQL Server 2005Workshop 4373:

Refactoring Cursors into Queries Using Microsoft SQL Server 2005Workshop 4374:

Optimizing an Indexing Strategy Using Microsoft SQL Server 2005Workshop 4375:

Managing Concurrency Using Microsoft SQL Server 2005Collection 2778 Writing Queries Using Microsoft SQL Server 2005 Transact-SQL:

Course 4326:

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

Performing Basic Queries in Microsoft SQL Sever 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 2005

Additional Info

Languages

English

Course Length

64.00 hours

Duration of Access

This college is 60 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