Microsoft SQL Server 2008 System Administration Fundamentals

Course: SSADMF

Duration: 3 Days

Level: I

Course Summary

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. 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.

« Hide The Details

Topics Covered In This Course

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

What You Can Expect

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
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

Recommended 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.

« Hide The Details

Related Courses

Code	Course Title	Duration	Level
SSADM	SQL Server 2012 Administration	5 Days	I	Details
PSSQLS	Maintaining SQL Server using PowerShell	3 Days	II	Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.

Notify me the next time this course is confirmed!

Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]