Prakash

SQL Server Basics
• SQL Server 2012 Design Architecture
• SQL Server Database Design & Planning
• SQL Server Table Design & Pages
• Table Compression Techniques
• SQL Server Views and Schemas
• JOINS and Sub Queries
• Uses of Indexes and Performance
• Stored Procedures and User Defined Functions
• Locks and Memory Concepts & Locking Hints
• New Features in DENALI (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
• Log Shipping Modes and Issues
• DB Mirroring and Encryption
• SQL Server Security & Client Security
• Security Issues and Audits
• Data Level Encryptions and Data Security
• Performance Tuning & Tips
• Import -Export Techniques
• Tuning & Troubleshooting
• 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
• 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/Active and Active/Passive Cluster Configuration Issues
• SQL Server Cluster Management
• Contained Databases and Always-On Availability Groups
SQL Server Cluster Management Operat