Keystone SQL 2000 Implementing and Design Level 5 and 6 (2片裝)





軟體簡介:

KeystoneSQL2000ImplementingandDesignLevel5and6(2片裝)(微軟SQL2000資料庫設計實作教學Level5及6)


Keystone公司:微軟SQL2000資料庫設計實作教學Level5及6。
市價:新台幣38000元。

Thiscourseteachesyoutoadministerandtroubleshootinformationsystems
thatincorporatetheSQLServer?2000EnterpriseEdition.

LearnhowtoinstallandconfigureaSQL2000Server,createSQL2000
databases,manage,monitorandtroubleshootSQL2000databases,extract
andtransformdataandmanageandmonitorSQL2000security.Available
on11videosor11CDs,theentirecoursepreparesyouforExams70-228
and70-229.

ImplementingSQLServer2000Level5(2hrs2min)
1.0TransactionProcessing(20mins)
1.1WhatisaTransaction?
1.2NestingTransactions
1.3TransactionsinTriggers
1.4TryingoutTransactions
1.5Deadlocks
2.0DataTransfer(26mins)
2.1ServicesAvailable
2.2BCP
2.3BULKINSERT
2.4DTS
3.0FullTextSearch(28mins)
3.1WhatisFullTextSearch?
3.2SettingupFullTextSearch
3.3PerformingaFullTextSearch
3.4FullTextSystemProcedures
3.5FTSEnhancementsinSQL2000
4.0Optimization(33mins)
4.1OptimizingyourServer
4.2Databasedesign
4.3QueryOptimization
4.4IndexUsage
4.5Statistics&IndexAnalyzer
4.6SQLServerProfiler
4.7PerformanceMonitor
5.0SystemDatabases&Tables(15mins)
5.1SystemDatabases
5.2SystemTables

ImplementingSQLServer2000Level6(1hr50mins)
1.0UsingXMLExtensions(61mins)
1.1CreatingaVirtualRoot
1.2UsingaVirtualRoot
1.3ReturningElementBasedXML
1.4PassingParameters
1.5MultipleResultSets
1.6UsingStoredProcedures
1.7InsertingDatausingXML
1.8JoiningTables
1.9RetrievingDatafromVB
2.0ApplicationDevelopment(49mins)
2.1OLEDB,ODBCandADO
2.2UsingADO
Keystone.SQL.2000.Implementing.and.Design.Level.5-6