SQL Server Administrator Course
Duration 4 days
Objectives
A 4-day intensive on SQL Server Database Administration. This course is unique in that it is aimed at the practical, real world deployment of SQL server, rather than the tick-box approach offered by other courses.
The overall goal is to provide Database Adminstrators with key knowledge and expertise based on commercial usage of SQL Server, combined with an explanation of industry best practice in SQL Server Administration.
Our trainer comes with excellent credentials since he is an MS Certified developer and crucially he posseses in-depth commercial experience. This ensures your training is highly relevant to industry needs and the skills you obtain will provide the right foundation for you to successfully administer SQLServer, based on tried-and-tested techniques and practices.
This course can be customised to me meet private client learning requirements. Requirements
Previous SQL Administrator knowledge is helpful but not essential. Good working knowledge of Windows XP, and Windows Server 2003. Ideally, delegates will have completed our SQLServer Developer & Administrator Foundation.
Course Outline
SQL Server Overview
• Database Architecture Essentials
• Database Design Essentials
Installation
• Guide to Installing SQL Server
• About the different versions of SQL Server
• SQL Server Licensing issues
• Localisation
• Common pitfalls during Installation
Security
• Managing server level security
• Managing database level security
• Managing object level permissions
Backing up and restoring databases
• Recovery models
• Backing up a database and/or log file
• Restoring a database and/or log file
• Restoring system databases
Replication
Replication
• What is Replication
• Strategies for Replication at Enterprise Level
• When Replication may not be the best solution
SQL Mail
• Configuring mail support
• Creating a mail profile
• Using xp sendmail to send an email
SQL Server Jobs
• Creating scheduled jobs
• Creating job steps
• Viewing the job history
Performance and Maintenance
• Allocating memory to SQL Server
• Notes on best practices
• Managing database files
• Managing database consistency
• Query Tuning
Wrap-up
• QandA
• Further reading and resources
• Recommended next steps
| 
