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


KeystoneSQL2000ImplementingandDesignLevel3and4(2片裝)-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=軟體名稱:KeystoneSQL2000ImplementingandDesignLevel3and4(2片裝)語系版本:光碟片數:2片裝破解說明:系統支援:WIN9x/WINME/WINNT/WIN2000/WINXP/WIN2003軟體類型:電腦教學認證硬體需求:PC更新日期:2004/2/11官方網站:http://www.keystonelearning.com/cgi-bin/ncommerce3/ExecMacro/Category/keystonecat.d2w/report?cgmenbr=7020&cgrfnbr=5819中文網站:http://www.keystonelearning.com/cgi-bin/ncommerce3/ExecMacro/Category/keystonecat.d2w/report?cgmenbr=7020&cgrfnbr=5819軟體簡介:銷售價格:160-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=軟體簡介:KeystoneSQL2000ImplementingandDesignLevel3and4(2片裝)(Keystone公司:微軟SQL2000資料庫設計實作教學Level3及4)Keystone公司:微軟SQL2000資料庫設計實作教學Level3及4市價:新台幣38000元。　ThiscourseteachesyoutoadministerandtroubleshootinformationsystemsthatincorporatetheSQLServer?2000EnterpriseEdition.LearnhowtoinstallandconfigureaSQL2000Server,createSQL2000databases,manage,monitorandtroubleshootSQL2000databases,extractandtransformdataandmanageandmonitorSQL2000security.Availableon11videosor11CDs,theentirecoursepreparesyouforExams70-228and70-229.ImplementingSQLServer2000Level3(2hrs17mins)1.0AdvancedQueries(39mins)1.1AggregatedFunctions1.2GroupingData1.3AdvancedQueries1.4DistributedQueries2.0JoiningTables(30mins)2.1InnerJoins2.2OuterJoins2.3CrossJoin&SelfJoin2.4Subqueries2.5Unions3.0DataModification(14mins)3.1INSERTStatements3.2CreatingTemporaryTables3.3UPDATEStatements3.4DELETEStatement4.0SystemFunctions(54mins)4.1DateFunctions4.2MathematicalFunctions4.3StringFunctions4.4SystemFunctions4.5SecurityFunctions4.6ConversionFunctions4.7User-DefinedFunctions4.8SystemVariablesImplementingSQLServer2000Level4(2hrs1min)1.0StoredProcedures(48mins)1.1IntrotoStoredProcedures1.2PassingParameters1.3ReturninginformationfromStoredProcedures1.4OUTPUTParameters1.5DynamicSQL1.6Cursors2.0Triggers&Views(37mins)2.1UpdateTriggers2.2InsertTriggers2.3DeleteTriggers2.4INSTEADOFTriggers2.5Views3.0LockingIssues(36mins)3.1LockingScenarios3.2IsolationLevels3.3ResourceLockTypes3.4LockModes3.5LockEscalation3.6ViewingLocks3.7SettingtheIsolationLevel3.8LockingHintsKeystne.SQL.2000.Implementing.and.Design.Level.3-4-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=