SQL School is one of the pioneers IT Institutions providing specialized in SQL Server DBA Training. We have been providing Online Training, Classroom Training and Corporate Training for the last SIX years. All our sessions are completely Practical and Real-time.

SQL DBA COURSE DETAILS FOR CLASSROOM TRAINING (contents at glance):

SQL Server Basics & T-SQL

SQL Server 2008 & 2012 Installation

SQL Server Database Design & Planning

SQL Server Table Design & Pages

Table Compression Techniques

Data Integrity & Consistency

SQL Server Views and Schemas

JOINS and Sub Queries

Uses of Indexes and Performance

Stored Procedures and User Defined Functions

DDL Triggers and DML Triggers

Cursors Usage and Limitations

T-SQL Transactions Concepts & Types

New Features in DENALI (SQL Server 2012)

Basic SQL Server Administration (SQL DBA)

Blocking & Deadlocks Issues

Backup Strategies & Backup Options

Point-In-Time, Partial and Piecemeal Restores

Replication Techniques and Monitoring

Peer – Peer Replication Topology and Limitations

Log Shipping Modes and Issues

DB Mirroring and Encryption

SQL Server Security & Database & Object Security

Security Issues and Audits

Data Level Encryptions and Data Security

Performance Tuning & Tips

Import -Export Techniques 

Tuning & Troubleshooting

Security Audits in DENALI

DBCC Commands and Management

Advanced SQL Server Administration (SQL DBA)

Log Space Issues and Tempdb Issues

Profiler & Activity Monitor and Network Issues

Partitioning Techniques, DB Snapshots and Usage

Certificates, Signatures, Cryptography, Keys and TDE Implementation

DB Engine Tuning Advisor and Client Statistics

Database Maintenance Plans

DB Mail & Alert System with Notifications

Upgrades, Migrations and Service Pack Installations

SQL Server Failover Cluster Configuration

Active Directory Configurations and Storage (SAN) Management

Active/Active and Active/Passive Cluster Configuration Issues

SQL Server Cluster Management Operations

MSDTC and Resource Governor Importance and Usage

Contained Databases and Always-On Availability Groups

Course Fee for complete practical SQL DBA Classroom Training: INR 8000 (payable in installments).

For free Demo and further training details, please visit www.sqlschool.com or contact us.

SQL School

contact@sqlschool.com

Sai Manor Complex, Beside SR Nagar Statue, X Roads, SR Nagar, Hyderabad (India)

Office: (+91) 040 64577244

http://sqlschool.com