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 10000 + 18% GST Duration : 40 hrs
70 – 462 (DBA) 10000 + 18% GST Duration : 45 hrs
70 – 463 (MSBI) 12000 + 18% GST Duration : 50 hrs

Fees include the cost of Microsoft Press Books.

Microsoft SQL Server 2012—Implementation and Maintenance Contents

 

 

Module 1: SQL Server 2012Installing 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 TextIndexing ·         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