微軟培訓與認證系列教材 833B

內容概要

本書主要講述如何實現(xiàn)SQLServer7．0數(shù)據(jù)庫，內容包括Transact-SQL語言的介紹、數(shù)據(jù)庫和表的創(chuàng)建、數(shù)據(jù)完整性的概念、索引的設計與創(chuàng)建、一般和高級查詢、數(shù)據(jù)的匯總、事務的處理、使用分布式數(shù)據(jù)、視圖的實現(xiàn)、使用存儲過程和觸發(fā)器，同時還介紹了加鎖和高級文本查詢；本書闡述了大量的基本知識，并提供了循序漸進的練習，使讀者可以充分了解和掌握SQLServer7.0。本書適用于計劃參加相關的微軟認證考試的人員使用。

作者簡介

作者：（美國）微軟公司

書籍目錄

AboutThisCurseIntroductionIntroductionsCourseMaterialsPrerequisitesCourseOutlineCourseOutlineCourseOutlineAppendicesMicrosoftCertifiedProfessionalProgramFacilitiesModule1:SQLServerOverviewWhatIsSQLServerSQLServerArchitectureSQLServerSecuritySQLServerDatabasesWorkingwithSQLServerLabII:SQLServerOverviewReview.Module2:OverviewofTransact-SQLSQLServerProgrammingTools.TheTransact-SQLProgrammingLanguageElementsofTransact-SQLWaystoExecuteTransact-SQLStatementsHowQueresAreProcessedRecommendedPracticesLab2.l:OverviewofTransact-SQLReviewModule3:CreatingDatabasesHowDataIsStoredCreatingDatabasesModifyingDatabasesCreatingFilegroupsLab3.l:CreatingDatabasesTheLibraryDatabaseCreatingDataTypesCreatingTablesGeneratingScriptsRecommendedPracticesLab3.2:CreatingDatabaseObjectsReviewModule4:ImplementingDataIntegrityTypesofDataIntegrityEnforcingDataIntegrityUsingConstraintsUsingDefaultsandRulesDecidingWhichEnforcementMethodtoUseRecommendedPracticesLab4.l:ImplementingDataIntegrityReviewModule5:PlanningandCreatingIndexesIntroductiontoIndexesIndexArchitectureCreatingIndexesCREATEINDEXOptionsLab5.l:CreatingIndexesMaintainingIndexesPerformanceConsiderationsRecommendedPracticesLab5.2:MaintainingIndexesReviewModule6:QueryingMultipleTablesCombiningDatafromMultipleTablesCombiningMultipleResultSetsCreatingaTablefromaResultSetRecommendedPracticesLab6.l:QueryingMultipleTablesReviewModule7:AdvancedQueryTechniquesIntroductiontoSubqueriesNestedSubqueriesCorrelatedSubqueriesUsingtheEXISTSandNOTEXTSTSKeywordsModifyingDataRecommendedPracticesLab7.l:AdvancedQueryTechniquesReviewModule8:SummarizingDateUsingAggregateFunctions.GROUPBYFundamentalsGeneratingAggregateValuesWithinResultSetsUsingtheCOMPUTEandCOMPUTEBYClausesListingtheTOPnValuesRecommendedPracticesLab8.l:SummarizingDataReviewModule9:ManagingTransactionsandLocksIntroductiontoTransactionsandLocksManagingTransactionsManagingLocksDeadlocks.RecommendedPracticesLab9.1:ManagingTransactionsandLocksReviewModule10:WorkingwithDistributedDataIntroductiontoDistributedQueriesExecutinganAdHocQueryonaRemoteDataSourceSettingUpaLinkedServerEnvironmentExecutingaQueryonaLinkedServerExecutingaStoredProcedureonaLinkedServerModifyingDataonaLinkedServerDistributingData.RecommendedPracticesLab10.l:WorkingwithDistributedDataReview.Module11:ImplementingViewsWhatIsaViewAdvantagesofViewsDefiningViewsModifyingDataThroughViewsPerformanceConsiderationsRecommendedPracticesLab1l.1:ImplementingViewsReviewModule12:ImplementingStoredProceduresIntroductiontoStoredProceduresCreating,Executing,andModifyingStoredProceduresLab12.1I:CreatingStoredProceduresUsingParametersinStoredProceduresExecutingExtendedStoredProceduresHandlingErrorMessagesPerformanceConsiderationsRecommendedPracticesLab12.2:CreatingStoredProcedureswithParametersReviewModule13:ImplementingTriggersIntroductiontoTriggersDefiningTriggersExamplesofTriggersRecommendedPracticesLab13.l:CreatingTriggersReviewModule14:AdvancedTextQueriesMicrosoftSearchServiceLab14.l:Microso8SearchServiceMicrosoftEnglishQueryLab14.2:MicrosoftEnglishQueryReviewAppendixA:LibraryDatabaseCaseStudyIntroductionOverviewofLibraryOperationsDailyLibraryFunctions.LibraryDatabaseDesignAppendixB:DatabaseSchemasAppendixC:PerformingBasicQueriesRetrievingDataFormattingResultSetsLabC.1:RetrievingDataandManipulatingResultSetsModifyingDataPerformanceConsiderationsRecommendedPracticesLabC.2:ModifyingDataReviewLabC.1:RetrievingDataandManipulatingResultSetsObjectiveBeforeYouBeginExerciselRetrievingDataExercise2ManipulatingResultSetsLabC.2:ModifyingDataObjectiveBeforeYouBeginExerciselUsingtheINSERTStatementxercise2UsingtheINSEB.TStatementwiththeDEFAULTKeywordExercise3UsingtheINSERTStatementwiththeDEFAULTVALUESKeywordExercise4UsingtheDELETBStatementExercise5UsingtheUPDATEStatementAppendixD:UsingCursorsWhatisaCursorMethodsofCallingCursorsTransact-SQLCursorsDemonstration:UsingTransact-SQLCursorsRecommendedPracticesReviewTrainerLabManualLab1.1:SOLServerOverviewObjectivesExerciselUsingSQLServerBooksOnlineExercise2CreatingaDatabaseDiagramLab2.1:OverviewofTransact-SQLObjectivesBeforeYonBeginExerciselWritingBasicSELECTStatementsExercise2ModifyingaScriptFile.Exercise3UsingSystemFunctions.Lab3.1:CreatingDatabasesObjective.BeforeYouBeginExerciselCreatingthelibraryDatabaseExercise2ManagingtheGrowthofthelibraryLogFileExercise3SettinganOptiontoCleartheTransactionLogLab3.2:CreatingDatabaseObjectsObjectivesBeforeYouBeginExerciselCreatingUser-DefinedDataTypesExercise2CreatingTablesinthelibraryDatabaseExercise3AddingandDroppingColumnsExercise4GeneratingSQLScriptsExercise5LoadingthelibraryDatabasewithSampleDataLab4.1:ImplementingDataIntegrityObjectivesBeforeYouBeginExerciseIDefiningDEFAULTConstraintsExercise2DefiningCHECKConstraintsExercise3DefiningPRIMARYKEYConstraintsExercise4De8ningFOREIGNKEYConstraintsIfTimePermitsCreatingDefaultsandRulesLab5.1:CreatingIndesesObjectiveBeforeYouBeginExerciselCreatingIndexesLab5.2:MaintainingIndexes'ObjectivesBeforeYouBeginExerciseIUsingtheFILLFACTORandDBCCSHOWCONTIGOptionsExercise2GatheringQueryPerformanceInformationLab6.1:QueryingMultipleTablesObjectivesBeforeYouBeginExercise.IJoiningTables.Exercise2UsingtheUNIONOperatortoCombineResultSetsExercise3CreatingTemporaryTablesLab7.1:AdvancedQueryTechniquesObjectivesBeforeYouBeginExerciselUsingSubqueriesExercise2ModifyingTablesBasedonDatainOtherTablesLab8.1:SummarizingDataObjectivesBeforeYouBeginExerciselUsingtheGROUPBYandIIAVDI6ClausesExercise2UsingtheROLLUPandCUBEOperatorsExercise3UsingtheCOMPUTEandCOMPUTEBYClausesIfTimePermitsUsingtheTOPnKeywordLab9.1:ManagingTranseactionsandLocksObjectivesBeforeYouBeginExerciselCreatingandExecutingaTransactionExercise2RollingBackaTransactionExercise3ViewingLockingInformationExercise4SettingLockingOptions.Lab10.1:WorkingwithDistributedDataObjectivesBeforeYouBeginExerciselSettingUpLinkedServersExercise2QueryingRemoteDataIfTimePermitsManagingDistributedTransactionsLab11.1:ImplementingViewsObjectivesBeforeYouBeginExerciselCreatingandTestingViewsExercise2CreatingaViewofaViewExercise3EncryptingaViewDe8nitionExercise4ModifyingDataThroughViewsExercise5LocatingViewDefinitionsExercise6TestingEffectsofOwnershipChainsIfTimePermitsCreatingaViewwithSQLServerEnterpriseManagerLab12.1:CreatingStoredProceduresObjectivesBeforeYouBeginExerciselWritingandExecutingaStoredProcedureExercise2LocatingStoredProcedureInformationLab12.2:CreatingStoredProcedureswithParametersObjectivesBeforeYouBeginExerciselUsingtheCreateStoredProcedureWizardExercise2CreatingStoredProceduresfromScriptsExercise3AlteringStoredProceduresExercise4CustomizingErrorMessagesExercise5UsingReturnCodesIfTimePermitsExecutingExtendedStoredProceduresIfTimePermitsMonitoringtheProcedureCacheLab13.1:CreatingTriggersObjectivesBeforeYouBeginExerciselCreatingTriggersExercise2CreatingaTriggerforUpdatingDerivedDataExerise3CreatingaTriggerThatMaintainsaComplexBusinessRuleExercise4CreatingaTriggerforthereservationTableExercise5TestingNestedTriggers.Lab14.1:MicrosoftSearchServiceObjectivesBeforeYouBeginExerciselSettingUpMicrosoftSearchServiceExercise2WritingFull-TextQueriesIfTimePermitsSettingUpMicrosoftSearchServicebyUsingSystemStoredProceduresLab14.2:MicrosoftEnglishQueryObjectivesBeforeYouBeginForMoreInformationExerciseIInstallingEnglishQuery.Exercise2UsingEnglishQuery.Exercise3reatinganEnglishQueryApplicationIfTimePermitsReviewtheEnglishQueryTutorialClassroomSetupGuideClassroomRequirementsClassroomConfigurationSetupInstructions

編輯推薦

　　本書主要講述如何實現(xiàn)SQLServer7．0數(shù)據(jù)庫，內容包括Transact-SQL語言的介紹、數(shù)據(jù)庫和表的創(chuàng)建、數(shù)據(jù)完整性的概念、索引的設計與創(chuàng)建、一般和高級查詢、數(shù)據(jù)的匯總、事務的處理、使用分布式數(shù)據(jù)、視圖的實現(xiàn)、使用存儲過程和觸發(fā)器，同時還介紹了加鎖和高級文本查詢；本書闡述了大量的基本知識，并提供了循序漸進的練習，使讀者可以充分了解和掌握SQLServer7.0。本書適用于計劃參加相關的微軟認證考試的人員使用。

圖書封面

評論、評分、閱讀與下載

---

    微軟培訓與認證系列教材 833B PDF格式下載

---