Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

SQL Server DBA Training

No Reviews Yet

Kalyan Nagar, Bangalore

Course ID: 33808

Kalyan Nagar, Bangalore

Students Interested 0 (Seats Left 0)

₹ 12,000

No Reviews Yet

Date and Time

Not decided yet.

Thiru

MCITP, MCP, ITIL, MCSA & SixSigma Certified

About Thiru

8 plus year of experience in SQL Server Administration.
Handled more than 38 corporate training's with leading MNCs.
Trained SQL DBA to more than 600+ professionals through online and classroom training.
No reviews currently Be the First to Review

About the Course

Microsoft SQL Server 2012/14/16 DBA Training Program

 

Overview:

 

This course is a soup-to-nuts course that will teach you everything you need to build,configure a server, maintain a SQL Server disaster recovery plan, and how to design and manage a secure solution. You'll learn how to automate daily, weekly, and hourly tasks (like backups), the details of security, SQL Server clustering, replication, disaster recovery, and using jobs and database maintenance tasks. This course consists of all practical techniques to troubleshoot issues which may arise in day to day activities. Each and every topic is covered with unique case studies. This course is divided into 6

modules and totals up to more than 40 hours of instructor-led training for SQL

Server 2012/14/16 administration.

 

 

Duration:

Total Training Duration: 40 Hours

 

 

Audience:

 

* IT Professionals who administer and maintain SQL Server databases.

* Freshers who looking for career opportunity in IT industry.

 

 

Course Outline:

 

Module-1 SQL Server Architecture

Introduction to SQL Server 2012

Overview on RDBMS and Beyond Relational

Big picture of SQL Server 2012

Components & Services of SQL Server 2012

Roles of production DBA

System Databases

Master, Model, MSDB, Tempdb & Resource

SQL Server 2012 Editions & Capacity Planning

Principal Editions [Enterprise, BI, Standard]

Specialized Editions [Web]

Breadth Editions [Developer, Express]

Hardware Requirements

OS and Software requirements

Pages & Extents

Pages

Extents [Uniform & Mixed]

Managing Extent Allocations

Tracking Free Space

Files and File groups

Database Files

Primary data files

Secondary data files

Log Files

Database File groups [Primary & User-defined]

T-Log Architecture

Transaction Log Logical Architecture

Transaction Log Physical Architecture

Recovery phases [Analysis, Redo & Undo]

Checkpoint Operation

Write-Ahead Transaction Log

Managing T-log

Truncating and shrinking the log file

Managing T-Log issues by using DBCC commands

 

Module-2 Installing, Upgrading, Configuration, Managing services and

Migration

 

SQL server 2012 Installation

Planning the System/Pre-Requisites

Installing SQL server 2012

Best Practices on Installation

Uninstalling SQL server

Common Installation Issues

Upgrading to SQL server 2012 R2/2012

Upgrading the server by applying service packs

Upgrading the server by applying Hot fixes

In-Place Up gradation from SQL server 2005 to 2012

Pre-Upgrade Checks

Upgrade advisor

Best Practices to follow while upgrading

Managing services

Server/Engine Connectivity issues

Security/Firewall access issues

Starting and Stopping Services through

Configuring SQL Server

Configuring Network Protocols from SQL Server configuration manager

Configuring other settings through SP_Configure

Configuring Memory Settings

Configuring Database Settings

Tempdb configuration

Best Practices on tempdb & Database settings

Migrating SQL Server

Side-By- Side Migration Techniques

Difference between in-place & Side by Side Migration/Upgradation

Advantages/Disadvantages of In-Place to Side-by-Side

Migrating Databases

 Migration by using Attach and Detach Method

 Migration by using Back and restore method

Migration by using Copy Database Wizard

Migrating Logins [Fixing Orphaned Users]

Creating and migrating linked servers

Migrating Jobs

Data movement by using Import & Export wizard

Migrating jobs & logins by using SSIS

 

 

Module-3 Security, Automation & Monitoring

 

Automating Administrative Tasks

About SQL server Agent

Creating Jobs, Alerts and Operators

Scheduling the Jobs

Working with Job activity Monitor

Resolving failure Jobs

Configuring Alert system in SQL server agent

Best practices on job maintenance

Monitoring SQL Server

The Goal of Monitoring

Choosing the Appropriate Monitoring Tools

Monitoring Job activities by job activity monitor

Monitoring SQL Server Error Logs/Windows by log file viewer

Best Practices on Monitoring

Security

Security Principles & Authentications

Server & Database Roles

User-defined server roles

Server and Database Principles

Server & Database Securable

Creating Logins and mapping Users to databases

Connecting to contained databases from SSMS

Granting to Object level Permissions

Best Practices on security

Module-4 Backup & Restore, High Availability & Replication

Backup & Restore:

Recovery Models [Simple, Bulk-Logged & Full]

How Backup Works

Types of backups

 Full backup

 Diff backup

 T-log backup

 Copy Only

 Mirror

 Tail-Log

 Compressed backups

Restoring Modes [With Recovery, No Recovery, Read only/Standby]

Disaster Recovery Planning

Performing Restore (point-in-time recovery)

Partial availability of database

Database Recovery advisor

Backup strategy: Developing and executing a Backup Plan

Creating Maintenance Plans

Resolving Backup failures in Real time scenarios

Best Practices on Backup & Recovery

 

Module-5 High Availability:

Replication

Replication Overview

Replication Models (snapshot/Transactional/Merge/Updatable/Peer to Peer)

Replication agents

Configuring Distributor

Deploying Transactional Replication for High Availability

Deploying Merge Replication for Bi-directional

Creating Subscriptions [Homogeneous / heterogeneous]

Monitoring Replication by using replication monitor

Scripting Replication

Best Practices on Replication

Configuring peer to peer replication

Frequently asked questions in replication

DB Mirroring

Concepts of DB Mirroring

Configure DB Mirroring

Types of DB Mirroring

Log Shipping

Concepts of Log Shipping

Configure Log Shipping

Monitoring Log Shipping

 

Module-6 Performance Tuning, Indexing & Optimizing SQL Server

Optimizing SQL server

Index Architecture

How to optimally take advantage of indexes

Clustered & Non-Clustered indexes

Covering Index or index with included column

Creating covering indexes

Filtered indexes

Creating filtered indexes to minimize the CPU pressure

Column store Index Overview

Column store Index Fundamentals and Architecture

Creating column store index to improve the performance

Index Fragmentation

How to determine fragmentation

Creating maintenance plan for rebuilding/reorganizing indexes

Best Practices on Indexing

Locking & Concurrency

Blocking [SP_Who2]

Resolving blocking issues in SQL Server

Working with Activity Monitor

Capturing deadlock information in error logs

Deadlocks and deadlock chain detection.

Performance Tuning

Factors That Impact Performance

Best Practices on Performance Tuning.

Reviews

No reviews currently Be the First to Review

Discussions

Students Interested 0 (Seats Left 0)

₹ 12,000

Post your requirement and let us connect you with best possible matches for MS SQL Administration Training Post your requirement now
₹ 12,000 Enquire

Enquire

Submit your enquiry for SQL Server DBA Training

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With GeoPITS

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer