PRACTICAL SQL Server 2014 & R2 DBA ONLINE TRAINING & JOB SUPPORT

Published date: June 9, 2016 | 3:34 pm | Posted by: SQLSchool
  • Location: Sanjeeva Reddy Nagar, Hyderabad, Telangana, India

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

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 Schemas



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



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



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

http://www.sqlschool.com


Ad ID: 21703


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