StudyITonline logoStudy Image
Products/Courses List

Microsoft 70-431 (Course 2779) Implementing a Microsoft SQL Server 2005 Database

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. This course teaches students how to use the tools and Transact-SQL language and know how to explore the user interface.

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

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

Our training supplier is a Microsoft IT Academy Program Member and they follow the approved Microsoft course curriculum, ensuring that you receive the training and knowledge needed to succeed. They are so certain that this course meets and exceeds the exam objectives, that they guarantee you will pass your exam!

 Course Duration: 3 Months
Learning segments

Implementing a Microsoft SQL Server 2005 Database (Course 2779)

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

(Course 2780)

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

Credit cards we accept

Free Catalogue Download

Please fill in your details below and click the submit link.

Email Address: A value is required.Invalid format.

Free Career Path Download

Please fill in your details below and click the submit link.

Email Address: A value is required.Invalid format.