PRACTICAL SQL Admin TRAINING and PROJECT - CLASSROOM

Published date: June 28, 2016 | 8:08 am | Posted by: SQLSchool
  • Location: Bangalore, Bangalore, Karnataka, India

SQL School is one of the pioneers IT Institutions providing specialized in SQL Server 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 DBA COURSE DETAILS FOR CLASSROOM TRAINING (contents at glance):



SQL Server Basics & T-SQL Programming



SQL Server 2008 & 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



Dynamic SQL and TEMP Tables



DDL Triggers and DML Triggers



Memory Usage with 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



For free Demo and further training details, please visit www.sqlschool.com or contact us.



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





[1]: http://contact@sqlschool.com

[2]: https://www.youtube.com/watch?v=W6HJXKhe9yg


Ad ID: 26641


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