All our sessions are completely Practical and Real-time.

SQL DBA 2012 COURSE DETAILS FOR CLASSROOM TRAINING:

SQL Server Basics & T-SQL

• SQL Server 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 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