Get Certified, Get Ahead

RHCE 7.0

RHCSS

RHCVA

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

CCNA
Cisco Pix Firewall
CCNP
ITIL Foundation ver 3.0
CCSA
CCSE
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

Fees:

70 - 461

8000 + service tax

Duration : 40 hrs

70 - 462 (DBA)

9000 + service tax

Duration : 45 hrs

70 - 463 (MSBI)

10000 + service tax

Duration : 50 hrs



Fees include the cost of Microsoft Press Books.
 

Microsoft SQL Server 2012—Implementation and Maintenance

Contents

 

 

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

         Rule

         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 admin@vibrantcomputers.com