The basic Administration course acts as an introduction to SQL DBA, using easy-to-understand processes and language. The goal of this course is to allow a user to administer SQL Server Databases, and to provide a detailed understanding of the DBA features of SQL Server and T-SQL syntax for the DBA.

This is a two day course and each module comes with a workshop to ensure that attendees understand the course content, and are able to go away and perform DBA activities in their organisation. It provides a solid foundation for anyone looking to perform DBA activities in their organisation and is designed by experienced SQL DBA’s at Avoca to cover vital aspects of this position.

Installation and Configuration of Microsoft SQL Server 2008 and associated bundled tools

SQL Server 2008 bundled programs and features
Pre-installation steps
Installation of SQL Server 2008
Configuring services, instances and service accounts
SQL Server file management architecture
Patching SQL Server with service packs
Database Creation, Management and Best Practices

 

Setup and control Database Security

Advanced user permissions and authentication
SQL Server rights and role management
Designing schemas
Assigning users to roles

 

Automation and Performance

SQL Server Agent
Job Scheduling
Performance Optimization

 

Monitoring and Database Management

Administering SQL Server 2008 with graphical tools and Transact-SQL
SQL mail, Events, Alerts and Logging
Handling dynamic database growth and reclaiming space
Detaching and attaching databases
Backing up, Moving and restoring of databases

 

Cope effectively with Database Disaster Recovery

Planning a backup strategy
Backup Devices, Backup Sets, Database Dumps and Media Sets
Recovering and Restoring Databases
Overview of replication