SQL Server DBA Online Training Concepts :
SQL Server Architecture
SQL Server Version’s and Editions
SQL server Installation and Configuration
System databases
Pages and extents
Sql server services
Sql server protocols
ACID properties
Recovery models
Security-Login and User,Principals,Securables,Managing Permissions
Authentication Modes
Server roles
Database roles
Isolation Levels and Concurrency
Locking and Blocking-Types of locks and Types of reads
Service accounts for SQL server
GUI Templates-object explorer,solution explorer,template explorer,registered servers
Command line tools-BCP,SQLCMD
Creating and Configuring Database
Altering Databases and Their Options-Using ALTER command,Controlling Access,Controling DB state.
Linked servers
DAC-Dedicated Adminstrator Connection
CMS-Central Management Server
Data Compression and Backup Compression
Using ALTER Authorization Command
Schemas-Creating and working with schemas
Databasesnapshots
DBCC-And their parameters
Indexes-Types of Indexes,working and Maintaining indexes,resolving indexfragmentation,fill factor
Update statistics
SQL Server Top New Features
DMV’s-Types of Dynamic Management Views and working with them.
PBM-Policy Based Management
Resource governer
Performance data collector
SQL Server profiler
Maintainence Plans
Databasemail
Types of Sql Server Backups and their important options.
Types of Restores and its related options
Orphan Users-Fixing orphan users
Log shipping
Database Mirroring
Replication-Types Replication
Basics of Windows Clustering
Overview of real time Third party Monitoring tools-Ex:-Idera DM,Lite speed.
Overview of real time Ticketing tool-Ex:-Altiris,Remedey.