微软培训与认证系列教材 832B

出版时间：2002-1  出版社：清华大学出版社  作者：微软公司  

内容概要

本书详细地介绍了SQL Server 7．0的配置和管理工作。其中，包括基本概念和术语、数据库安全的管理方法、数据库的日常维护、数据备份和恢复、数据转移操作、分布式数据管理及如何对数据库的性能进行监控和优化等内容。通过学习本书可以很好地掌握数据库管理员应该具备的基本知识。 本书适用于计划参加相关的微软认证考试的人员使用。

作者简介

作者：（美国）微软公司

书籍目录

About This CourseIntroductionIntroductionsCourseMaterialsPrerequisitesCourseOutlineMicrosoftCertifiedProfessionalProgramFacilitiesModule1:SQLServerOverviewWhatIsSQLServerSQLServerPlatformsSQLServerIntegrationwithWindowsNTSQLServerIntegrationwithMicrosoftBackOfficeSQLServerServicesSQLServerSoftwareSQLServerArchitectureCommunicationApplicationDevelopmentAdministrationSQLServerSecurityLoginAuthenticationDatabaseUserAccountsandRoles,PermissionValidationSQLServerDatabasesTypesofDatabasesDatabaseObjectsReferringtoSQLServerObjectsSystemTablesMetadataRetrievalWorkingwithSQLServerDesigninganApplicationforSQLServerImplementingaSQLServerDatabaseAdministeringaSQLServerDatabaseLab1.1:SQLServerOverviewReviewModule2:InstallingandConfiguringSQLServerMinimumHardwareandSoftwareRequirementsSQLServer7.0EditionsSQLServerInstallationOptions.LicensingModeInstallationPathCharacterSetSortOrderUnicodeCollationNetworkSupportSQLServerServicesLogonAccountRunningSQLServerSetupUnattendedInstallationVerifyingtheInstallationReviewingInstallationResultsStartingSQLServerServicesConnectingtoSQLServerPreparingtoUseSQLServerConfiguringSQLServerEnterpriseManagerConfiguringSQLServerTroubleshootingRecommendedPracticesLab2.1:InstallingandConfiguringSQLServerReviewModule3:ManagingSecurityImplementinganAuthenticationModeAuthenticationProcessingChoosinganAuthenticationModeStepsinImplementinganAuthenticationModeCreatingLoginAccountsDemonstration:SettingUpLoginAccountsLab3.1:ManagingSecurityAssigningLoginAccountstoUsersandRolesAssigningLoginAccountstoUserAccountsAssigningLoginAccountstoRolesFixedServerRolesFixedDatabaseRolesUser-definedDatabaseRolesAssigningPermissionstoUsersandRolesTypesofPermissionsGranting,Denying,andRevokingPermissionsGrantingPermissionstoAllowAccessDenyingPermissionstoPreventAccessRevokingGrantedandDeniedPermissionsPlanningSecurityDemonstration:AssigningLoginAccountstoUserAccountsandRolesLab3.2:ManagingPermissionsManagingApplicationSecurityManagingSecuritywithViewsandStoredProceduresManagingClientApplicationSecuritywithApplicationRolesCreatingApplicationRolesActivatingApplicationRolesRecommendedPracticesLab3.3:ManagingApplicationSecurityReviewModule4:ManagingDatabaseFilesIntroductiontoDatabasesHowDataIsStoredMultimediaPresentation:TransactionsHowtheTransactionLogWorks,CreatingDatabasesSettingDatabaseOptionsModifyingDatabasesManagingDataandLogFileGrowthExpandingaTransactionLogShrinkingaDatabaseorFileDroppingaDatabaseManagingDatabasesonMultipleDisksLeveragingtheWindowsNTServerFaultToleranceCreatingFilegroupsCapacityPlanningDeterminingtheSizeofmodelDatabaseandSystemTablesEstimatingtheAmountofDatainTablesPerformanceConsiderationsRecommendedPracticesLab4.1:ManagingDatabaseFilesReviewModule5:BackingUpDatabasesPreventingDataLossSQLServerBackupPerformingandStoringBackupsWhentoBackUpDatabasesBackingUpSystemDatabasesBackingUpUserDatabasesActivitiesThatAreRestrictedDuringBackupPerformingBackupsCreatingPermanentBackupFilesCreatingTemporaryBackupFilesUsingMultipleBackupFil

编辑推荐

　　本书详细地介绍了SQL Server 7．0的配置和管理工作。其中，包括基本概念和术语、数据库安全的管理方法、数据库的日常维护、数据备份和恢复、数据转移操作、分布式数据管理及如何对数据库的性能进行监控和优化等内容。通过学习本书可以很好地掌握数据库管理员应该具备的基本知识。 本书适用于计划参加相关的微软认证考试的人员使用。