Pre-requisites - 
IT professionals, who need the fundamental skills to install, maintain, administer and troubleshoot Microsoft SQL Server 2005 and / or SQL Server 2008.

 Objective-
At the end of this course you will be able to:
1. Install Microsoft SQL Server 2005 and / or 2008 and the associated bundled tools
2. Understand the many tools that facilitate effective Database Administration
3. Monitor the smooth running of the Database Server
4. Maintain the Database and Indexes 
5. Setup and control Database Security 
6. Cope effectively with Database Disaster Recovery
7. Implement High Availability and Replication
8. Use relevant TSQL commands
9. Understand the basics of Integration Services 
10. Implement SQL Server Full-text search

Course Contents: 
The History of SQL Server and relational databases

• Relational database history
• The evolution of SQL Server
• SQL Server and ANSI standards

Installing and configuring SQL Server

• Pre-installation steps
• Installing SQL Server
• Configuring the run-time SQL Server system
• Patching SQL Server - Service packs

SQL Server data storage management

• SQL Server file management architecture
• Creating database files
• Creating SQL Server log files
• Using SQL Server file groups

Managing data with the DTS utility

• Using DTS to export and import SQL Server table data

SQL Server Security management

• Windows security management for the server
• Windows authentication mode
• SQL Server rights and role management

SQL Server Backup & Recovery

• Overview of SQL Server backup & recovery
• Incremental backups
• Restoring a SQL Server database
• Standby database overview
• Shipping SQL Server log files to standby databases

SQL Server database Replication

• Microsoft replication architectures
• Creating a replication topology
• Configuring SQL Server replication

SQL Server Job scheduling

• Common database scheduled jobs
• Configuring SQLMail
• Setting SQL Server and server alert thresholds
• Creating customized error conditions
• Scheduling multi-step job stream