SQL Server 2005 tutorials : learn quickly/cost-effectively with this 'SQL Server 2005' training course.

Duration: 7 hrs / 92 video lessons

Tutorial Intro

• Intro
• SQL Server - The Basics
• SQL Server History
• Course Objectives
• Transact SQL Explained
• Tutorial Overview
• SQL Server Mystique

SQL Server 2005 Installation

• SQL Server 2005 Editions
• Installation Preparation SQL Server 2005
• H/W Requirements
• Working With Previous Versions
• SQL Server 2005 Installation
• Installing SQL Server 2005 - Tuition 1
• Installing SQL Server 2005 - Tuition 2
• Changing and Deleting SQL Server
• Default and Named Instances
• Gaining Assistance

Administrative Tools

• Management Studio Overview
• Registering Servers
• Object Explorer
• Executing TSQL Queries
• Management Studio Solutions
• Server Config Manager
• SQLCMD
• SQLCMD Variables
• Dedicated Admin Connection

SQL Server Security

• Securing SQL Server 2005
• Authentication Modes - Tuition 1
• Authentication Modes - Tuition 2
• Principles Overview
• Permissions Explained
• Securables
• Handling Logins
• Handling Users
• Schemas
• Managing Schemas
• Managing Permissions - Step by Step
• Managing Server Permissions
• Managing Database Permissions
• TSQL Permissions

System Databases

• Chapter Overview
• System Database Concerns
• Sample Database

Databases

• Creating A Database - Lesson 1
• Creating A Database - Lesson 2
• Database Properties and Database Options
• How to Generate Scripts
• Shrinking Database Files
• The Creation of Tables - Lesson 1
• The Creation of Tables - Lesson 2
• Datatypes - Lesson 1
• Datatypes - Lesson 2
• Primary & Foreign Keys
• Diagrams

Transaction Logs

• Transaction Logs Explained
• Transactions Explained
• Explicit Transactions
• Implicit Transactions
• Location, Location, Location
• The Advantage Of Using Transactions Logs
• Transaction Log Options Explained

Data Storage

• How SQL Server Stores Data
• Fillfactor Explained
• DBCC Showcontig

SQL Profiler

• Profiler
• Using SQL Profiler - Lesson 1
• Using SQL Profiler - Lesson 2

Automating SQL Server

• Chapter Overview
• SQL Server Agent Service
• Creating Operators
• Creating Jobs - lesson 1
• Creating Jobs - lesson 2
• How to Create Alerts
• Considerations for Alerts

Database Backups

• Backup Strategy
• Database Recovery Models Explained
• Which Files and When
• How to Perform A Backup
• SQL Backup Statement
• Taking Transaction Log Backups
• Backup Types Described

Restoring Data

• SQL Server Recovery Process
• How to Restore A Database
• The Restore Statement

High Availability

• SQL Server High Availability
• Clustering
• Using Standby Servers
• Log Shipping
• Database Mirroring Explained

Database Maintenance

• Memory Management Fundamentals
• Maintenance Plan Creation

Course Wrap-Up

• Tutorial Wrap-Up