Facets Demo New Batches Starting from Saturday... 22-10-2016
Search Course Here

Live Chat
MCTS Online Training



Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 (MCTS: SQL Server 2005) implement and maintain databases using specific instructions and specifications.
  • Working knowledge of Transact-SQL
  • Working knowledge of relational databases
  • Some experience with database design
  • It is a 20 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

  • It is a 5 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
    Private Classroom arranged on request and minimum attendies for batch is 4.
course content
  • Creating Databases and Database Files
    • Creating Databases
    • Creating Filegroups
    • Creating Schemas
    • Creating Database Snapshots

  • Creating Data Types and Tables
    • Creating Data Types
    • Creating Tables
    • Creating Partitioned Tables

  • Using XML
    • the xml data type and its methods
    • Retrieving XML by Using FOR XML
    • Shredding XML by Using OPENXML
    • Using the xml Data Type

  • Creating and Tuning Indexes
    • Planning Indexes
    • Creating Indexes
    • Optimizing Indexes
    • Creating XML Indexes

  • Implementing Data Integrity
    • Data Integrity Overview
    • Implementing Constraints
    • Implementing Triggers
    • Implementing XML Schemas

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

  • Implementing Stored Procedures and Functions
    • Implementing Stored Procedures
    • Creating Parameterized Stored Procedures
    • Creating Functions
    • Handling Errors

  • Controlling Execution Context
    • This module explains how to implement managed database objects
    • Introduction to the SQL Server Common Language Runtime
    • Importing and Configuring Assemblies
    • Creating Managed Database Objects

  • Using Service Broker
    • Service Broker Overview
    • Creating Service Broker Objects
    • Sending and Receiving Messages

  • Installing and Configuring SQL Server 2005
    • installation, and how to use the SQL Server 2005 administrative tools
    • Preparing to install SQL Server
    • Installing SQL Server
    • Managing a SQL Server 2005 Installation

  • Managing Databases and Files
    • Planning databases
    • Creating databases
    • Managing databases

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

  • Managing Security
    • cryptography in a SQL Server database
    • Overview of SQL Server Security
    • Securing the Server Scope
    • Securing the Database Scope
    • Managing Keys and Certificates in SQL Server

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

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

  • 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

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

  • Introduction to Replication
    • This module explains considerations for implementing replication
    • Overview of Replication
    • Replication Scenarios

MCTS Videos will be updated soon
To watch more Videos Click Here

Flash News

AngularJS New Batch Start From 09th OCT & 10th OCT.

Hadoop Dev New Batch Start From 10th OCT & 11th OCT.

IBM COGNOS TM New Batch Start From 11th OCT & 12th OCT.

Informatica Dev New Batch Start From 12th OCT & 13th OCT.

Mean Stack New Batch Start 13th OCT & 14th OCT.

SAP BODS new Batch Starting From 14th OCT & 15th OCT.

SAP S/4 HANA New Batch Start From 15th OCT & 16th OCT

Tableau New Batch Start From 16th OCT & 17th OCT


Facets Demo Training

Demo Schedule : 08:30P.M EST / 07:30P.M CST / 05:30P.M PST on 21st OCT & 06:00A.M IST on 22nd OCT
Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :