VTC Microsoft SQL Server 2008 Development 英文正式版(MS SQL Server 2008管理員教學)



-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
軟體名稱:VTC Microsoft SQL Server 2008 Development 英文正式版(MS SQL Server 2008管理員教學)
語系版本:英文版
光碟片數:單片裝
破解說明:
系統支援:WIN 9x/WIN ME/WIN NT/WIN 2000/WIN XP/WIN 2003
軟體類型:MS SQL Server 2008管理員教學
硬體需求:PC
更新日期:2010/6/21
官方網站:http://www.vtc.com/products/Microsoft-SQL-Server-2008-Development-Tutorials.htm
中文網站:http://www.vtc.com/products/Microsoft-SQL-Server-2008-Development-Tutorials.htm
軟體簡介:
銷售價格:80
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=




軟體簡介:

      

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) 








             


-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=