Keystone SQL 2000 Implementing and Design Level 3 and 4 (2片裝)





軟體簡介:

KeystoneSQL2000ImplementingandDesignLevel3and4(2片裝)(Keystone公司:微軟SQL2000資料庫設計實作教學Level3及4)


Keystone公司:微軟SQL2000資料庫設計實作教學Level3及4
市價:新台幣38000元。
　
Thiscourseteachesyoutoadministerandtroubleshootinformationsystems
thatincorporatetheSQLServer?2000EnterpriseEdition.Learnhowto
installandconfigureaSQL2000Server,createSQL2000databases,manage
,monitorandtroubleshootSQL2000databases,extractandtransformdata
andmanageandmonitorSQL2000security.Availableon11videosor11
CDs,theentirecoursepreparesyouforExams70-228and70-229.

ImplementingSQLServer2000Level3(2hrs17mins)
1.0AdvancedQueries(39mins)
1.1AggregatedFunctions
1.2GroupingData
1.3AdvancedQueries
1.4DistributedQueries
2.0JoiningTables(30mins)
2.1InnerJoins
2.2OuterJoins
2.3CrossJoin&SelfJoin
2.4Subqueries
2.5Unions
3.0DataModification(14mins)
3.1INSERTStatements
3.2CreatingTemporaryTables
3.3UPDATEStatements
3.4DELETEStatement
4.0SystemFunctions(54mins)
4.1DateFunctions
4.2MathematicalFunctions
4.3StringFunctions
4.4SystemFunctions
4.5SecurityFunctions
4.6ConversionFunctions
4.7User-DefinedFunctions
4.8SystemVariables

ImplementingSQLServer2000Level4(2hrs1min)
1.0StoredProcedures(48mins)
1.1IntrotoStoredProcedures
1.2PassingParameters
1.3ReturninginformationfromStoredProcedures
1.4OUTPUTParameters
1.5DynamicSQL
1.6Cursors
2.0Triggers&Views(37mins)
2.1UpdateTriggers
2.2InsertTriggers
2.3DeleteTriggers
2.4INSTEADOFTriggers
2.5Views
3.0LockingIssues(36mins)
3.1LockingScenarios
3.2IsolationLevels
3.3ResourceLockTypes
3.4LockModes
3.5LockEscalation
3.6ViewingLocks
3.7SettingtheIsolationLevel
3.8LockingHints
Keystne.SQL.2000.Implementing.and.Design.Level.3-4