SQL Server 2012 DBA with PROJECT - CLASSROOM TRAINING

Published date: June 9, 2016 | 3:32 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 SQL Server 2012 DBA with PROJECT - CLASSROOM TRAINING and online Training and Corporate Training for the last EIGHT 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: 21568


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