Tutorials and Online Training Videos

Microsoft SQL Server 2008 Administration Tutorial


In SQL Server 2008 Administration, Microsoft Certified Trainer Mark Long helps you understand the installation and administrative functions of Microsoft's SQL Server 2008. SQL Server 2008 delivers on Microsoft's Data Platform vision by helping your organization manage any data, any place, any time. SQL Server 2008 delivers a rich set of integrated services that enable you to do more with your data such as query, search, synchronize, report, and analyze. It is the third largest market share data base product in the world. SQL Server 2008 reduces time and cost of management and development of application while providing a comprehensive platform that delivers intelligence where your users want it. To begin learning today, simply click on the movie links.

Introduction

Welcome
Course Overview
SQL Server Basics
Getting Hands On
Microsoft SQL Certifications
SQL Server Editions

Installing SQL Server 2008

Hardware Requirements
SQL Server Instances
SQL Server Components
Collation Choices
Service Accounts
Creating Service Accounts
Installing SQL Server 2008 pt. 1
Installing SQL Server 2008 pt. 2
Installing SQL Server 2008 pt. 3
Upgrading SQL Server 2008
SQL Server Configuration Manager
SQL Server Authentication Modes
Changing Authentication Modes
SQL Server Management Studio

SQL Server 2008 Databases

File Types
Transaction Log
System Databases
File Placement
Creating a Database
Autogrowth
Database Options
Sizing the Transaction Log
Schemas
Default Schema
Creating a Schema
Moving Data Files
Installing Sample Databases pt. 1
Installing Sample Databases pt. 2

Maintaining SQL Server

Hiding System Objects
SQL Server Agent
Creating a Maintenance Plan
Understanding Operators
Understanding Jobs
Understanding Alerts

Server Management

SQL Server Options
Registering Servers
Server Configuration
Activity Monitor
Database Mail pt. 1
Database Mail pt. 2
Database Mail pt. 3

Maintaining The Database

Maintaining the Database
Database Backup pt. 1
Database Backup pt. 2
Backup Compression
Backup Devices
Managing the Transaction Log
Restoring the Database

Monitoring & Troubleshooting

Dedicated Administrator Connection
SQL Profiler pt. 1
SQL Profiler pt. 2
Log File Viewer
Event Forwarding

Optimizing Performance

Using Filegroups
Partitions
Partition Planning
Database Tuning Advisor pt. 1
Database Tuning Advisor pt. 2

High Availability

High Availability Options
Failover Clustering
Database Mirroring
Log Shipping

Conclusion

Course Wrap Up

Credits

About the Author


Related Books on Microsoft SQL Server 2008 Administration







Save $80 on the
DROID BIONIC
by Motorola with Verizon Wireless service for less than from Verizon Wireless directly.
Save $80 on DROID BIONIC
More Cell Phone Discounts