SQL Server 2005/2008 Database Administration Training in Chennai

Sakthi Software Solutions Pvt Ltd, Anna Nagar, Chennai Offers Best SQL Server 2005-2008 Database Administration(DBA) Training in Chennai with placements. 

Course Content:

Pre-Requisites:

• Knowledge of Microsoft Windows operating system.
• Working knowledge on Transact-SQL
• Database design experience (Table/View/Function/SP/Trigger Design)

Exit Profile

• Ability to take exams 70-432 and 70-450

Level: 0 Prerequisites Refreshment (0.5 Day)

• RDBMS Concepts and CODD's Rules
• Normalization
• Query Writing Skills
• Query Writing Skills
• Transact SQL (User and System Procedures)

Level: 0 Editions and Features (0.5 day)

• Editions and Licensing
• Features

Level: 1 Administration Basics (3 Days) - includes Lab Session Installation

• Installation on Standalone Server
• Installing Service Packs and Applying Hot Fixes

Disaster Recovery

• Backing Up User Databases
• Performing Full, Differential & Log Backup
• Backing Up Individual Files or Filegroups
• Viewing Backup Metadata
• Restoring User Databases
• Restoring Database from Full/Diff/Log backups
• Restoring a File or Filegroup
• Performing a Piecemeal (PARTIAL) Restore
• About RTO, RPO and Designing Backup Strategy
• System Databases and Disaster Recovery
• Online Restore

Managing Security

• Security Architecture
• Managing Securables , Principals and Permissions
• Keys and Certificates
• Usage of Blockbox Trace
• C2 Level Auditing

Automating Administrative Tasks

• Configuring the SQL Server Agent
• Creating Jobs and Operators
• Create Alerts
• Managing Multiple Servers (using Central Management Server)
• Managing SQL Server Agent Security
• Policy Management
• Resource Governance

Level: 2 Monitoring,Troubleshooting and Optimizing Server/Query Performance (3 Days)

Monitoring and Tuning Server / Database Performance

• Viewing Current Activity
• Using System Monitor
• Using DDL Triggers
• Using Event Notifications
• Server Settings and Database Options

Troubleshooting and Tuning Query Performance

• Using SQL Server Profiler (including Background execution approach)
• Query Processing and Execution
• Importance of Statistics
• Reading and Analyzing Query Plans
• Best Practices for Query Improvements
• Index Architecture and Tuning Indexes
• Reindexing and Index Defragmentation

Troubleshooting Concurrency Problems

• Understanding Isolation Levels
• Snapshot isolation
• Understanding Transaction Processing
• Locking architecture
• Row Versioning
• Controlling Locking
• Troubleshooting Locking / Blocking / Deadlocking

For more details:

Sakthi Software Solutions pvt ltd,

RVR Towers, 4th Floor, No.1, AA Block,
1st Street, 3rd Main Road,
Annanagar, Chennai 600 040.
Landmark: Annanagar Roundtana,
Behind Nalli Silks Showroom,
Phone: 044-43486300 / 45082474/75

website: www.oracledbatraininginchennai.com