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
SQL Server 2012 Administration
5 Days
Maintaining SQL Server using PowerShell
3 Days

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]