|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mssql-server-security/
课程评论：没有评论
**课程名称：** 学习安全数据库管理：MS SQL Server 安全 **课程概述：** 本课程专注于 Microsoft SQL Server 的安全管理，强调在企业中数据库管理的重要性和安全性。我们将深入讲解 MS SQL Server 的各项关键安全措施，并通过动手实践实验室进行演示和练习。 **课程内容涵盖：** * 准备安全的 Windows Server 环境以进行安装 * MS SQL Server 的配置 * 通过 sp_configure [reducing the attack surface] (减少攻击面) * 增强对诱骗攻击和欺骗攻击的防护 * 静态和动态端口配置 * 通道绑定和服务器绑定技术 * 隐藏 SQL Server 实例 * 策略管理和预防性策略示例 * 打补丁和合规性管理 * 以及更多相关领域的最佳实践。 **实践环节：** 课程包含两个重要的实验室作业：创建表命名策略和在 MS SQL Server 上创建 PowerShell 代理作业。这些作业将引导您解决实际问题，并通过共同协作来完成。 **学习目标：** 完成本课程后，您将能够自信地安装和管理安全的 MS SQL Server。您将掌握防止数据泄露的技能，即使在其他安全机制被绕过的情况下，也能保护您的数据。
Database management is so essential and critical for the enterprises but making it secure is more crucial than that. MS SQL Server is one of the most popular commercial RDBMSs recently. In this course, MS SQL database management concepts will be explained with security in mind All crucial security measures will be explained throughout the course and will be implemented during the hands-on practice labs. With a hands-on style, we'll cover topics such as Preparing a windows server for secure installation,MS SQL server configurationSurface area reduction with sp_configure,Extended protection against luring attacks and spoofing attacks,Static and dynamic port configurations,Channel and service binding techniques,Hiding SQL instancePolicy based management and preventative policy examplesPatching and complianceAnd many more best practices in this domain. We will also have 2 lab assignments about creating a table name policy and a powershell proxy job on MS SQL Server, which we will solve the problems together. By the end of the course, you'll know how to install and manage secure MS SQL server with confidence, which gives you the skills to prevent data leakages even if the cyber attacks can bypass other security mechanisms in place.
