Call us : (+91) 9177166122

Adv DBA Online Training Course

Adv DBA

Highlights

·  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

Ø  Replication

Ø  Mirroring

Ø  Clustering

Ø  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

§  SCOM

§  Tivoli

 

  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

§  SLA

§  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