- 数据库基础知识
- 了解 SQL 语法和查询
观众
- Database 管理员 (DBA)
- 开发 人员
- IT 专业人员
SQL 服务器 Management Studio (SSMS) 是一个集成环境,用于管理从 SQL 服务器到 Azure SQL Database 的任何 SQL 基础结构。SSMS 提供用于配置、监视和管理 SQL 服务器和数据库实例的工具。
这种以讲师为主导的现场培训(现场或远程)针对中级数据库管理员,他们希望学习必要的技能和知识,以使用SQL服务器Management Studio有效地管理和管理SQL服务器数据库。
在培训结束时,参与者将能够:
- 了解系统要求并执行安装。
- 使用 SSMS 创建、配置和管理数据库。
- 管理登录名、用户、角色和权限。
- 执行各种类型的备份和还原数据库。
- 使用 SQL Server Agent 创建、计划和管理作业。
- 实施高效、安全的最佳实践 SQL 服务器管理。
课程形式
- 互动讲座和讨论。
- 大量的练习和练习。
- 在现场实验室环境中实际实施。
课程定制选项
- 如需申请此课程的定制培训,请联系我们进行安排。
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 服务器升级
- 就地升级与并行升级
- 将数据库迁移到新实例
- 迁移后任务
摘要和后续步骤
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