Published date: June 9, 2016 | 3:33 pm | Posted by: SQLSchool
  • Location: Hyderabad, Hyderabad, Telangana, India

**SQL School** is one of the training organizations providing specialized in SQL Server 2012 DBA Training. We have been providing REALTIME TRAINING ON SQL Server 2012 DBA – CLASSROOM @ SQL School and Classroom Training and Corporate Training for the last EIGTH years .

**All our sessions are completely Practical and Real-time.**


***SQL Server Basics & T-SQL Queries***

• SQL Server Design Architecture – 2008 R2 & 2012

• SQL Server Database Design & Planning

• SQL Server Table Design & Pages

• Table Compression Techniques

• Data Integrity & Consistency

• SQL Server Views and Schemes

• JOINS and Sub Queries

• Uses of Indexes and Performance

• Stored Procedures and User Defined Functions

• Dynamic SQL and TEMP Tables

• DDL Triggers and DML Triggers

• Memory Usage with Triggers

• Cursors Usage and Limitations

• T-SQL Transactions Concepts & Types

• Locks and Memory Concepts & Locking Hints

• New Features in SQL Server 2012

***Basic SQL Server Administration (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 & Client Security

• Database & Object Security

• Security Issues and Audits

• Data Level Encryption and Data Security

• Performance Tuning & Tips

• Import -Export Techniques

• Tuning & Troubleshooting

• Security Audits in DENALI

• DBCC Commands and Management

• Server Level Audits

***Advanced SQL Administration***

• Log Space Issues and Temp-db Issues

• Pro-filer & Activity Monitor and Network Issues

• Partitioning Techniques, DB Snapshots and Usage

• Certificates, Signatures, Cryptography, Keys and TDE


• DB Engine Tuning Adviser and Client Statistics

• Optimizing SSIS Packages

• Database Maintenance Plans

• DB Mail & Alert System with Notifications

• Upgrades, Migrations and Service Pack Installations

• SQL Server Fail over 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 Real time.**

Contact us today for practical SQL 2012 DBA video training

***For free SQL-DBA ONLIDNE Demo, please visit :***


**SQL School Training Institute**

E Mail : contact@sqlschool.com

***Schedules for PRACTICAL SQL 2012 DBA VIDEO TRAINING :***



Office : +91 (0) 40 64577244

Mobile : +91 (0) 9666440801


Office: +1 (510) 400-4845

Address: 108/2RT, Road No 1, SR Nagar, Land Mark : Beside Bus Stop, Hyderabad, India.


Ad ID: 21670

Share by email Share on Facebook Share on Twitter Share on Google+ Share on LinkedIn Pin on Pinterest

Contact seller Share

Useful information

  • Avoid scams by acting locally or paying with PayPal
  • Never pay with Western Union, Moneygram or other anonymous payment services
  • Don't buy or sell outside of your country. Don't accept cashier cheques from outside your country
  • This site is never involved in any transaction, and does not handle payments, shipping, guarantee transactions, provide escrow services, or offer "buyer protection" or "seller certification"

Related listings