SQL Server 2005 is Microsoft s latest release of their enterprise database solution product. SQL Server 2005 is the result of five years of research, development and collection of suggestions and wish lists from database administrators and developers. Microsoft continues to drive the enterprise database market with the added features and capabilities of this new product. Microsoft Certified Database Administrator and Certified Trainer Mark Long covers the basics of SQL Server 2005 administration in this course. To begin learning simply click the links.
Welcome/IntroductionIntroductionSQL Server OverviewSQL Server HistoryCourse ObjeectivesTransact SQLCourse OverviewSQL Server MystiqueInstalling SQL Server 2005SQL Server 2005 EditionsPreparing To Install SQL Server 2005Hardware RequirementsWorking With Previous VersionsSQL Server 2005 InstallationInstalling SQL Server 2005 Pt.1Installing SQL Server 2005 Pt.2Changing && Deleting SQL ServerDefault && Named InstancesGetting AssistanceAdministrative ToolsManagement Studio OverviewRegistering ServersObject ExplorerExecuting TSQL QueriesManagement Studio SolutionsServer Configuration ManagerSQLCMDSQLCMD VariablesDedicated Administrator ConnectionSQL Server SecuritySecuring SQL Server 2005
Authentication Modes Pt.1
Authentication Modes Pt.2
Principles
Permissions
Securables
Managing Logins
Managing Users
Schemas
Managing Schemas
Managing Permissions
Managing Server Permissions
Managing Database Permissions
TSQL Permissions
System DatabasesSystem Databases
System Database Concerns
Sample Database
DatabasesCreating A Database Pt.1
Creating A Database Pt.2
Database Properties && Options
Generating Scripts
Shrinking Database Files
Creating Tables Pt.1
Creating Tables Pt.2
Datatypes Pt.1
Datatypes Pt.2
Primary && Foreign Keys
Diagrams
Transaction LogsHow Transaction Logs Work
Transactions Explained
Explicit && Implicit Transactions
Location, Location, Location
Advantages Of Using Transactions Logs
Transaction Log Options
Data StorageHow SQL Server Stores Data
Fillfactor
DBCC Showcontig
SQL ProfilerProfiler
Using SQL Profiler Part1
Using SQL Profiler Part2
Automating SQL ServerAutomation Overview
SQL Server Agent Service
Creating Operators
Creating Jobs Pt.1
Creating Jobs Pt.2
Creating Alerts
Alert Considerations
Database BackupsBackup Strategy
Database Recovery Models
Which Files and When
Performing A Backup
SQL Backup Statement
Transaction Log Backups
Backup Types
Restoring DataSQL Server Recovery Process
Restoring A Database
The Restore Statement
High AvailabilitySQL Server High Availability
Clustering
Standby Servers
Log Shipping
Database Mirroring
Database MaintenanceMemory Management Basics
Maintenance Plan Creation
Course Wrap-UpCourse Wrap-Up
CreditsAbout The Author
Click here to find out more about the Microsoft SQL Server 2005 Administration Training CD 
