SQL SERVER DBA TRAINING

[srijith.adapa]

Hi ,

Please find the course contents for T-SQL, SQL Server 2005 and 2008 R2 DBA below:

SQL Server Development [T-SQL] Basic Administration [DBA] Advanced Administration [DBA]
SQL Server Design
Database Design
Table Design
Compression Techniques
Data Integrity & Consistency
Views and Data Security
JOINS and Sub Queries
Indexes and Performance
Procedures & Functions
Statistics Management
DDL and DML Triggers
Cursors Applications
Transactions Concepts
Locks and memory
Isolation Levels
Locking Hints Blocking & Deadlocks
Partitioning Techniques
DB Snapshots and Usage
Backup Strategies
Restore Techniques
Replication Techniques
Securing Replication
Log Shipping
DB Mirroring
Server & Client Security
Database & Object Security
Security Issues and Reports
Performance Tuning
Troubleshooting Issues
Import -Export Techniques
Query Troubleshooting Certificates and Signatures
Cryptography & Keys
TDE and DES
SQL Server Profiler
DB Engine Tuning Advisor
Data Movement Procedures
SMO and BCP
Maintenance Plans
Optimizing SSIS Packages
SQL CMD Utility
Database Mail & Alert System
Clustering Procedures
Upgrades and Migrations
Service Packs
MS DTC and Resource Governor
Client Level Statistics

All concepts [including CLUSTERING] will be discussed practically.

NO PPTs or SCREENSHOTS during the live sessions. Material and FAQs will be provided over email. One Real time Project along with solution will be discussed during the course.
Guidance for 70-432 Microsoft Certification will be provided as well.

Duration:  30 working days. Total Course Fee for T-SQL with SQL DBA : Rs. 12000
Weekly SIX days (MON to SAT) and every day for 1.5 to 2 hours.

Upcoming Batches:

New T-SQL + SQL DBA Online ( LIVE) Training sessions from October 11th @ 6 AM India Time. DEMO is on October 7th @ 6 AM India Time.

New T-SQL + SQL DBA Online ( LIVE) Training sessions from October 11th @ 7 PM India Time. DEMO is on October 6th @ 7 PM India Time.

We will provide you day to day plan for the entire course during the DEMO session.

If you are interested, please let us know your preferable time from above mentioned slots so that you can attend for one DEMO. We will send you relevant information.

Contact us:
SQL School
Mob:+91-(0)-966644 0801
Office: 040- 6457-7244
US: (001) 214-628-5666
[url=http://sqldbatraining.com]http://sqldbatraining.com[/url]
[url=http://sqlbitraining.com]http://sqlbitraining.com[/url]