Course Code: sqlservermgmtstudio
Duration: 21 hours
Prerequisites:
  • 数据库基础知识
  • 了解 SQL 语法和查询

观众

  • Database 管理员 (DBA)
  • 开发 人员
  • IT 专业人员
Overview:

SQL 服务器 Management Studio (SSMS) 是一个集成环境,用于管理从 SQL 服务器到 Azure SQL Database 的任何 SQL 基础结构。SSMS 提供用于配置、监视和管理 SQL 服务器和数据库实例的工具。

这种以讲师为主导的现场培训(现场或远程)针对中级数据库管理员,他们希望学习必要的技能和知识,以使用SQL服务器Management Studio有效地管理和管理SQL服务器数据库。

在培训结束时,参与者将能够:

  • 了解系统要求并执行安装。
  • 使用 SSMS 创建、配置和管理数据库。
  • 管理登录名、用户、角色和权限。
  • 执行各种类型的备份和还原数据库。
  • 使用 SQL Server Agent 创建、计划和管理作业。
  • 实施高效、安全的最佳实践 SQL 服务器管理。

课程形式

  • 互动讲座和讨论。
  • 大量的练习和练习。
  • 在现场实验室环境中实际实施。

课程定制选项

  • 如需申请此课程的定制培训,请联系我们进行安排。
Course Outline:

SQL 服务器 Management Studio (SSMS) 简介

  • SQL 服务器版本和组件概述
  • SSMS 的接口和功能
  • 使用 SSMS 进行数据库管理的好处

安装和配置

  • SQL 服务器和 SSMS 的系统要求
  • 安装 SQL 服务器和 SSMS
  • 安装后配置
  • 连接到 SQL 个服务器实例

Database 架构和存储

  • 了解 SQL 服务器数据库和实例
  • SQL 服务器数据库架构
  • 文件组和数据文件

创建和管理 Databases

  • 使用 SSMS 创建数据库
  • 管理数据库属性
  • 附加和分离数据库

安全 Management

  • SQL服务器安全简介
  • 管理登录名和用户
  • 分配角色和权限
  • 实施安全最佳实践

备份和恢复

  • 备份和还原的重要性
  • 备份类型:完整备份、差异备份、事务日志备份
  • 使用 SSMS 执行备份
  • 从备份还原数据库

Database 维护计划

  • 定期数据库维护的重要性
  • 创建和安排维护计划
  • 对维护计划进行监控和故障排除

监视和性能调优

  • 监控 SQL 服务器性能
  • 确定性能瓶颈
  • 索引 Management 和优化
  • 使用 SQL 服务器分析器和扩展事件

使用 SQL Server Agent 自动执行任务

  • SQL Server Agent 简介
  • 创建和管理作业
  • 计划作业和警报
  • 监视 SQL 服务器代理作业

高可用性和灾难恢复

  • 高可用性选项概述
  • 实现数据库镜像
  • 配置日志传送
  • AlwaysOn 可用性组简介

升级和迁移 SQL 服务器

  • 规划 SQL 服务器升级
  • 就地升级与并行升级
  • 将数据库迁移到新实例
  • 迁移后任务

摘要和后续步骤

Sites Published:

United Arab Emirates - SQL Server Management Studio (SSMS) Administration

Qatar - SQL Server Management Studio (SSMS) Administration

Egypt - SQL Server Management Studio (SSMS) Administration

Saudi Arabia - SQL Server Management Studio (SSMS) Administration

South Africa - SQL Server Management Studio (SSMS) Administration

Brasil - SQL Server Management Studio (SSMS) Administration

Canada - SQL Server Management Studio (SSMS) Administration

中国 - SQL Server Management Studio (SSMS) Administration

香港 - SQL Server Management Studio (SSMS) Administration

澳門 - SQL Server Management Studio (SSMS) Administration

台灣 - SQL Server Management Studio (SSMS) Administration

USA - SQL Server Management Studio (SSMS) Administration

Österreich - SQL Server Management Studio (SSMS) Administration

Schweiz - SQL Server Management Studio (SSMS) Administration

Deutschland - SQL Server Management Studio (SSMS) Administration

Czech Republic - SQL Server Management Studio (SSMS) Administration

Denmark - SQL Server Management Studio (SSMS) Administration

Estonia - SQL Server Management Studio (SSMS) Administration

Finland - SQL Server Management Studio (SSMS) Administration

Greece - SQL Server Management Studio (SSMS) Administration

Magyarország - SQL Server Management Studio (SSMS) Administration

Ireland - SQL Server Management Studio (SSMS) Administration

Luxembourg - SQL Server Management Studio (SSMS) Administration

Latvia - SQL Server Management Studio (SSMS) Administration

España - SQL Server Management Studio (SSMS) Administration

Italia - SQL Server Management Studio (SSMS) Administration

Lithuania - SQL Server Management Studio (SSMS) Administration

Nederland - SQL Server Management Studio (SSMS) Administration

Norway - SQL Server Management Studio (SSMS) Administration

Portugal - SQL Server Management Studio (SSMS) Administration

România - SQL Server Management Studio (SSMS) Administration

Sverige - SQL Server Management Studio (SSMS) Administration

Türkiye - SQL Server Management Studio (SSMS) Administration

Malta - SQL Server Management Studio (SSMS) Administration

Belgique - SQL Server Management Studio (SSMS) Administration

France - SQL Server Management Studio (SSMS) Administration

日本 - SQL Server Management Studio (SSMS) Administration

Australia - SQL Server Management Studio (SSMS) Administration

Malaysia - SQL Server Management Studio (SSMS) Administration

New Zealand - SQL Server Management Studio (SSMS) Administration

Philippines - SQL Server Management Studio (SSMS) Administration

Singapore - SQL Server Management Studio (SSMS) Administration

Thailand - SQL Server Management Studio (SSMS) Administration

Vietnam - SQL Server Management Studio (SSMS) Administration

India - SQL Server Management Studio (SSMS) Administration

Argentina - SQL Server Management Studio (SSMS) Administration

Chile - SQL Server Management Studio (SSMS) Administration

Costa Rica - SQL Server Management Studio (SSMS) Administration

Ecuador - SQL Server Management Studio (SSMS) Administration

Guatemala - SQL Server Management Studio (SSMS) Administration

Colombia - SQL Server Management Studio (SSMS) Administration

México - SQL Server Management Studio (SSMS) Administration

Panama - SQL Server Management Studio (SSMS) Administration

Peru - SQL Server Management Studio (SSMS) Administration

Uruguay - SQL Server Management Studio (SSMS) Administration

Venezuela - SQL Server Management Studio (SSMS) Administration

Polska - SQL Server Management Studio (SSMS) Administration

United Kingdom - SQL Server Management Studio (SSMS) Administration

South Korea - SQL Server Management Studio (SSMS) Administration

Pakistan - SQL Server Management Studio (SSMS) Administration

Sri Lanka - SQL Server Management Studio (SSMS) Administration

Bulgaria - SQL Server Management Studio (SSMS) Administration

Bolivia - SQL Server Management Studio (SSMS) Administration

Indonesia - SQL Server Management Studio (SSMS) Administration

Kazakhstan - SQL Server Management Studio (SSMS) Administration

Moldova - SQL Server Management Studio (SSMS) Administration

Morocco - SQL Server Management Studio (SSMS) Administration

Tunisia - SQL Server Management Studio (SSMS) Administration

Kuwait - SQL Server Management Studio (SSMS) Administration

Oman - SQL Server Management Studio (SSMS) Administration

Slovakia - SQL Server Management Studio (SSMS) Administration

Kenya - SQL Server Management Studio (SSMS) Administration

Nigeria - SQL Server Management Studio (SSMS) Administration

Botswana - SQL Server Management Studio (SSMS) Administration

Slovenia - SQL Server Management Studio (SSMS) Administration

Croatia - SQL Server Management Studio (SSMS) Administration

Serbia - SQL Server Management Studio (SSMS) Administration

Bhutan - SQL Server Management Studio (SSMS) Administration

Nepal - SQL Server Management Studio (SSMS) Administration

Uzbekistan - SQL Server Management Studio (SSMS) Administration