|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-70-462-administering-sql-server-2012-databases/
课程评论：没有评论
**Coursera 课程总结：Microsoft 70-462 数据库管理员（SQL Server 2012）** 本 Coursera 课程专为负责安装、维护和配置 SQL Server 2012 数据库的数据库专业人士设计。课程涵盖了从安装规划、SQL Server 及其相关服务的安装，到配置、管理和优化数据库的各个方面。 **主要学习内容包括：** * **安装与部署：** 学习 SQL Server 的安装规划、安装 SQL Server 及相关服务、配置其他 SQL Server 组件、部署 SQL Server 以及实施迁移策略。 * **实例与组件管理：** 掌握 SQL Server 实例的管理、配置其他 SQL Server 组件、实例和服务的配置、实施 SQL Server 集群实例、以及 SQL Server 实例管理。 * **高可用性与灾难恢复：** 学习实施高可用性、灾难恢复解决方案、AlwaysOn、数据库镜像和复制。 * **备份与恢复：** 学习配置和维护备份策略、数据库恢复以及执行数据库备份。 * **数据库管理与维护：** 包括数据库管理和配置、实施和维护索引、导入和导出数据，以及识别和解决并发问题。 * **安全管理：** 掌握 SQL Server 实例的审计、管理登录名和服务器角色、管理数据库权限、管理用户和数据库角色以及解决安全问题。 * **故障排除：** 学习收集和分析故障排除数据，以及解决 SQL Server 相关的故障。 本课程旨在全面提升学员在 SQL Server 2012 数据库管理方面的知识和技能，为通过 Microsoft 70-462 考试做好充分准备。
This training course was created specifically for those individuals (Database Professionals) who install, maintain and configure as their primary job function. Any participants setting up database systems and/or responsible for efficient system operation, regular database back ups stored effectively, and securing data from unauthorised access is also a candidate for this training course on SQL 2012. Below is a partial list of job functions associated to this training course: Audit SQL Server instancesBack up databasesConfigure additional SQL Server components, Instances and ServicesDeploying a SQL ServerImplementing strategies, columnstores and High-Availability and Disaster Recovery solutionsImporting/exportingInstall SQL Server and related services.MaintenanceManagement, configuration, permissions, alerts, logins and roles.OptimizationInstallation PlanningRestoringTroubleshooting The SQL 2012 Administering Databases course prepares you for the Microsoft Exam 70-462 - As the participant in the SQL 2012 Adminstering course will learn: Installation PlanningInstalling SQL Server and related servicesImplementation of a migration strategyHow to configure additional SQL Server componentsManaging the SQL Server AgentDatabase management and configurationHow to configure SQL Server instancesImplementing a SQL Server clustered instanceSQL Server instances managementHow to properly Identify and resolve concurrency problemsThe collection of and how to analyze troubleshooting dataAuditing SQL Server instancesConfigure and maintain a back up strategyDatabase restorationImplementing and maintaining indexesImporting and exporting dataManaging logins and server rolesManaging database permissionsManaging users and database rolesTroubleshooting securityImplementing AlwaysOn, database mirroring and replication We create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed.
