SQL DBA:

Duration: 30-35 classes

Regular Batch: Monday to Friday(1hr per day)

Fast-track Batch: as per student requirements

Course Highlights:

• Classes are taught by expert instructors

• Interactive classes with live atmosphere

• One or two demo classes before batch starts

Additional assistance:

• Career guidance workshop

• Mock/Practice interview session conducted by industry experts

• Resume preparation and corrections

• Email follow ups and many more

MODULE1

• Introduction to SQL Server DBA

• Database Environment details

• Admin Roles and Responsibilities or Duties

• Microsoft Sql Server features and version info

• Database System

• How many ways we can install SQL Server

• Issues installation

MODULE2

• SQL Server Environment

• About system databases and user defined databases

• Database properties

• Database Architecture

• Sql Server Architecture

• SQL SERVER SECURITY

• Authentication and Authorization

• Authentication types(windows /mixed )

• Server level roles

• Linked server

• Logins

MODULE3

• Recovery models

• Restore Modes/Types

• Backup types

• SQL Server Agent, Jobs, Schedules, operators, Alerts,Job history

• Database Mail

• Maintenance plans for indexes, creation

• Commands (DBCC DMV’S)

• Backup tools

MODULE4

• HIGH AVAILABILITY

• Database mirroring

• Logshipping

• Replication

• Clustering setup and configuration

MODULE5

• Monitoring events

• Sql server event logs, Error log in os level

• Task manager

• Performance monitor

• Performance tuning

• Sql server profiler

• Query tuning and query plan generation

• Resource governor

Object level Indexes maintenance ,fragmentation , page level ,Database consistence Script generation Tsql

 

COURSE CATALOG

DATABASES
DATA WAREHOUSING
SAP
MS DYNAMICS
JAVA
OPERATING SYSTEMS
WEB DEVELOPMENT
HYPERION
DATABASE ADMINISTRATION
SAS
.NET

COURSE ENQUIRY FORM