GET IN THE LEAD - get certified today! Experience the benefits of classroom learning - anytime, anywhere! QuickCert's expert instruction and multi-media courses are to get you certified - or your money back! Read why successful professionals choose QuickCert >

 

QuickCert's Microsoft Exam 70-431 training course TS: Microsoft SQL Server 2005 – Implementation and Maintenance teaches students how to use the tools and Transact-SQL language and know how to explore the user interface. Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 (MCTS: SQL Server 2005) implement and maintain SQL Server databases and typically pursue careers as database administrators, database developers, or business intelligence developers. 

When you pass Exam 70-431: TS: Microsoft SQL Server 2005 – Implementation and Maintenance, you complete the requirements for the following certification:

• -MCTS: Microsoft Certified Technology Specialist: SQL Server 2005
  

Exam 70-431 is also credit toward the following certifications:

• MCITP: Database Administrator
• MCITP: Database Developer
• MCSA on Microsoft Windows 2003
• MCSE on Microsoft Windows 2003

As a Microsoft Certified Partner, you can be certain that QuickCert's comprehensive Microsoft training courses will provide you with all the tools necessary to successfully prepare for your MCTS certification. We guarantee it!

Not sure what course is right for you?
Contact one of our Career Advisors at 888.840.2378 for assistance.

Your QuickCert Microsoft Exam 70-431 Training Course: TS: Microsoft SQL Server 2005 – Implementation and Maintenance Training Package Includes:

Delivery Format	Instructor Led Modules	Practice Exam Simulator	Exam Pass Guarantee
DVDs or online

Exam Pass Guarantee - Learn More

Free Product Upgrades

Toll Free Educational Support

Compatibility with:
98 | 2000 | ME | XP | 2003| Vista | Windows 7 | Windows 8

 

Hear What Our Customers Are Saying...

“I’m 100% satisfied with QuickCert’s training program. I love that it’s broken into manageable sections.   This is an all-inclusive training solution… they give you the manuals, the lectures broken into short segments, and practice tests that really mirror the actual tests I’ve taken. I plan to renew my membership!!”

— Karen S., Network Administrator, Calabasas, California

Questions?  Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.

Microsoft Exam 70-431 Training Course: TS: Microsoft SQL Server 2005 – Implementation and Maintenance Training Course Curriculum:

Module-1 Creating Databases and Database Files

Creating Databases
Creating Filegroups
Creating Schemas
Creating Database Snapshots

Module-2 Creating Data Types and Tables

Creating Data Types
Creating Tables
Creating Partitioned Tables

Module-3 Using XML

Retrieving XML by Using FOR XML
Shredding XML by Using OPENXML
Using the XML Data Type

Module-4 Creating and Tuning Indexes

Planning Indexes
Creating Indexes
Optimizing Indexes
Creating XML Indexes

Module-5 Implementing Data Integrity

Data Integrity Overview
Implementing Constraints
Implementing Triggers
Implementing XML Schemas

Module-6 Implementing Views

Introduction to Views
Creating and Managing Views
Optimizing Performance by Using Views

Module-7 Implementing Stored Procedures and Functions

Implementing Stored Procedures
Creating Parameterized Stored Procedures
Creating Functions
Handling Errors
Controlling Execution Context

Module-8 Implementing Managed Code in the Database

Introduction to the SQL Server Common Language Runtime
Importing and Configuring Assemblies
Creating Managed Database Objects

Module-9 Using Service Broker

Service Broker Overview
Creating Service Broker Objects
Sending and Receiving Messages

Maintaining a Microsoft SQL Server 2005 Database

 

Module-1 Installing and Configuring SQL Server 2005

Preparing to install SQL Server
Installing SQL Server
Managing a SQL Server 2005 Installation

Module-2 Managing Databases and Files

Planning databases
Creating databases
Managing databases

Module-3 Disaster Recovery

Planning a Backup Strategy
Backing Up User Databases
Restoring User Databases
Recovering Data from Database Snapshots
System Database and Disaster Recovery

Module-4 Managing Security

Overview of SQL Server Security
Securing the Server Scope
Securing the Database Scope
Managing Keys and Certificates in SQL Server

Module-5 Monitoring SQL Server

Viewing Current Activity
Using System Monitor
Using SQL Server Profiler
Using DDL Triggers
Using Event Notifications

Module-6 Transferring Data

Overview of Data Transfer
Introduction to SQL Server Integration Services
Using SQL Server Integration Services

Module-7 Automating Administrative Tasks

Automating Administrative Tasks in SQL Server 2005
Configuring the SQL Server Agent
Creating Jobs and Operators
Creating Alerts
Managing Multiple Servers
Managing SQL Server Agent Security

Module-8 Maintaining High Availability

Introduction to High Availability
Implementing Server Clustering
Implementing Database Mirroring
Implementing Log Shipping

Module-9 Introduction to Replication

Overview of Replication
Replication Scenarios

 

Questions?  Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.

Free Demo