- 无需具备SQL或数据库相关经验。
Microsoft SQL Server 是一个关系型数据库管理系统 (RDBMS)，用于存储和检索数据。
在这项由讲师指导的培训中（线下或远程），参与者将学习查询 Microsoft SQL Server 数据库所需的 SQL 语言基础知识。
培训结束后，参与者将能够：
- 安装和配置 Microsoft SQL Server
- 使用 Microsoft 的 Transact-SQL (T-SQL) 语言查询 Microsoft SQL Server 数据库
- 理解数据库设计的基础知识
- 通过规范化优化数据库
- 使用聚合函数生成类似于“数据透视表”的结果
- 通过 Excel Access Microsoft SQL Server
受众
- 数据分析师
- Business Intelligence 专业人士
- Business 经理
- 希望扩展分析技能集的 Excel 专家
课程形式
- 互动式讲座和讨论
- 大量练习和实践
- 在实时实验室环境中进行实际操作
课程定制选项
- 本培训基于最新版本的 Microsoft SQL Server
- 如需为本课程定制培训，请联系我们安排。
简介
安装与配置 Microsoft SQL Server
Microsoft SQL Server 功能概述
Transact-SQL 概念概述
使用 SELECT 查询 Database
使用 WHERE 过滤数据
使用 ORDER BY 排序数据
使用 Joins 查询多个表
使用 GROUP BY 分组数据
使用聚合函数对结果数据进行计算
使用 HAVING 过滤分组
创建新的 Database
理解 Database 模型
通过规范化优化 Database
使用过程增强查询
编写函数与子程序
使用条件控制流程
通过 Excel 连接 Microsoft SQL Server
故障排除
总结与结论
United Arab Emirates - Learning SQL with Microsoft SQL Server
Qatar - Learning SQL with Microsoft SQL Server
Egypt - Learning SQL with Microsoft SQL Server
Saudi Arabia - Learning SQL with Microsoft SQL Server
South Africa - Learning SQL with Microsoft SQL Server
Brasil - Learning SQL with Microsoft SQL Server
Canada - Learning SQL with Microsoft SQL Server
中国 - Learning SQL with Microsoft SQL Server
香港 - Learning SQL with Microsoft SQL Server
澳門 - Learning SQL with Microsoft SQL Server
台灣 - Learning SQL with Microsoft SQL Server
USA - Learning SQL with Microsoft SQL Server
Österreich - Learning SQL with Microsoft SQL Server
Schweiz - Learning SQL with Microsoft SQL Server
Deutschland - Learning SQL with Microsoft SQL Server
Czech Republic - Learning SQL with Microsoft SQL Server
Denmark - Learning SQL with Microsoft SQL Server
Estonia - Learning SQL with Microsoft SQL Server
Finland - Learning SQL with Microsoft SQL Server
Greece - Learning SQL with Microsoft SQL Server
Magyarország - Learning SQL with Microsoft SQL Server
Ireland - Learning SQL with Microsoft SQL Server
Luxembourg - Learning SQL with Microsoft SQL Server
Latvia - Learning SQL with Microsoft SQL Server
España - Learning SQL with Microsoft SQL Server
Italia - Learning SQL with Microsoft SQL Server
Lithuania - Learning SQL with Microsoft SQL Server
Nederland - Learning SQL with Microsoft SQL Server
Norway - Learning SQL with Microsoft SQL Server
Portugal - Learning SQL with Microsoft SQL Server
România - Learning SQL with Microsoft SQL Server
Sverige - Learning SQL with Microsoft SQL Server
Türkiye - Learning SQL with Microsoft SQL Server
Malta - Learning SQL with Microsoft SQL Server
Belgique - Learning SQL with Microsoft SQL Server
France - Learning SQL with Microsoft SQL Server
日本 - Learning SQL with Microsoft SQL Server
Australia - Learning SQL with Microsoft SQL Server
Malaysia - Learning SQL with Microsoft SQL Server
New Zealand - Learning SQL with Microsoft SQL Server
Philippines - Learning SQL with Microsoft SQL Server
Singapore - Learning SQL with Microsoft SQL Server
Thailand - Learning SQL with Microsoft SQL Server
Vietnam - Learning SQL with Microsoft SQL Server
India - Learning SQL with Microsoft SQL Server
Argentina - Learning SQL with Microsoft SQL Server
Chile - Learning SQL with Microsoft SQL Server
Costa Rica - Learning SQL with Microsoft SQL Server
Ecuador - Learning SQL with Microsoft SQL Server
Guatemala - Learning SQL with Microsoft SQL Server
Colombia - Learning SQL with Microsoft SQL Server
México - Learning SQL with Microsoft SQL Server
Panama - Learning SQL with Microsoft SQL Server
Peru - Learning SQL with Microsoft SQL Server
Uruguay - Learning SQL with Microsoft SQL Server
Venezuela - Learning SQL with Microsoft SQL Server
Polska - Learning SQL with Microsoft SQL Server
United Kingdom - Learning SQL with Microsoft SQL Server
South Korea - Learning SQL with Microsoft SQL Server
Pakistan - Learning SQL with Microsoft SQL Server
Sri Lanka - Learning SQL with Microsoft SQL Server
Bulgaria - Learning SQL with Microsoft SQL Server
Bolivia - Learning SQL with Microsoft SQL Server
Indonesia - Learning SQL with Microsoft SQL Server
Kazakhstan - Learning SQL with Microsoft SQL Server
Moldova - Learning SQL with Microsoft SQL Server
Morocco - Learning SQL with Microsoft SQL Server
Tunisia - Learning SQL with Microsoft SQL Server
Kuwait - Learning SQL with Microsoft SQL Server
Oman - Learning SQL with Microsoft SQL Server
Slovakia - Learning SQL with Microsoft SQL Server
Kenya - Learning SQL with Microsoft SQL Server
Nigeria - Learning SQL with Microsoft SQL Server
Botswana - Learning SQL with Microsoft SQL Server
Slovenia - Learning SQL with Microsoft SQL Server
Croatia - Learning SQL with Microsoft SQL Server
Serbia - Learning SQL with Microsoft SQL Server
Bhutan - Learning SQL with Microsoft SQL Server