Get Certified, Get Ahead

RHCE 7.0



MCSE 2012
MCSE Messaging
MCSE Security
MCTS - SQL Server 2012
Exchange 2013

Cisco Pix Firewall
ITIL Foundation ver 3.0
System Admin
Application Dev

  MCTS - Microsoft SQL Server 2012/14

MCTS - Microsoft SQL Server 2012 /2014

MCTS (Microsoft Certified Technology Specialist) Series.

  • Courses are for Information Technology(IT) professional and Developers who are new to product and for experienced individuals who prefer to learn in a traditional classroom Setup.
  • Courses provide a relevant and guided learning experience that combines lecture and practice to deliver through coverage of Microsoft Technology. MCTS credentials enables professionals to get in-depth knowledge of and expertise in the technologies they work in.
Course: SQL 2012


70 - 461

8000 + 18% GST

Duration : 40 hrs

70 - 462 (DBA)

9000 + 18% GST

Duration : 45 hrs

70 - 463 (MSBI)

10000 + 18% GST

Duration : 50 hrs

Fees include the cost of Microsoft Press Books.

Microsoft SQL Server 2012—Implementation and Maintenance




Module 1: SQL Server 2012

Installing and Configuring SQL Server Instances.

         Preparing to install SQL Server.

         Determining Hardware and Software Requirements.

         Supported Operating Systems.

         Selecting SQL Server Editions.

         Service Accounts Collation

         Sequences Authentication Modes

Module 2: Database Configuration and Maintenance





         Configuring Files and File groups.

         Understanding Files and File group.

         Understanding Transaction log.

         Retrieving MetaData Information.

         Configuring Database Options.

         Database Integrity Checks

Module 3: Creating Data Types and Tables


         Understanding Different Data Types.

         Creating Tables

         Understanding Column Properties


Module 4: Implementing Constraints

         Working with data Integrity using
Different Constraints.

         Primary Keys

         Foreign Keys

         Unique Constraints

         Default Constraints

         Check Constraints


         Implementing Triggers


Module 5: Designing SQL Server Indexes

         Understanding Index Architecture.

         Designing Indexes

o    Clustered Index

o    Non-Clustered Index

         Different Index Options

         Maintaining Indexes


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 User Defined Functions.

         Handling Errors.



Module 8:Distributing and Partitioning Data

         Creating a Partition Function

         Creating a Partition Scheme

         Creating Partitioned Tables and Indexes.

         Managing Partitions.

Module 9: Backing up and Restoring a Database

         Planning a Backup Strategy.

         Backing Up User Databases.

         Restoring User Databases.

         Database SnapShot

         Recovering Data from Database Snapshots

         Row and Page Compression

         Backup Compression

Module10: Full Text Indexing


         Creating and Populating Full Text Indexes

         Querying Full Text Data

         Managing Full Text Indexes using Stoplists and Stopwords

Module 11: Managing Security



Overview of SQL Server Security.

         Creating Principals

o    Logins Fixed Server Roles

o    Database Users

o    Loginless Users

o    Fixed Database Roles

o    User Database Roles

         Managing Permissions

o    Securables

o    Permissions Metadata Security

          Encrypting Data

o    Hash Algorithms

o    Symmetric Keys

o    Certificates and Asymmetric Keys

o    Transparent Data Encryption

o    Encryption Key Management

         DDL Triggers and Auditing

o    Working with DDL triggers

o    Working with Server and Database Audit specification

Module 12: Monitoring Microsoft SQL Server

         Working with the SQL Server Profiler

         Working with System Monitor

         Diagnosing Database Failures

         Diagnosing Service Failures

         Diagnosing Hardware Failures

         Resolving Blocking and Deadlocking Issues

         Using Activity Monitor

         Designing Policy Based Management

o    Facets

o    Conditions

o    Policies

o    Import and Export Policies

Module 13: Optimizing Performance

         Using the Database Engine Tuning Advisor

         Using Dynamic Management Views and Functions

         Working with Resource Governor

Module 14: Automating SQL Server

         Creating Jobs

         Creating Alerts

         Creating Operators

Module 15: Log Shipping

         Overview of Log Shipping

         Initializing Log Shipping

         Designing Failover and Failback Strategies.

Module 16: Database Mirroring

         Overview of Database Mirroring

         Initializing Database Mirroring. .

         Designing Failover and Failback Strategies

Module 17: Overview of Failover Clustering

         Overview of Designing Windows Clustering

         Overview of Designing SQL Server 2008 Failover Cluster Instances

Module 18: Replication

         Overview of Replication

o    Replication Components

o    Replication Roles

o     Replication Topologies Replication Agents

o    Agent Profiles

o    Replication Methods

o     Data Conflicts

         Implementing Different types Replication

         Monitoring Replication

Microsoft SQL Server 2008

To pass this certification required exam papers are:

  1. Microsoft SQL Server 2008 (Exam #70-462) - Administering Microsoft SQL Server 2012 Databases

For Further Details and Enrollment mail to