Sql Server DBA Training

(3) 3 Ratings

Course Schedule

30

JUL

Mon - Sat

07:30 PM - 10:00 PM ( IST )

06

AUG

Mon - Fri

11:00 AM - 02:00 PM ( IST )

11

AUG

Sat - Sun

05:30 AM - 06:30 AM ( IST )


Total Learners

897 Learners


LMS Access

365 days

Course duration

30 days


Support

24/7 support

Can't find convenient schedule?

Our experts can help you find a batch that meets your needs

The Instructor for this course is from one of the Big5 Companies in the world.

Drop us a Query

I agree to the Training T&C

Modes of Training

Corporate Training

Live, Classroom Or Self Paced Training

Online Classroom

Attend our Instructor Led Online Virtual Classroom

Self Paced Training

Comprehensive Recorded Videos by Experts to learn at your own pace

Course Features

Live Instructor-led Classes

This isn't canned learning. Its dynamic, its interactive, its effective

Expert Educators

Only the best or they're out. We are constantly evaluating our trainers

24&7 Support

We never sleep. Need something answered at 3 am? No Problem

Flexible Schedule

You don't learn as per our calendar. We work according to yours

☰ Details

Course Curriculum

Basics of SQL Server DBA

  • Responsibilities of Database Administrator
  • Types of DBA’s
  • History of SQL Server – Versions
  • What’s new in SQL Server 2012 & 2014 for Administrators?
  • SQL Server 2008 & 2012 Service Packs
  • Editions of SQL Server.

Installing and Configuring

Installing SQL Server 

  • Pre –Installation Steps
  • Installations
  • Viewing Installation process with Log files
  • Common issues
  • Adding or removing components
  • Installing Service Packs

Configuration

  • Configuration of Various Services
  • Startup Parameters
  • Configuring data files and log file paths
  • Memory Configuration
  • Remote Connections
  • Configuring network protocols, Ports
  • Configuring Services
  • Configuring default backup folder.

SQL Server Backup & Restore

Part-1

  • DB structure based on Recovery Models
  • Relation with Recovery Models & Backup solutions
  • Types of Backups including Copy only
  • Maintenance plans
  • DBA Email Alerts
  • Understanding SQL LSN & Backups

Part-2

  • Database Restore & Recovery
  • Full Database Restore
  • Full DB restore & transaction logs recovery
  • Restoring System DBs (Recap on SQL Server Installation Rebuilding Master DB)
  • Understanding SQL LSN & Backups-Restore.

Data Movement

  • Data Import & Export using BCP Commands
  • Data Import & Export using SQL Import & Export Wizard.

Implementing Security

Security in SQL Server 2016
Security Enhancements
Types of Authentications.

  • Windows Authentication
  • Creating logins from windows users and groups
  • Orphan logins

SQL Server Authentication

  • Creating SQL logins and testing logins
  • Setting Authentication Mode
  • Security Auditing
  • Understanding Server Roles
  • Working with users
  • Resolving Orphan users
  • Understanding database roles
  • Understanding permissions
  • Working with certificates and schemas
  • Security catalogue views and stored procedures
  • Major Issues.

Automating Administrative Tasks

  • Working with Database MailConfiguring Linked Servers
  1. Mail Architecture
  2. Configuring Profiles and Accounts
  3. Sending Mails
  • Implementing Automation
  1. Configuring SQL Server Agent
  2. Creating Operators, Alerts, Jobs
  3. Managing jobs and resolving errors
  4. Monitoring Jobs
  5. Auto alert when jobs are enabled, disabled or failed.

Clustering SQL Server

  • Clustering SQL Server
  • Overview of Windows Clustering
  • Requirements
  • Installation and configuration of SQL Server Clustering
  • Applying Service packs and fixes
  • Moving groups
  • Adding node on a SQL Server Failover Cluster
  • Troubleshooting Cluster issues. 

Performance Tuning

  • Blocking
  • Dead Locking
  • Index’s Rebuild & Reorganise
  • Locks Types
  • Trace Flags
  • DMV’s 

Course Description

What will you learn in this MS SQL Server DBA Training Course?

  • Learn the roles and responsibilities of SQL Server DBA
  • Understand the various SQL server tools available
  • Learning Query Design and Query Performance Tuning
  • Disaster Recovery and High Availability solutions
  • DBA creation, modification and file addition
  • Learn SQL Server security authentication measures
  • The importance of Backups and restorations
  • Job monitoring and SQL Server Agent Clustering
  • Creation of users and logins.

Who should take this SQL Server DBA Training Course?

  • Software and IT professionals
  • SQL Developers and Administrators
  • Database server professionals
  • Those aspiring for a career in SQL Server DBA.

What Are The Pre-Requisites For This Training?

  • Good Knowledge and understanding of databases.
  • T-SQL and .NET Coding knowledge will be an additional advantage.
  • In-depth knowledge of storage and operating systems will be helpful.

FAQ

Do you have self paced training?

Yes, we offer self paced training

How do you provide training?

We offer three different modes of training. Instructor Led Live Training, Self Paced Training and Corporate Training

Do you offer any discounts?

Yes we offer discounts for group of 3 plus people.

Can I choose timings that suits my schedule?

Yes we are the only company where we work with students and offer flexible timings which fits your schedule

Who are the Instructors?

All our instructors are from MNC companies who have real time experience of more than 10 years.

Can I attend a demo session before joining?

Yes we offer a free demo session with the instructors. The trainer will answer all your queries and share the course agenda.

Course Reviews

Satya

It is a great experience to learn online courses through Live Training Bangalore. The sessions are very professional. I had enrolled for Sql server dba course. It helped me a lot professionally at my workplace. I am very glad for choosing LTB as my learning partner. Thank you.

Madhuri

It was a great experience to undergo and get certified in the sql server dba Course from LTB. As a working professional, it has not only given me an exposure to the domain but also helped me learn cross technologies and develop an inclination towards it. Thank you.

Chandana

I came across Live Training Bangalore while I was searching for Fast Track courses in sql server dba. Their coordinators and instructors responded positively and I was able to get a good conceptual overview. Thank you LTB.