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

SQL SERVER DBA COURSE DETAILS FOR ONLINE TRAINING

Basic SQL Server Administration (DBA)

Transaction Concepts & T-SQL Basics

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 Snapshots and Usage

DB Mirroring and Data Connection Encryption

SQL Server Security & Client Security

Database & Object Level Security

Security Issues and ServerAudits

Data Level Encryptions and Data Security

Cryptography & Security Keys

Query Performance Tuning & Tips

Import -Export (SSIS) Techniques

SQL Profiler & Troubleshooting

Tuning & Issue Troubleshooting

Deadlock Graphs & Monitoring

Database Cloning and Issues

Indirect Checkpoints and Use

Security Audits in DENALI

DBCC Commands and DatabaseManagement

Server Level Audits

Advanced SQL Administration

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

Optimizing SSIS Packages

Database Maintenance Plans (SSIS)

Database Repairs, Object Repairs

CPU, IO and Memory Issues

Tuning Text and Image Data

Smoke Test Procedures

Policy Based Management (PBM)

Contained Databases Usage

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

All Sessions are Completely Practical and Realtime.

For details and free demo, please visit http://sqlschool.com/SQLDBA-Online-Training.html

SQL School Training Institute

contact@sqlschool.com

Office: (+91) 040 64577244

Mobile: (+91) 0 9666440801

Flat No: 302, Sai Manor Complex, X Roads, SR Nagar, Hyderabad, India.

http://sqlschool.com/