SQL School is one of the pioneers IT Institutions providing specialized trainings SQL Server 2008 production DBA. We are providing Online and Corporate Trainings for the last FOUR years. All sessions will be dealt by proficient and Certified DBAs.
Features of our Training:
Study Material
Real Time Examples and Methodologies for each concept
Recorded version of missing sessions
Example Case Studies
24*7 availability to clarify doubts
Resume Preparation
Interview Tips, Questions and Guidance
A Real-time project [15 Servers with 1000+ databases] is also provided after the course.
We assure you quality of training along with Study Material.
SQL DBA 2005 & 2008 COURSE DETAILS
SQL server basics
RDBMS Basics
SQL Server Architecture
Database Architecture
Table Design Issues
Data integrity Techniques
Views and Data Security
JOINS and Sub Queries
Indexes and Performance
Procedures and Functions
DDL and DML Triggers
Cursors usage and Limitations
Transactions Concepts and Locking
Administration
Blockings and Deadlocks
Partitioning Techniques
DB Snapshots and usage
Backup Strategies
Restore Techniques
Replication Techniques including RMO
Securing Replication
Log Shipping with Security
DB Mirroring and Troubleshooting
Security Enforcement
Performance Tuning
Import and Export using SSIS
Cloning Databases and Objects
Advanced Administration
Certificates and Signatures
Query Troubleshooting
SQL Server Profiler
DB Engine Tuning Advisor
Data Movement Procedures
SMO and BCP
Maintenance Plans
Database Mail
Clustering Configuration and Procedures
Upgrades and Migrations
MS DTC and Linking
Service Packs and Upgrades
You can reach us anytime for your valuable Queries.
For Free Demo and fee details and course structure, you can reach us anytime at:
SQL School
http://sqldbatraining.com
contact@sqldbatraining.com
Mobile: +91-(0)-9666440801
Office: 040 - 6457-7244
US: (001) 214-628-5666
