Mail : training@ecorptrainings.com
India : +91-8143-111-555
USA : +1-703-445-4802
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Wednesday... 14-12-2016
Search Course Here




Live Chat
Support
MCTS Online Training

MCTS

overview

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

Corporate
  • It is a 5 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
Classroom
    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
Videos

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

Flash News


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


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


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


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


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

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

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

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

PUBLIC DEMO


(1) Workday Technical Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th DEC & 07:00A.M IST on 14th DEC

SOLVE YOUR QUERIES ONLINE
Email :
Rediff Bol :
ecorptrainings@rediffmail.com
Google Talk :
ecorptrainings@gmail.com
MSN Messenger :
ecorptrainings@hotmail.com
Yahoo Messenger :
ecorptrainings@yahoo.com
Skype Talk :
ecorptrainings