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

內(nèi)容概要

本書詳細地介紹了SQL Server 7．0的配置和管理工作。其中，包括基本概念和術語、數(shù)據(jù)庫安全的管理方法、數(shù)據(jù)庫的日常維護、數(shù)據(jù)備份和恢復、數(shù)據(jù)轉(zhuǎn)移操作、分布式數(shù)據(jù)管理及如何對數(shù)據(jù)庫的性能進行監(jiān)控和優(yōu)化等內(nèi)容。通過學習本書可以很好地掌握數(shù)據(jù)庫管理員應該具備的基本知識。 本書適用于計劃參加相關的微軟認證考試的人員使用。

作者簡介

作者：（美國）微軟公司

書籍目錄

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的配置和管理工作。其中，包括基本概念和術語、數(shù)據(jù)庫安全的管理方法、數(shù)據(jù)庫的日常維護、數(shù)據(jù)備份和恢復、數(shù)據(jù)轉(zhuǎn)移操作、分布式數(shù)據(jù)管理及如何對數(shù)據(jù)庫的性能進行監(jiān)控和優(yōu)化等內(nèi)容。通過學習本書可以很好地掌握數(shù)據(jù)庫管理員應該具備的基本知識。 本書適用于計劃參加相關的微軟認證考試的人員使用。

圖書封面

評論、評分、閱讀與下載

---

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

---