Microsoft SQL Server 2008: System Administration Fundamentals

Online Training

Time stretched?

If you would prefer something more flexible, we can now offer Online Training related to this topic.

Click to see a list of courses »

Course Overview

This course is intended for students who need to learn the essential skills necessary to maintain a Microsoft SQL Server 2008 database infrastructure. Being concise and hands on, it is aimed at quickly getting students familiar with the Microsoft SQL Server 2008 administration concepts, tools and utilities. This course is effectively an abridged version of the full 5 day Microsoft SQL Server 2008 System Administration course.

CourseMonster only uses quality Microsoft training suppliers who have been through our rigorous standards to ensure that you receive the best quality training available.

Related Courses

Audience

This course is for delegates who need to learn the essential skills necessary to maintain a Microsoft SQL Server 2008 database infrastructure.

Skills Gained

Upon successful completion of this course, students will be able to:

Perform an Installation of SQL Server 2008
Configure SQL Server Post Installation
Plan and Create Databases
Configure and Manage Databases
Create a Database Schema
Create Tables in a Database
Understand and Implement Data Integrity
Understand and Implement SQL Server Indexes
Understand and Implement SQL Server 2008 Security
Understand Data Transfer Utilities
Create and Implement Database Snapshots
Automate Tasks in SQL Server 2008
Use the SQL Server 2008 Tools and Utilities to Monitor Performance

Prerequisites

An understanding of working in a Microsoft Windows operating system environment.
An understanding of relational databases and design principles.
Some experience of the SQL language would be beneficial.

Course Outline

1. Install and Configure SQL Server 2008

Installation Prerequisites The Installation Process Post Install Configuration Options

2. Creating, Configuring and Managing Databases

Creating a Database Configuring and Managing a Database Database Schemas

3. Creating and Managing Tables

Creating a Table Native SQL Server Data Types Columns and Column Properties

4. Implementing and Managing Data Integrity

Introducing Data Integrity Using Constraints to Implement Data Integrity

5. Creating and Managing Indexes

SQL Server Index Architecture Creating Clustered Indexes Creating Non Clustered Indexes

6. SQL Server 2008 Security

Overview of SQL Server Security Security at the Server Level Security at the Database Level

7. Transferring Data

Overview of Data Transfer Examining the Data Transfer Utilities Bulk Loading Data Using the Import/Export Wizard Introducing SQL Server Integration Services (SSIS)

8. Backups and Recovery

Backup Types and Strategies Backing up a Database Restoring a Database Online Restore Operations Database Snapshots Recovering System Databases

9. SQL Server Automation

Overview of SQL Server Automation The SQL Server Agent Service Creating Maintenance Plans Creating and Managing Jobs Creating and Managing Operators Creating and Managing Alerts