(Course covers)

Implementing a Microsoft SQL Server 2005 Database

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 Filess

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

About Our Instructor

Ricardo Benmeli,

is an Information Systems Consultant with 18 years hands-on experience in systems development, programming, networking, training, project and staff management. Highly skilled at interfacing with end users to determine systems specifications, design and implement finished projects and provide software and hardware training full of real-world examples.. Ric's unique training style includes his ability to be a strong team builder with superior motivational skills.

Full motion video
Each class is presented in full motion video allowing you to see the steps, hear the explanations, and perform the tasks which includes our interactive hands-on training simulations, students will learn from real-world scenarios taught by our expert instructor.

Instructor-Led Training
combines both the convenience and affordability of computer-based training with the effectiveness of a traditional classroom setting. The instructors featured in our multi-media CD's are not only certified in their area of expertise, but also have years of real world experience and are subject matter experts in their fields.

E-BOOKS (PDF)
We supply a complete line of e-books to offer a complete training solution. Our courses include e-books for CompTIA, CISCO and Microsoft certifications.

Supplied on CD for CD Courses.
Downloadable for Online Courses.


	Practice Exam Simulators Sandline Learning offers exam simulators for all technical certifications. Our exam simulators are the closest replication to the real exam! Our exam simulators creates a simulation of an actual certification exam. Under timed conditions, IntelliSage? sets up a test with 60 randomly chosen questions designed to help you get ready for the real exam. As with the Practice Exam, the Certification Simulator allows you to mark questions you cannot answer for review at the end of the test. If you ask, IntelliSage? will show you the correct answer. IntelliSage? will also explain why it is the correct answer when you select the "Learn Now" feature. The Practice Exam is the first IntelliSage? step in getting you ready to pass your certification exams.

	Hands-on Lab Simulation Hands-on Lab Simulation is a crucial component of your IT training. Practice make perfect. Step-by-step hands-on labs with detail instructions are included to reinforce all key concepts. When you complete a topic, choose the Lab Simulation button to select the associated hands-on lab exercises. Labs allow you to reinforce concepts by performing the tasks you've just learned.

	Certification Exam Pass Guarantee If you fail the certification exam twice after using our study material - showing us 2 scores of 95% or better on two different practice exams, within 6 months of purchase, the product may be returned for the full purchase price less shipping and handling charges.

Free Upgrades
A unique benefit of the Sandline Learning System? is that
it allows you to stay current with the ever-changing certification requirements. When a certification test changes and we produce an upgrade for the certification program, we offer our customers free upgrades on their interactive CD-ROM's for up to 1 year from date of original purchase? absolutely free!

Free educational support from our certified staff

Online Course:
CD Study Kit:
List Price:	£495
You Save:	£156
Availability:	In Stock
Rating:



	1yr Unlimited Online Access to 143 Courses
	Save 95%

What's included in each option?

MCTS 70-431 Implementing and Maintaining a Microsoft SQL Server 2005 Database

(Course covers)