At A Glance
Total Combined Length 23 Hours
Level Beginner to Advanced
Instructor Anil Desai
Course Outline View
System Requirements Online Broadband connection • 512MB RAM • Windows 2000/XP/Vista/7 • Windows Media Player 9 or later
Single-user Pricing
Online Delivery Buy
Multi-user Pricing
Online Delivery (5+ Users) Buy

Why Choose KeyStone?

  • KeyStone instructors are Microsoft Certified Trainers (MCT)
  • Fully hosted: no software to download or maintain
  • Supplemental Keynotes provide text version of training
  • Engaging Video Content

KeyStone News

Highlights

  • Microsoft SQL Server 2005 necessary components to prepare for the Microsoft Technical Specialist (TS) exam, Exam 70-431: Microsoft SQL Server 2005 Implementation and Maintenance.
  • SQL Server installation, configuration, and maintenance.
  • How to monitor and troubleshoot SQL Server Performance.
  • How to use SQL Server wizards, such as the Copy Database Wizard.
  • How to create and manage databases and verify database integrity using DBCC CHECKDB.
  • How to write scripts (code) in the appropriate language.
  • Create triggers to update multiple tables and enforce specific database rules.

Course Summary

This SQL Server 2005 Implementation and Maintenance (Exam 70-431) course provides database and business intelligence developers as well as system administrators with an in-depth look at implementing and maintaining SQL Server 2005.

Throughout this course, your instructor, Anil Desai, will first walk through each course topic from a conceptual standpoint. Then, you’ll experience a live, video walkthrough as Anil helps you visualize what’s involved in implementing and managing the many different components of this complex relational database platform.

In other words, this course contains all of the information you need to set up and manage SQL Server 2005 in a production environment and pass the Microsoft Technical Specialist (TS) exam, Exam 70-431: Microsoft SQL Server 2005 Implementation and Maintenance.

There are over 120 lessons across 8 levels in this course – all designed to help you prepare for Exam 70-431.

Instructor

Instructor Photo

Anil Desai

Microsoft MVP

Anil Desai (MCITP, MCSE, MCDBA, and MCSD Certified, Microsoft MVP Award) is an independent consultant and author based in Austin, TX. He specializes in implementing and managing solutions based on Microsoft technologies. He has worked extensively with Microsoft’s Server products and the .NET development platform. In his consulting and professional experience, Anil has designed and managed hundreds of SQL Server databases.

Anil is the author of numerous technical books focusing on SQL Server , the Windows Server platform, virtualization technology, Active Directory, and IT management. He has made dozens of conference presentations at national events and is also a contributor to technical magazines. For more information, please see his web site at AnilDesai.net.

Related Courses