微软培训与认证系列教材 833B
2002-1
清华大学出版社
微软公司
本书主要讲述如何实现SQLServer7．0数据库，内容包括Transact-SQL语言的介绍、数据库和表的创建、数据完整性的概念、索引的设计与创建、一般和高级查询、数据的汇总、事务的处理、使用分布式数据、视图的实现、使用存储过程和触发器，同时还介绍了加锁和高级文本查询；本书阐述了大量的基本知识，并提供了循序渐进的练习，使读者可以充分了解和掌握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
本书主要讲述如何实现SQLServer7．0数据库，内容包括Transact-SQL语言的介绍、数据库和表的创建、数据完整性的概念、索引的设计与创建、一般和高级查询、数据的汇总、事务的处理、使用分布式数据、视图的实现、使用存储过程和触发器，同时还介绍了加锁和高级文本查询；本书阐述了大量的基本知识，并提供了循序渐进的练习，使读者可以充分了解和掌握SQLServer7.0。本书适用于计划参加相关的微软认证考试的人员使用。
非常喜欢这本书 可惜一直没有货 真遗憾