![]()
軟體簡介:
VTC Microsoft SQL Server 2008 Development 英文正式版(MS SQL Server 2008管理員教學)
官方網址：http://www.vtc.com/products/Microsoft-SQL-Server-2008-Development-Tutorials.htm
【內容說明】★◇以下中文譯文說明僅供參考，實際軟體內容請依參考網址介紹為準◇★
SQL Server 2008 是 Microsoft的企業資料庫解決方案產品的最新版本。SQL Server
2008 是最近5年來網羅管理員和開發者建議和希望來研究和開發的結果。 Microsoft
繼續引領資料庫市場。 Microsoft Certified Database Adminis trator and Certified
Trainer Mark Long 介紹了SQL Server 2008 管理的基礎知識。
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 2008
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 2008 (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)
