**REALTIME TRAINING ON SQL Server 2012 DBA – CLASSROOM @ SQL School**

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.**



**PRACTICAL SQL 2012 DBA CLASSROOM TRAINING COURSE DETAILS :**



***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

Implementation



• 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 :***



http://sqlschool.com/SQLDBA-Classroom-Training.html



**SQL School Training Institute**



E Mail : contact@sqlschool.com



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



http://sqlschool.com/register.html



India:

Office : +91 (0) 40 64577244

Mobile : +91 (0) 9666440801



USA:

Office: +1 (510) 400-4845



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



http://www.sqlschool.com/


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