微软培训与认证系列教材 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的配置和管理工作。其中,包括基本概念和术语、数据库安全的管理方法、数据库的日常维护、数据备份和恢复、数据转移操作、分布式数据管理及如何对数据库的性能进行监控和优化等内容。通过学习本书可以很好地掌握数据库管理员应该具备的基本知识。 本书适用于计划参加相关的微软认证考试的人员使用。