Guidance Technology Education Support Design Learning Education Certification Assistance Learning Notebook Lessons Teaching Adobe Education DVDs Word Assistance Education Adobe Instruction
Office Software - Excel Software - Microsoft Software - QuickBooks Software - Visual Software - Comptuer Software - Web Software - Sharepoint Software - Photoshop Software - Mac Software - QuarkXPress Software - management Software - Project Software - Learn Software - email Software - Network Software - Linux Software - Unix Software - Work Software - Net Software - ASP Software - PHP Software - HTML Software - CMS Software - XML Software - Mobile Software -
Software PC Instruction Software Programming Instruction Tutoring Laptop Lessons Learning Graphics Support Support IT Advice Tutoring Design Instruction Help Webmaster Advice

Microsoft SQL Server 2005 Administration

Microsoft SQL Server 2005 AdministrationMicrosoft SQL Server 2005 Administration Microsoft SQL Server 2005 Administration
Product Info 458
- - 1
Date Added : 2002-01-21

Price : 99.95
Price : 99.95 Qty
Product Description :

Microsoft SQL Server 2005 Administration

Welcome/Introduction

Introduction
SQL Server Overview
SQL Server History
Course Objeectives
Transact SQL
Course Overview
SQL Server Mystique

Installing SQL Server 2005

SQL Server 2005 Editions
Preparing To Install SQL Server 2005
Hardware Requirements
Working With Previous Versions
SQL Server 2005 Installation
Installing SQL Server 2005 Pt.1
Installing SQL Server 2005 Pt.2
Changing & Deleting SQL Server
Default & Named Instances
Getting Assistance

Administrative Tools

Management Studio Overview
Registering Servers
Object Explorer
Executing TSQL Queries
Management Studio Solutions
Server Configuration Manager
SQLCMD
SQLCMD Variables
Dedicated Administrator Connection

SQL Server Security

Securing 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 Databases

System Databases
System Database Concerns
Sample Database

Databases

Creating 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 Logs

How Transaction Logs Work
Transactions Explained
Explicit & Implicit Transactions
Location, Location, Location
Advantages Of Using Transactions Logs
Transaction Log Options

Data Storage

How SQL Server Stores Data
Fillfactor
DBCC Showcontig

SQL Profiler

Profiler
Using SQL Profiler Part1
Using SQL Profiler Part2

Automating SQL Server

Automation Overview
SQL Server Agent Service
Creating Operators
Creating Jobs Pt.1
Creating Jobs Pt.2
Creating Alerts
Alert Considerations

Database Backups

Backup Strategy
Database Recovery Models
Which Files and When
Performing A Backup
SQL Backup Statement
Transaction Log Backups
Backup Types

Restoring Data

SQL Server Recovery Process
Restoring A Database
The Restore Statement

High Availability

SQL Server High Availability
Clustering
Standby Servers
Log Shipping
Database Mirroring

Database Maintenance

Memory Management Basics
Maintenance Plan Creation

Course Wrap-Up

Course Wrap-Up

Credits

About The Author