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






軟體簡介:



VTCMicrosoftSQLServer2008Development英文正式版(MSSQLServer2008管理員教學)






官方網址：http://www.vtc.com/products/Microsoft-SQL-Server-2008-Development-Tutorials.htm

【內容說明】★◇以下中文譯文說明僅供參考，實際軟體內容請依參考網址介紹為準◇★

SQLServer2008是Microsoft的企業資料庫解決方案產品的最新版本。SQLServer
2008是最近5年來網羅管理員和開發者建議和希望來研究和開發的結果。Microsoft
繼續引領資料庫市場。MicrosoftCertifiedDatabaseAdministratorandCertified
TrainerMarkLong介紹了SQLServer2008管理的基礎知識。

QUOTE(包含內容)Welcome/Introduction
Introduction(02:08)
SQLServerOverview(03:24)
SQLServerHistory(04:46)
CourseObjeectives(01:56)
TransactSQL(03:58)
CourseOverview(03:52)
SQLServerMystique(02:51)
InstallingSQLServer2008
SQLServer2005Editions(04:27)
PreparingToInstallSQLServer2005(03:25)
HardwareRequirements(04:27)
WorkingWithPreviousVersions(04:10)
SQLServer2005Installation(02:19)
InstallingSQLServer2005Pt.1(05:09)
InstallingSQLServer2005Pt.2(03:40)
Changing&DeletingSQLServer(02:52)
Default&NamedInstances(05:13)
GettingAssistance(05:20)
AdministrativeTools
ManagementStudioOverview(04:41)
RegisteringServers(03:46)
ObjectExplorer(03:21)
ExecutingTSQLQueries(03:00)
ManagementStudioSolutions(04:12)
ServerConfigurationManager(02:59)
SQLCMD(02:35)
SQLCMDVariables(04:03)
DedicatedAdministratorConnection(03:25)
SQLServerSecurity
SecuringSQLServer2008(03:05)
AuthenticationModesPt.1(04:30)
AuthenticationModesPt.2(04:43)
Principles(03:10)
Permissions(03:31)
Securables(02:45)
ManagingLogins(05:05)
ManagingUsers(03:24)
Schemas(03:33)
ManagingSchemas(04:07)
ManagingPermissions(04:15)
ManagingServerPermissions(02:37)
ManagingDatabasePermissions(02:23)
TSQLPermissions(01:28)
SystemDatabases
SystemDatabases(06:00)
SystemDatabaseConcerns(02:29)
SampleDatabase(04:05)
Databases
CreatingADatabasePt.1(04:41)
CreatingADatabasePt.2(03:05)
DatabaseProperties&Options(05:27)
GeneratingScripts(05:06)
ShrinkingDatabaseFiles(04:31)
CreatingTablesPt.1(05:48)
CreatingTablesPt.2(03:03)
DatatypesPt.1(05:20)
DatatypesPt.2(05:51)
Primary&ForeignKeys(04:10)
Diagrams(05:44)
TransactionLogs
HowTransactionLogsWork(03:45)
TransactionsExplained(05:14)
Explicit&ImplicitTransactions(05:28)
Location,Location,Location(03:27)
AdvantagesOfUsingTransactionsLogs(03:40)
TransactionLogOptions(04:45)
DataStorage
HowSQLServerStoresData(05:03)
Fillfactor(05:12)
DBCCShowcontig(06:05)
SQLProfiler
Profiler(04:06)
UsingSQLProfilerPart1(04:24)
UsingSQLProfilerPart2(05:08)
AutomatingSQLServer
AutomationOverview(04:34)
SQLServerAgentService(02:57)
CreatingOperators(03:22)
CreatingJobsPt.1(05:33)
CreatingJobsPt.2(05:45)
CreatingAlerts(06:05)
AlertConsiderations(03:57)
DatabaseBackups
BackupStrategy(03:35)
DatabaseRecoveryModels(05:48)
WhichFilesandWhen(02:41)
PerformingABackup(03:47)
SQLBackupStatement(03:36)
TransactionLogBackups(02:45)
BackupTypes(05:39)
RestoringData
SQLServerRecoveryProcess(04:46)
RestoringADatabase(03:13)
TheRestoreStatement(03:29)
HighAvailability
SQLServerHighAvailability(02:53)
Clustering(02:21)
StandbyServers(05:13)
LogShipping(05:58)
DatabaseMirroring(03:08)
DatabaseMaintenance
MemoryManagementBasics(04:37)
MaintenancePlanCreation(06:14)
CourseWrap-Up
CourseWrap-Up(02:41)
Credits
AboutTheAuthor(01:48)