|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-dba-for-beginners/
课程评论：没有评论
**Coursera 课程总结：SQL DBA 入门** 本课程专为初学者设计，旨在教授数据库管理员 (DBA) 的基础知识和核心职能。随着数据库的广泛应用，DBA 的需求日益增长。课程将重点关注 DBA 的关键职责，包括数据库的备份与恢复，以确保数据安全。 **课程亮点：** * **无需安装软件：** 课程提供由微软提供的现成虚拟实验室环境，无需任何软件安装。 * **跨平台兼容：** 无论您使用的是 Mac、PC 还是 Linux，只需一个网页浏览器即可访问虚拟实验室，体验与真实生产环境一致的 SQL Server 操作。 * **实践导向：** 通过虚拟实验室进行一系列真实的 DBA 操作演练，帮助您掌握实际工作技能。 **课程内容涵盖：** * 虚拟实验室的使用 * T-SQL 快速指南 * 数据导入与导出 * 活动监视器 (Activity Monitor) 的使用 * 性能监视器 (Performance Monitor) 的使用 * 数据库备份 * 数据库恢复 * 数据库监控 * 性能优化 * 用户与用户组的身份验证 * 权限的设置 * 审计 (Auditing) 的设置 **学习目标：** 完成本课程后，您将能够理解 DBA 的基本角色，并熟练掌握 SQL Server 数据库管理的关键技能，包括数据保护、性能监控和安全管理。 **课程优势：** 课程利用微软免费提供的虚拟实验室，模拟真实生产环境，让您在安全、便捷的环境中学习和实践，是您开启 DBA 之旅的绝佳选择。
Databases are everywhere and the demand for database administrator has increased. The role of a database administrator includes backing up database for safety and having the skills to restore the database if required. This SQL DBA beginners course will teach you the basic functions that DBA's has to perform.In this course you will not have to install any software as we will be using a ready made virtual lab environment provided my Microsoft. The virtual labs is ideal because it is free and gives you an environment that mirrors a real world production SQL Server environment. I strongly urge you to take advantage of this opportunity as I do not know how long Microsoft will have these virtual labs available for. All you require to access the virtual labs is a web browser. It does not matter if you are using a mac , Pc or Linux and there is absolutely nothing for you to install. The lab exercise you will perform in this course using the virtual labs are similar to a real world SQL Server production environment. What you will learn in this course includes: How to use Virtual LabsT-SQL quick GuideImporting and Exporting DataHow to use Activity monitorHow to use Performance monitorHow to backup databaseHow to restore databaseHow to monitor databaseHow to improve performanceHow to authenticate users and groupsHow to set up PermissionsHow to setup Auditing I look forward to seeing you on the course. Thank You
