DBA

DBA

 This course is a soup-to-nuts course that will teach you everything you need to build, configure a server, maintain a SQL Server disaster recovery plan, and how to design and manage a secure solution. You’ll learn how to automate daily, weekly, and hourly tasks (like backups), the details of security, SQL Server clustering, replication, disaster recovery, and using jobs and database maintenance tasks. This course consists of all practical trouble shooting issue which you arise in day to day activities. Each and every topic is covered with unique case studies. This course is divided into 5 modules and totals more than 40 hours of instructor-led online/onsite training for SQL Server 2008. 

Pre-Requisites: 

Audience: 

This course is intended for IT Professionals who administer and maintain SQL Server databases. 

No prior experience is presumed. 

Software Needed on Each Student PC:

• Windows Server 2003 or 2008, Windows XP Professional, with at least 1GB RAM
• SQL Server 2008

Course Completion: 

After completing this course, students will be able to:

• Install and configure SQL Server 2008
• Manage database files
• Backup and restore databases
• Manage security
• Managing indexes and finding performance bottlenecks
• Automate administrative tasks
• Replicate data between SQL Server instances
• Maintain high availability. [log-shipping, Mirroring]
• Clustering SQL Server

All students will receive:

• More than 500 pages of fully-illustrated case studies courseware
• A copy of Guide to SQL Server Database Administration