SQL Server 2008 Administration Fundamentals

Course Description
Course Outline

Course Overview

This course is 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.

Course Objective

Perform an Installation of SQL Server 200
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 Index
Understand and Implement SQL Server 2008 Security
Understand Data Transfer Utilities
Backup and Restore Databases
Create and Implement Database Snapshots
Automate Tasks in SQL Server 2008
Use the SQL Server 2008 Tools and Utilities to Monitor Performance

Target student

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

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

We offer a range of SQL Server training courses

Install and Configure SQL Server 2008
Installation Prerequisites The Installation Process Post Install Configuration Options
Creating, Configuring and Managing Databases
Creating a Database Configuring and Managing a Database Database Schemas
Creating and Managing Tables
Creating a Table Native SQL Server Data Types Columns and Column Properties
Implementing and Managing Data Integrity
Introducing Data Integrity Using Constraints to Implement Data Integrity
Creating and Managing Indexes
SQL Server Index Architecture Creating Clustered Indexes Creating Non-Clustered Indexes
SQL Server 2008 Security
Overview of SQL Server Security Security at the Server Level Security at the Database Level
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)
Backups and Recovery
Backup Types and Strategies Backing up a Database Restoring a Database Online Restore Operations Database Snapshots Recovering System Databases
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
Monitoring SQL Server
Overview of Performance Monitoring Viewing the Current Activity Using System Monitor Using SQL Server Profiler

Publisher:	Microsoft
Version:	2008
Length:	3 Days
Course-ID:	SX616A

	Printer Friendly Version
	Download Outline As PDF

Related Courses

Small group, relaxed and open atmosphere. Felt comfortable admitting being lost or confused

- British Gas