Microsoft SQL Server 2008 System Administration Fundamentals

Course:   SSADMF
Duration:   3 Days
Level:   I
On our website at:   http://www.verhoef-training.com/courses/SSADMF.html
 
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.

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:

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.

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.