· Hands on scenario based training with working experts and authors.
· Real time issues discussion.
· Daily tasks and troubleshooting scenarios.
· Weekly seminars on interview tips.
Placement Oriented SQL DBA Real Time Program
1. DBA Working environment
2. Internals of
Ø Logging & Recovery in SQL Server
Ø Log shipping
Ø Performance tuning Basics
3. Third party Tools
§ Overview and advantages
§ How to deal with third party vendors
§ Backup and Restoration tools
§ Performance & Monitoring tools-Administrating multiple servers
§ Netback up
§ SQL Monitor
4. Troubleshooting Real Time Scenarios
Ø Installation Troubleshooting
Ø How to fix MSI files
Ø Rollover Service Pack and Cumulative updates
Ø Transaction Log Full How to fix?
Ø Temp DB Full errors How to fix?
Ø Database corruptions How to fix?
Ø Backups troubleshooting
Ø Troubleshooting – SQL Server Jobs]
Ø Problems up gradation
Ø Troubleshooting Log Shipping, Mirroring, Replication regular issues and Clustering issues.
Ø Security change tasks
Ø Troubleshooting query performance.
Ø How do you trace the traffic hitting a SQL Server?
4. ITIL Process
§ Incident Management, Change Management, Request Management, Problem Management
5. Ticketing Mechanism & Tools
§ BMC Remedy
§ Ticket Priorities
6. Escalation Mechanism
§ Inventory management – Server, database, backup
§ SOX complains
7. Auditing Mechanisms
8. Final Steps
§ Resume Preparation tips
§ Critical issue(s) faced in career & solution.
§ Test interviews
§ Placement assistance