SQL School is one of the pioneers IT Institutions providing specialized in SQL Server 2012 Product DBA Training. We have been providing Online and Corporate Trainings for the last SIX years. All our sessions are completely Practical and Real-time.
SQL SERVER DBA 2012 COURSE DETAILS
SQL Server Basics
SQL Server 2012 Design Architecture
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
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
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 Encryptions 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 & Tempdb Issues
Profiler & Activity Monitor and Network Issues
Partitioning Techniques, DB Snapshots and Usage
Certificates and Signatures
Cryptography, Keys, TDE
DB Engine Tuning Advisor
Optimizing SSIS Packages
Database Maintenance Plans
DBMail & Alert System
SQL Server Clustering and Issues
Upgrades, Migrations and Service
MSDTC & Resource Governor
Client Statistics & Tuning
Contained Databases and Always-On Availability Groups
For Free Demo and details, you can reach us anytime.
SQL School
www.sqldbatraining.com
contact@sqldbatraining.com
Mobile: (091)-0-9666440801 (India)
Office: 040 - 6457-7244 (Hyderabad, India)
