v

您的位置:VeryCD教育计算机


《Microsoft SQL Server 2005 Administration》LinGiSO-教程[Bin]

  • 状态: 精华资源
  • 摘要:
    对白语言英语
  • 时间: 2006/05/04 10:22:22 发布 | 2006/05/04 10:22:22 更新
  • 分类: 教育  计算机 

Gellan

精华资源: 133

全部资源: 152

相关: 分享到新浪微博   转播到腾讯微博   分享到开心网   分享到人人   分享到QQ空间   订阅本资源RSS更新   美味书签  subtitle
该内容尚未提供权利证明,无法提供下载。
中文名Microsoft SQL Server 2005 Administration
资源格式光盘镜像
版本LinGiSO-教程
地区美国
对白语言英语
简介

IPB Image

转自: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 管理的基础知识。

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

[通过安全测试]
杀毒软件:IPB Image
病毒库:2006.05.04 08:02:11
[通过安装测试]IPB Image
[发布计算机系统]IPB Image


共享时间:10:00 AM - 22:00 PM
一般在共享服务器:DONKEYSERVER NO1
软件版权归原作者及原软件公司所有,如果你喜欢,请购买正版软件

正在读取……

这里是其它用户补充的资源(我也要补充):

暂无补充资源
正在加载,请稍等...

点击查看所有13网友评论

 

(?) [公告]留口水、评论相关规则 | [活动]每日签到 轻松领取电驴经验

    小贴士:
  1. 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
  2. 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
  3. 勿催片。请相信驴友们对分享是富有激情的,如果确有更新版本,您一定能搜索到。
  4. 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。
  5. 如果您发现自己的评论不见了,请参考以上4条。