SQL Server 2008 Essential Administration Course
Course DescriptionThis course is at aimed anyone charged with administering a SQL Server 2008 database system. It focuses on only the core administration responsibilities enabling new SQL Server 2008 database administrators to build the skills necessary to install, configure and support a simple SQL Server deployment. The objective is to provide the essential skills for managing a single instance system, enabling administrators to get up and running to a basic level fairly quickly, but also to provide an awareness of some of the more advanced services available.
This course can be followed by a number of additional courses focussing on different specialisations and services available for SQL Server deployments.
This course, along with the SQL Server 2008 Advanced Administration Course, helps to prepare delegates for the 70-432 Microsoft MCTS exam. It should be noted, however, that all course attendances should be complemented by reference to the skills measured by the exam, a period of self-study and test exams before sitting the actual exam. |
£895 3 day course Scheduled Dates: 12 March 2012 10 April 2012 08 May 2012 06 June 2012 02 July 2012 Location: PTR's Training Centre Wokingham, Berkshire. |
Course pre-requisites:
Delegates attending this course should have as a minimum a basic understanding of relational databases and the SQL language, up to the level provided by the PTR “SQL for SQL Server Course”, but would benefit from having attended the “Introduction to Transact SQL Course” as well.
Topics covered on the 3 day SQL Server 2008 Essential Administration course
Installing and Configuring SQL Server
- Preparing to Install SQL Server
- Installing SQL Server
- Configuring a SQL Server Installation
- Configuration Manager
- Management Studio Server Properties
- sp_configure
Managing Databases and Files
- Planning Databases
- Creating Databases
- File groups and Data Files
- Transaction Log Files
- Managing Databases
- Options
- Attaching and detaching
Disaster Recovery
- Planning a Backup Strategy
- Backing Up User & System Databases
- Restoring User Databases
- Performing Online Restore Operations
- Recovering Data from Database Snapshots
- System Databases and Disaster Recovery
Managing Security
- Overview of SQL Server Security
- Protecting the Server Scope
- Protecting the Database Scope
- Protecting the Server Scope
- Auditing Security
Establishing Client Connectivity
- Network Libraries
- ODBC & OLE-DB connections
- SQL Native Client
- Configuring Server Connectivity Settings
Automating Administrative Tasks
- Automating Administrative Tasks in SQL Server
- Using SQL Server Agent
- Creating Maintenance Plans
- Implementing Alerts
- Managing Multiple Servers
- Managing SQL Server Agent security
Monitoring SQL Server
- Viewing Current Activity
- Using SQL Server Profiler
An Introduction To Troubleshooting and Performance Tuning
- Troubleshooting SQL Server
- Performance Tuning in SQL Server
An Overview of Other Services
- An Overview of Replication Service
- An Overview of High Availability Services
- An Overview of Integration Services
- An Overview of Service Broker
- An Overview of Common Language Runtime
Course Classification:
Technical Training Course
This is an instructor led training course taught in a classroom based environment.
Scheduled course dates
12 March 2012 to 14 March 2012
10 April 2012 to 12 April 2012
08 May 2012 to 10 May 2012
06 June 2012 to 08 June 2012
02 July 2012 to 04 July 2012
Not the right course? Browse the index of all SQL Server 2008 modules covered across the courses.
View full schedule of Generic courses
View full schedule of SQL Server 2008 courses
Print / Download PDF Version of full course schedule
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite SQL Server 2008 Training and bespoke SQL Server 2008 courses