Popular Search terms :

Microsoft SQL Server 2005 Administration Training

More Microsoft SQL Server 2005 Administration Categories Operating Systems training - Database training - Microsoft training -
Microsoft SQL Server 2005 Administration Tutorials Online
Product Microsoft SQL Server 2005 Administration Details
Total Time : 7.00 hrs
Number of Movies : 92
Number of Discs : 1
Catalogue Number : 33682
Language : english
Author : Mark Long
Sale Price : $99.95
Qty





View simillar products Operating Systems training - Database training - Microsoft training -
Description Microsoft SQL Server 2005 Administration
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.
Sample - Preview the First 3 chapters of Microsoft SQL Server 2005 Administration video free. Free learning Microsoft SQL Server 2005 Administration online.

Welcome/Introduction
movie image Introduction
movie image SQL Server Overview
movie image SQL Server History
movie image Course Objeectives
movie image Transact SQL
movie image Course Overview
movie image SQL Server Mystique

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

Administrative Tools
movie image Management Studio Overview
movie image Registering Servers
movie image Object Explorer
movie image Executing TSQL Queries
movie image Management Studio Solutions
movie image Server Configuration Manager
movie image SQLCMD
movie image SQLCMD Variables
movie image 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

Sponsors