SQL Server 2005 Administration

SQL Server 2005 Administration

Click on the links next to the red icons

below to view the free movies.
Click here to setup a login account and view all of the movies.

Basic Administration
	Installing SQL Server 2005	NOTES

1) These Movies Have Sound.

2) The Flash Plug-in is Required to

View the Movies.

Creating a Database Diagram

Running a TSQL Query

Configuration Manager

Transaction Logs

Transaction Log Options

System Databases

SQL Server Security
	Authentication Modes

Adding a Windows Login

Creating a SQL Account

Database Login Security Options

Managing Schemas

Automating SQL Server
	SQL Agent

Setting Up Database Mail

Configure SQL Agent

Create an Operator

Create a Job

View Job History

Creating an Alert

Backup/Restore
	Recovery Model

Backing Up a Database

Restoring a Database

Other Tools
	Generating Server Reports

SQL Profiler


STANDARD PLAN			Access To Every Tutorial 24 Hours 7 Days A Week Learn More or ORDER NOW See Sales Demo>>

PREMIUM PLAN			Access to Every Tutorial 24 Hours 7 Days A Week Access to the IPOD Ready Tutorial Market Place Offline and Online Access Practice Tests Flash Cards End of Movie Quizzes Learn More or ORDER NOW See Sales Demo>>

LMS (Learning Management System) PLAN			Access to Every Tutorial 24 Hours 7 Days A Week Access to the IPOD Ready Tutorial Market Place Offline and Online Access Practice Tests Flash Cards End of Movie Quizzes Access to the Administrator Control Panel Assign Homework to Users Assign Pre & Post Tests Track All Results Learn More or ORDER NOW See LMS Demo>>