All our sessions are completely Practical and Real-time.
SQL DBA 2012 COURSE DETAILS FOR CLASSROOM TRAINING:
SQL Server Basics & T-SQL
• SQL Server 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
• DDL Triggers and DML 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
Course Fee for complete practical SQL DBA Classroom Training: INR 8000 (payable in installments).
For free Demo and further training details, please contact us.
SQL School
contact@sqlschool.com
Sai Manor Complex, Beside SR Nagar Statue, X Roads, SR Nagar, Hyderabad (India)
Office: (+91) 040 64577244
http://sqlschool.com
