Become a member

Online Access to 1000+ Courses!

Microsoft SQL Server 2005 Administration Course

Author : Mark Long

7hrs (92 Lessons) 2006-03-16

This Course can only be played using a subscription. You can play only first 3 chapters for free. Click Here to avail a subscription
SQL Server 2005 is the latest release from Microsoft 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.

Transcription not available

Course: Microsoft SQL Server 2005 Administration
Author: Mark Long
SKU: 33682
ISBN: 1-933736-11-9
Work Files: Yes
Captions: No
Subject: Databases
The first 3 chapters of courses are available to play for FREE (first chapter only for QuickStart! and MasterClass! courses). Just click on the movie link to play a lesson.

Download WorkFiles

Pricing & availability

Lifetime online access to this course

US$ 39.00

Download for offline access

US$ 79.95

Subscribe to 1000+ courses

Starting at $30/month

Course outline

Welcome/Introduction

Introduction (02:08)

SQL Server Overview (03:24)

SQL Server History (04:46)

Course Objeectives (01:56)

Transact SQL (03:58)

Course Overview (03:52)

SQL Server Mystique (02:51)

Installing SQL Server 2005

SQL Server 2005 Editions (04:27)

Preparing To Install SQL Server 2005 (03:25)

Hardware Requirements (04:27)

Working With Previous Versions (04:10)

SQL Server 2005 Installation (02:19)

Installing SQL Server 2005 Pt.1 (05:09)

Installing SQL Server 2005 Pt.2 (03:40)

Changing & Deleting SQL Server (02:52)

Default & Named Instances (05:13)

Getting Assistance (05:20)

Administrative Tools

Management Studio Overview (04:41)

Registering Servers (03:46)

Object Explorer (03:21)

Executing TSQL Queries (03:00)

Management Studio Solutions (04:12)

Server Configuration Manager (02:59)

SQLCMD (02:35)

SQLCMD Variables (04:03)

Dedicated Administrator Connection (03:25)

SQL Server Security

Securing SQL Server 2005 (03:05)

Authentication Modes Pt.1 (04:30)

Authentication Modes Pt.2 (04:43)

Principles (03:10)

Permissions (03:31)

Securables (02:45)

Managing Logins (05:05)

Managing Users (03:24)

Schemas (03:33)

Managing Schemas (04:07)

Managing Permissions (04:15)

Managing Server Permissions (02:37)

Managing Database Permissions (02:23)

TSQL Permissions (01:28)

System Databases

System Databases (06:00)

System Database Concerns (02:29)

Sample Database (04:05)

Databases

Creating A Database Pt.1 (04:41)

Creating A Database Pt.2 (03:05)

Database Properties & Options (05:27)

Generating Scripts (05:06)

Shrinking Database Files (04:31)

Creating Tables Pt.1 (05:48)

Creating Tables Pt.2 (03:03)

Datatypes Pt.1 (05:20)

Datatypes Pt.2 (05:51)

Primary & Foreign Keys (04:10)

Diagrams (05:44)

Transaction Logs

How Transaction Logs Work (03:45)

Transactions Explained (05:14)

Explicit & Implicit Transactions (05:28)

Location, Location, Location (03:27)

Advantages Of Using Transactions Logs (03:40)

Transaction Log Options (04:45)

Data Storage

How SQL Server Stores Data (05:03)

Fillfactor (05:12)

DBCC Showcontig (06:05)

SQL Profiler

Profiler (04:06)

Using SQL Profiler Part1 (04:24)

Using SQL Profiler Part2 (05:08)

Automating SQL Server

Automation Overview (04:34)

SQL Server Agent Service (02:57)

Creating Operators (03:22)

Creating Jobs Pt.1 (05:33)

Creating Jobs Pt.2 (05:45)

Creating Alerts (06:05)

Alert Considerations (03:57)

Database Backups

Backup Strategy (03:35)

Database Recovery Models (05:48)

Which Files and When (02:41)

Performing A Backup (03:47)

SQL Backup Statement (03:36)

Transaction Log Backups (02:45)

Backup Types (05:39)

Restoring Data

SQL Server Recovery Process (04:46)

Restoring A Database (03:13)

The Restore Statement (03:29)

High Availability

SQL Server High Availability (02:53)

Clustering (02:21)

Standby Servers (05:13)

Log Shipping (05:58)

Database Mirroring (03:08)

Database Maintenance

Memory Management Basics (04:37)

Maintenance Plan Creation (06:14)

Course Wrap-Up

Course Wrap-Up (02:41)

Credits

About The Author (01:48)