Real-time and Practical Training on SQL DBA 2014 Video Course in SQL School Training Institute
Real-time and Practical Training on SQL DBA 2014 Video Course in SQL School Training Institute Course Details:
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 - VIDEO TRAINING and online Training and Corporate Training for the last EIGHT years . All our sessions are completely Practical and Real-time.
Real-time and Practical Training on SQL DBA 2014 Video Course in SQL School Training Institute 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 live video training on SQL server 2014 DBA
For free SQL-DBA Course Registration please visit :
SQL School Training Institute
E Mail : contact@sqlschool.com
Schedules for LIVE VIDEO TRAINING ON SQL Server 2012 DBA :
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.
