|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/database-administration-with-sql-server-2019/
课程评论：没有评论
Coursera 数据库管理 SQL Server 2019 课程总结 本课程旨在教授如何成为数据库管理员以及如何管理 SQL Server 2019。无论您是想成为初级数据库管理员，还是仅仅想了解 SQL Server 2019 的管理，本课程都能满足您的需求。即使您已有 SQL Server 经验，也可将本课程作为参考。 **课程内容涵盖：** * **SQL Server 2019 的安装与配置** * **SQL Server 2019 的安全管理** * **备份与恢复（符合业务连续性规划）** * **数据库管理员的职责与角色** **课程大纲：** * **第一课：** 导论 * **第二课：** 安装与配置 SQL Server 2019 环境 * **第三课：** 创建数据库 * **第四课：** 登录名、用户与角色 * **第五课：** SQL 基础 * **第六课：** 实例配置 * **第七课：** TempDB * **第八课：** 并行处理 * **第九课：** 事务日志 * **第十课：** 备份 * **第十一课：** 恢复 * **第十二课：** 自动化 * **第十三课：** 高可用性 * **第十四课：** 云计算 * **第十五课：** 数据损坏 **先决条件：** * 了解 IP 地址。 **硬件要求：** * 至少 8GB RAM 的电脑（推荐 12GB 或以上），用于设置 SQL Server 虚拟化环境。 * 如果硬件不满足要求，可直接在主机上安装 SQL Server。
This course teaches two things at the same time: 1. How to become a Database Administrator 2. How to manage SQL Server 2019Whether you are seeking to become a Junior Database Administrator or to just learn about managing SQL Server 2019, this course has you covered. Even if you have experience with SQL Server already, you can use this course as a reference. You will learn:1. How to install and configure SQL Server 20192. How to secure SQL Server 20193. How to do Backup and Recovery to keep in line with Business Continuity Planning4. The job and roles of the Database AdministratorThe course outline is as follows:Lesson 1 - IntroductionLesson 2 - Installing and configuring a SQL Server 2019 environmentLesson 3 - Creating a databaseLesson 4 - Logins, Users, and RolesLesson 5 - SQL Lesson 6 - Instance ConfigurationLesson 7 - TempDBLesson 8 - ParallelismLesson 9 - Transaction LogLesson 10 - BackupsLesson 11 - RecoveryLesson 12 - AutomationLesson 13 - High AvailabilityLesson 14 - CloudLesson 15 - CorruptionNote: No prior knowlege is needed except you need to know what is an IP Address. Everything else will be taught in the course. The hardware requirements are:A computer with at least 8GB of RAM. Preferrably, the RAM should be 12 GB or more. This is required to setup a SQL Server virtualized environment. If you don't meet the hardware requirements, you can always install SQL Server on your host machine instead of the virtual machine.
