微軟培訓(xùn)與認(rèn)證系列教材 832B

內(nèi)容概要

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

作者簡介

作者：（美國）微軟公司

書籍目錄

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

編輯推薦

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

圖書封面

評論、評分、閱讀與下載

---

    微軟培訓(xùn)與認(rèn)證系列教材 832B PDF格式下載

---