SQL School is one of the pioneers IT Institutions providing specialized trainings SQL Server 2008 production DBA. We are providing Online and Classroom Trainings for the last FOUR years. All sessions will be dealt by proficient and Certified DBAs.
SQL DBA 2008 & 2012 COURSE DETAILS
SQL server basics
SQL Server 2012 Design
Database Design & Planning
Table Design & Pages
Table Compression Techniques
Data Integrity & Consistency
Views and Schemas
JOINS and Sub Queries
Indexes and Performance
Stored Procedures and User Defined Functions
DDL and DML Triggers
Cursors and Precautions
Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
Locks and Memory Concepts & Locking Hints
New Features in DENALI (SQL Server 2012)
Basic SQL Administration
Blocking & Deadlocks
Backup Strategies & Options
Partial & Piecemeal Restores
Replication Techniques
Peer Peer Replication
Log Shipping Modes and Issues
DB Mirroring and Encryption
Server & Client Security
Database & Object Security
Security Issues and Audits
Data Level Encryptions
Performance Tuning & Tips
Import /Export Techniques
Tuning & Troubleshooting
Security Audits in DENALI
DBCC Commands and Server 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 fee details and course structure, please contact us.
SQL School
www.sqldbatraining.com
contact@sqldbatraining.com
Mobile: (091)- 0- 9666440801 (India)
Office: 040 - 6457-7244 (Hyderabad, India)
US: (001) 214-628-5666
