《MS SQL Server 2005管理员教程》VTC Microsoft SQL Server 2005 Administration[Bin]

中文名称：MS SQL Server 2005管理员教程
VTC Microsoft SQL Server 2005 Administration
资源类型：Bin
版本：LinGiSO-教程
地区：美国
语言：英语
简介：

转自：TLF
介质：CD-ROM
数量：1CD
主页：http://www.vtc.com/modules/products/titleDetails.php?sku=33682

SQL Server 2005 是 Microsoft的企业数据库解决方案产品的最新版本。SQL Server 2005 是最近5年来网罗管理员和开发者建议和希望来研究和开发的结果。 Microsoft 继续引领数据库市场。 Microsoft Certified Database Adminis trator and Certified Trainer Mark Long 介绍了SQL Server 2005 管理的基础知识。

QUOTE(包含内容)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)