+1 844 678 44 27

  SQL Server 2012 DBA Online Training and Placement

  SQL Server 2012 DBA Training for OPT CPT Students

Online Training Courses
.Net Online Training Courses Java Online Training Courses SAP Online Training Courses Oracle Online Training Courses Software Testing Online Training Courses C Programming Online Training Courses C++ Programming Online Training Courses jQuery Online Training Courses UI Design Online Training Courses UNIX Online Training Courses Javascript Online Training Courses SQL & PLSQL Online Training Courses SAS Online Training Courses BI Reporter Tool Online Training Courses Microstrategy Online Training Courses Mainframes Online Training Courses Business Objects Online Training Courses Business Analysis Online Training Courses BPM Online Training Courses Hadoop Online Training Courses DataStage Online Training Courses Android Online Training Courses Linux Online Training Courses OBIEE Online Training Courses IBM Tools Online Training Courses PHP Online Training Courses AJAX Online Training Courses BizTalk Online Training Courses Data Warehousing Online Training Courses Embedded Systems Online Training Courses Google Technologies Online Training Courses Microsoft Technologies Online Training Courses Oracle DBA Online Training Courses Oracle Datawarehouse Online Training Courses Oracle E-Business Suite Online Training Courses PeopleSoft Online Training Courses Project Management Online Training Courses Autocad Online Training Courses Salesforce Online Training Courses Sharepoint Online Training Courses Softskills Online Training Courses System Networking Online Training Courses Web Design Online Training Courses BizTalk Server Online Training Courses Database Online Training Courses iPhone App Development Online Training Courses Ruby On Rails Online Training Courses SEO Online Training Courses Shell Scripting Online Training Courses VMWare Online Training Courses Webmethods Online Training Courses Websphere Online Training Courses Visual Basic Online Training Courses TIBCO SOA Online Training Courses COGNOS Online Training Courses Perl Scripting Online Training Courses Hyperion Online Training Courses Informatica Online Training Courses Python Online Training Courses QlikView Course Contents QA Online Training Courses Tableau Tool Online Training Courses Basic .Net Training Course

SQL Server 2012 DBA 

Chapter 1

Planning and Installing SQL Server 2012

 Lesson 1: Planning Your Installation

  • Evaluating Installation Requirements
  • Designing the Installation
  • Planning Scale Up versus Scale out Basics
  • Shrinking and Growing Databases
  • Designing the Storage for New Databases
  • Remembering Capacity Constraints
  • Identifying a Standby Database for Reporting
  • Identifying Windows-Level Security and Service-Level Security
  • Performing a Core Mode Installation
  • Benchmarking a Server

Chapter 2

Configuring and Managing SQL Server Instances

 Lesson 1: Configuring SQL Server Instances . . . . .

  • Instance-Level Settings
  • Database Configuration and Standardization
  •  Distributed Transaction Coordinator
  • Configuring Database Mail

Chapter 3

Configuring SQL Server 2012 Components

Lesson 1: Configuring Additional SQL Server Components

  • Deploying and Configuring Analysis Services 
  • Deploying and Configuring Reporting Services
  • Deploying and Configuring SharePoint Integration
  • Configuring SQL Server Integration Services Security
  • Managing Full-Text Indexing
  • Configuring FILESTREAM
  • Configuring File Tables

Lesson 2: Managing and Configuring Databases

  • Designing and Managing File groups
  • Configuring and Standardizing Databases
  • Understanding Contained Databases
  • Using Data Compression
  • Encrypting Databases with Transparent Data Encryption
  • Partitioning Indexes and Tables
  • Managing Log Files
  • Using Database Console Commands

Chapter 4 

Migrating, Importing, and Exporting


Lesson 1: Migrating to SQL Server 2012

  • Upgrading an Instance to SQL Server 2012
  • Migrating a Database to a SQL Server 2012 Instance
  • Copying Databases to Other Servers
  • Migrating SQL Logins

Lesson 2: Exporting and Importing Data

  • Copying and Exporting Data
  •  Using the SQL Server Import and Export Wizard
  • Using BCP to Import and Export Data
  • Importing Data by Using BULK INSERT
  • Importing Data by Using OPENROWSET (BULK)
  • Using Format Files
  • Preparing Data for Bulk Operations

Chapter 5a

SQL Server Logins, Roles, and Users


Lesson 1: Managing Logins and Server Roles

  • SQL Logins
  • Server Roles
  • User-Defined Server Roles
  • Credentials

Lesson 2: Managing Users and Database Roles


  • Database Users
  • Database Roles
  • Contained Users
  • Least Privilege
  • Application Roles


Chapter 5b 

SQL Server Agent, Backup, and Restore


Lesson 1: Managing SQL Server Agent

  • Executing Jobs by Using SQL Server Agent
  • Managing Alerts
  • Managing Jobs
  • Monitoring Multi-Server Environments

Lesson 2: Configuring and Maintaining a Backup Strategy.

  • Understanding Backup Types
  • Backing up System Databases
  • Backing up Replicated Databases
  • Backing up Mirrored Databases
  • Backing up AlwaysOn Replicas
  • Using Database Checkpoints 
  • Using Backup Devices
  • Backing Up Media Sets
  • Performing Backups
  • Viewing Backup History


Lesson 3: Restoring SQL Server Databases

  • Restoring Databases
  • Performing File Restores
  • Performing Page Restores
  • Restoring a Database Protected with Transparent Data
  • Encryption
  • Restoring System Databases
  • Restoring Replicated Databases
  • Checking Database Status

Chapter 6 

Securing SQL Server 2012


Lesson 1: Managing Database Permissions

  • Understanding Securable 
  • Assigning Permissions on Objects
  • Managing Permissions by Using Database Roles
  • Protecting Objects from Modification
  • Using Schemas
  • Determining Effective Permissions

Lesson 2: Troubleshooting SQL Server Security

  • Troubleshooting Authentication
  • Troubleshooting Certificates and Keys
  • Troubleshooting Endpoints
  • Using Security Catalog Views

Lesson 3: Auditing SQL Server Instances


  • Using SQL Server Audit
  • Configuring Login Auditing
  • Using c2 Audit Mode
  • Common Criteria Compliance
  • Policy-Based Management

Chapter 7 

Mirroring and Replication


Lesson 1: Mirroring Databases


  • Database Mirroring
  • Mirroring Prerequisites
  • Configuring Mirroring with Windows Authentication
  • Configuring Mirroring with Certificate Authentication
  • Changing Operating Modes
  • Role Switching and Failover
  • Monitoring Mirrored Databases
  • Upgrading Mirrored Databases


Lesson 2: Database Replication

  • Replication Architecture
  • Replication Types
  • Snapshot Replication
  • Transactional Replication
  • Peer-to-Peer Transactional Replication
  • Merge Replication
  • Replication Monitor
  • Controlling Replication of Constraints, Columns, and Triggers
  • Heterogeneous Data

Chapter 8

Clustering and Always On


Lesson 1: Clustering SQL Server 2012.

  • Fulfilling Edition Prerequisites 
  • Creating a Windows Server 2008 R2 Failover Cluster
  • Installing a SQL Server Failover Cluster
  • Multi-Subnet Failover Clustering
  • Performing Manual Failover 
  • Troubleshooting Failover Clusters

Lesson 2: AlwaysOn Availability Groups.

  • What Are AlwaysOn Availability Groups?
  • Meeting Availability Group Prerequisites
  • Configuring Availability Modes
  • Selecting Failover Modes
  • Configuring Readable Secondary Replicas
  • Deploying AlwaysOn Availability Groups
  • Using Availability Groups on Failover Cluster Instances

Chapter 9 

Troubleshooting SQL Server 2012


Lesson 1: Working with Performance Monitor

  • Getting Started with Performance Monitor
  • Capturing Performance Monitor Data
  • Creating Data Collector Sets

Lesson 2: Working with SQL Server Profiler

  • Capturing Activity with SQL Server Profiler
  • Understanding SQL Trace
  • Reviewing Trace Output
  • Capturing Activity with Extended Events Profiler

Lesson 3: Monitoring SQL Server.

  • Monitoring Activity 
  • Working with Activity Monitor

Lesson 4: Using the Data Collector Tool.

  • Capturing and Managing Performance Data
  • Analyzing Collected Performance Data

 Lesson 5: Identifying Bottlenecks

  • Monitoring Disk Usage
  • Monitoring Memory Usage
  • Monitoring CPU Usage

Chapter 10 

Indexes and Concurrency


Lesson 1: Implementing and Maintaining Indexes

  • Understanding the Anatomy of a Balanced Tree (B-Tree)
  • Understanding Index Types and Structures
  • Designing Indexes for Efficient Retrieval
  • Understanding Statistics
  • Creating and Modifying Indexes
  • Tracking Missing Indexes
  • Reviewing Unused Indexes

Lesson 2: Identifying and Resolving Concurrency Problems

  • Defining Transactions and Transaction Scope
  • Understanding SQL Server Lock Management 
  • Using AlwaysOn Replicas to Improve Concurrency
  • Detecting and Correcting Deadlocks 
  • Using Activity Monitor
  • Diagnosing Bottlenecks
  • Using Reports for Performance Analysis

Review and practice on all above mentioned training.


Register Now!

Free Demo Class
Register for a FREE DEMO class to attend IT Training courses with our experts online trainers. Register now by filling the below form. Take a DEMO and see how our online training courses work for you.

Which course is right for me?

Speak to an IT online learning consultant today

on 844-OPTGHAR for FREE Tailored Advice.
get free advice