中文名: Microsoft SQL Server 2005 Administration資源格式: 光盤鏡像版本: 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 管理的基礎知識。
引用(包含內容)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)
[通過安全測試]
殺毒軟件：
病毒庫：2006.05.04 08:02:11
[通過安裝測試]
[發布計算機系統]
共享時間：10:00 AM - 22:00 PM
一般在共享服務器：DONKEYSERVER NO1
軟件版權歸原作者及原軟件公司所有，如果你喜歡，請購買正版軟件