Friday , December 15 2017
Home / Online MSSQL DBA Training

Online MSSQL DBA Training

Course : Online MS SQL Server DBA

Course Highlights:

We provide real time environmental support during our training which helps people to professionally learn and improve their skills. Our trainers will assist you in resume and interview preparations, showing live scenarios, on-call support even after training.

Salient Features:

  • You will be proficient in MS SQL Server database Architecture, Installation of Software
  • More focus on High Availability features including Log shipping,Mirroring and clusters etc.
  • Course is designed in a way to provide more support on real time practical activities such as migration technologies etc

About Faculty:

Real Time experienced professional with good coaching skills.12 Years experiance in Database adminstration.
About Us:

DBA CENTRE was started in the year 2012 with a vision to provide online and classroom training’s worldwide. We are committed to provide high quality service with aim to satisfy each candidate.

1)  Introduction

  • SQL Server & Editions
  • SQL (Structured Query Language)
  • Creating Databases
  • Creating Tables
  • Constraints
  • Rules and Defaults
  • Creating Schemas
  • Stored Procedures
  • Views

2) Core Database Administration – 1

  • SQL Server 2012 & 2014 Installation
  • System Databases
  • Database Architecture
  • Managing Databases
  • Files and file groups
  • Extends and Pages

3) Core Database Administration – 2

  • Database Options
  • SQL Server Architecture
  • Storage Structure of SQL Server
  • Recovery Models
  • Backup types
  • Backup Options
  • Backup Permissions
  • Backup History
  • Types of Restoration
  • Attach / Detach & Import / Export
  • Security , Server Roles & DB Roles
  • SQL Jobs, Maintenance Plans
  • Alerts, Notifications and Database Mail
  • Configuration Settings

4)  High Availability

  • Log Shipping
  • Configuration of Log shipping
  • Log Shipping Issues – With Scenarios
  • Database Mirroring Overview
  • Configuring Mirroring
  • Mirroring Issues – With Scenarios
  • Types of Replication
  • Configuring Replication
  • Replication alerts

5)  Performance Tuning

  • Profier, Extended Events
  • DTA,
  • Execution plan, Activity Monitor
  • ACID, Isolations Levels
  • Indexes
  • Partitions
  • Blocking, Locking
  • Dead Lock

6) Advance SQL DBA Training

  • SQL Server 2014 / 2016 Features
  • Policy Based Management
  • Change Data Capture
  • Reporting Server Installation and Configuration
  • Contained Databases
  • Transparent Data Encryption (TDE)
  • Linked Servers

7)  Windows Clusters & SQL Clusters

  • SQL Server Clusters Overview
  • Creating DOMAIN Server
  • ADDING the systems into the domain
  • Adding SAN Storage
  • Windows Cluster Installation
  • Cluster Configuration
  • SQL Server Cluster Installation
  • Cluster Issues and Troubleshooting
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe