Accelebrate's SQL Server 2008 Administration training teaches administrators how to successfully administer SQL Server 2008. Note: This course can also be taught using SQL Server 2008 R2.

Course Number:

SQL-212

Duration:

4 Location and Pricing

Most Accelebrate courses are delivered as private, customized, on-site training at our clients' locations worldwide for groups of 3 or more attendees and are custom tailored to their specific needs. Please visit our client list to see organizations for whom we have delivered private in-house training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote for private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. See a schedule of online courses.

SQL Server 2008 Administration Training Objectives

Install and configure Microsoft SQL Server 2008
Create databases and tables
Implement indexes and partitions
Take database snapshots
Implement service broker for asynchronous processing of database requests
Create and use full-text indexes
Secure SQL Server and implement policy-based management
Recover data
Automate administrative tasks with the SQL Server Agent
Use Dynamic Management Views to monitor the database and troubleshoot problems
Configure SQL Server for high availability using failover clustering, database mirroring, log shipping, and replication

SQL Server 2008 Administration Training Outline

Expand All | Collapse All | Printer-Friendly

Overview of Microsoft SQL Server 2008

Database Engine

Business Intelligence

Installing and Configuring SQL Server 2008

Editions of SQL Server 2008

Infrastructure Requirements

Service Accounts

Collation Sequences

Authentication Modes

SQL Server Instances

Upgrading to SQL Server 2008

Installing SQL Server 2008

Using the Tools in SQL Server 2008

SQL Server Documentation

Management Tools in SQL Server 2008

Performance Management Tools

Business Intelligence Tools

Creating Databases

SQL Server System Databases

SQL Server Database Structure

Creating a Database

Moving Databases

Designing Tables

Naming Objects

Schemas

Data Types

Column Properties

Creating Tables

Computed Columns

Sparse Columns

Constraints

Database Diagrams

Indexes

Index Structure

Clustered Indexes

Nonclustered Indexes

Included Columns

Filtered Indexes

Online Index Creation

Index Management and Maintenance

XML Indexes

Spatial Indexes

Partitioning

Partition Functions

Partition Schemes

Partitioning Tables and Indexes

Managing Partitions

Database Snapshots

Creating a Database Snapshot

Reverting Data Using a Database Snapshot

Service Broker

Service Broker Architecture

Message Types and Contracts

Queues and Services

Conversations

Sending and Receiving Messages

Queue Activation

Prioritization

Full-Text Indexing

Full-Text Catalogs

Full-Text Indexes

Querying Full-Text Data

Security

Configuring the Attack Surface

Endpoints

Principals, Securables, and Permissions

CLR Security

Data Encryption

Policy-Based Management

Overview of Policy-Based Management

Facets

Conditions

Policy Targets

Policies

Policy Categories

Policy Compliance

Data Recovery

Database Backups

Recovery Models

Database Restores

SQL Server Agent

Creating Jobs

Creating Maintenance Plans

Creating Alerts

Dynamic Management Views

Overview of DMVs

Retrieving Object Metadata

Database Diagnostics

High Availability

Failover Clustering

Database Mirroring

Log Shipping

Replication

Conclusion

Prerequisites:

No prior experience is presumed.

Training Materials:

All attendees receive a copy of Microsoft Press's SQL Server 2008 Step-by-Step.

Software needed for each student PC:

Windows Server 2003 or later, with the latest service pack updates and at least 3 GB RAM
A full installation of SQL Server 2008 or 2008 R2 with the latest service packs installed
Related sample databases and lab files that Accelebrate will provide
If you have purchased this course, please contact us for detailed setup instructions.
For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor's screen simultaneously with working on their own.

Related Courses:

35%

Lecture/Demo

65%

Lab

Software needed for each student PC:

Windows Server 2003 or later, with the latest service pack updates and at least 3 GB RAM
A full installation of SQL Server 2008 or 2008 R2 with the latest service packs installed
Related sample databases and lab files that Accelebrate will provide
If you have purchased this course, please contact us for detailed setup instructions.
For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor's screen simultaneously with working on their own.

Please see our complete list of
Microsoft Official Courses

Recent Training Locations

United States

Alabama

Hunstville

Montgomery / Birmingham

Alaska

Anchorage

Arizona

Phoenix

Tucson

Arkansas

Fayetteville / Little Rock

California

San Francisco /

Oakland / San Jose

Orange County / Los Angeles

Sacramento

San Diego

Colorado

Denver /

Boulder / Colorado Springs

Connecticut

Hartford

Washington

Florida

Fort Lauderdale / Miami

Jacksonville

Orlando

Saint Petersburg / Tampa

Georgia

Atlanta

Augusta & Savannah

Idaho

Boise

Illinois

Chicago

Indiana

Indianapolis

Iowa

Cedar Rapids / Des Moines

Kansas

Wichita

Kentucky

Lexington / Louisville

Louisiana

Baton Rouge / Orleans

Maine

Portland

Maryland

Annapolis / Baltimore

Hagerstown & Frederick

Massachusetts

Springfield

Boston / Cambridge

Michigan

Ann Arbor / Detroit

Grand Rapids

Minnesota

Saint Paul / Minneapolis

Mississippi

Jackson

Missouri

Kansas City

St. Louis

Nebraska

Lincoln / Omaha

Nevada

Reno and Las Vegas

New Jersey

Princeton

New Mexico

Albuquerque

New York

Buffalo

Albany

White Plains / York City

North Carolina

Charlotte

Durham / Raleigh

Ohio

Canton / Akron

Cincinnati

Cleveland & Columbus

Dayton

Oklahoma

Tulsa / Oklahoma City

Oregon

Portland

Pennsylvania

Pittsburgh

Philadelphia

Rhode Island

Providence

South Carolina

Columbia & Charleston

Spartanburg & Greenville

Tennessee

Memphis / Nashville

Knoxville

Texas

Dallas

El Paso

Houston

San Antonio / Austin

Utah

Salt Lake City

Virginia

Richmond / Alexandria / Arlington

Washington

Tacoma / Seattle

West Virginia

Charleston

Wisconsin

Madison / Milwaukee

Canada

Alberta

Edmonton / Calgary

British Columbia

Vancouver

Nova Scotia

Halifax

Ontario

Ottawa

Toronto

Quebec

Montreal

Puerto Rico

San Juan

ACCELERATED LEARNING, CELEBRATED RESULTS ®

Introduction to SQL Server 2008 for Administrators

35%

65%

Course Number:

SQL-212

Duration:

4

Location and Pricing

SQL Server 2008 Administration Training Objectives

SQL Server 2008 Administration Training Outline

Prerequisites:

Training Materials:

Software needed for each student PC:

Related Courses:

35%

65%

Course Number:

SQL-212

Duration:

4 Days

Prerequisites:

Training Materials:

Software needed for each student PC:

Related Courses:

Contact Us:

Subscribe to our Newsletter:

Recent Training Locations

United States

Canada

Puerto Rico