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

SQL Server Backup & Recovery

• Overview of SQL Server backup & recovery
• Incremental backups
• Restoring a SQL Server database
• Planning a Backup Strategy
• Restoring to point-in-time.

SQL Server Security management

• Windows security management for the server
• Windows and SQL authentication mode
• SQL Server rights and role management
• Creating Logins, assigning Server roles
• Creating Users and assigning DB Roles
• Managing object level and column level permissions

SQL Server database Replication

• Overview on replication
• Types of replications
• Configuring SQL Server replication
• New Features in replication in SQL 2008
• Trouble shooting Replication issues.
• Selecting the type of replication as per the business requirement.

   Implementing High Availability and Disaster Recovery  

• Implement database mirroring.
• Prepare databases for database mirroring. 
• Create endpoints.
• Specify database partners.
• Specify a witness server.
• Configure an operating mode.
• Implement log shipping.
• Initialize a secondary database.
• Configure log shipping options.
• Configure a log shipping mode.
• Configure monitoring.

  SQL Server Automation

• Configuring Database mail
• Configuring the operators
• Setting SQL Server and server alert thresholds
• Common database scheduled jobs
• Scheduling multi-step job streams
• Configuring the proxies
• Making the best use of proxies.
• Reading SQL Server Error Logs
• Analyzing the SQL Server Error Logs

 Monitoring and Troubleshooting SQL Server Performance 

• Gather performance and optimization data by using the SQL Server Profiler.
• Start a new trace.
• Save the trace logs.
• Configure SQL Server Profiler trace properties.
• Configure a System Monitor counter log.
• Correlate a SQL Server Profiler trace with System Monitor log data.
• Gather performance and optimization data by using the Database Engine Tuning Advisor.
• Build a workload file by using the SQL Server Profiler.
• Tune a workload file by using the Database Engine Tuning Advisor

 SQL Server Integration Services and Reporting Services

• Overview on integration services
• Overview on reporting services
• Configuring the Report server
• Deploying the SSIS Packages
• Scheduling the SSIS Packages
• Deploying the reports in IIS Server
• View the reports in IE,PDF file format and others