课程大纲
分析函数
- 使用高级摘要功能
- 使用分层查询
- 使用分析汇总功能,例如移动平均线、汇总数据
- 使用排名函数
有用的 Database 对象
- 使用索引的原则
- 如何创建和维护索引
- 使用聚簇表
- 使用分区表
- 在 master 数据库中使用元数据
查询性能跟踪
- 查询执行和优化的原则
- 使用执行计划
- 使用表和索引统计
- 提示的使用
基本 Data Warehouse 技术
- 使用索引视图
- 维度和事实数据表的使用
- 使用星空和雪花设计
客户评论 (7)
关于CTE的讲座
Glyssa Mae - Metropolitan Bank and Trust Company
课程 - Transact SQL Advanced
机器翻译
Really enjoyed compression data components
James - Medtech Limited
课程 - Transact SQL Advanced
new techniques and style
Goniforte Balane - MORESCO-1
课程 - Transact SQL Advanced
Some additional tips given to us that is somewhat outside topic area
John Erzon Tan - MORESCO-1
课程 - Transact SQL Advanced
Outside topic tips Randomized new IDS, Indexes, Window function The joke was too funny and realistic
ALBERT SANDIG - MORESCO-1
课程 - Transact SQL Advanced
when the trainer lets us do task one by one. the additional tips and ideas given to us and also the joke haha
Carl Sherwin Francis Llenares - MORESCO-1
课程 - Transact SQL Advanced
Trainer is knowledgeable about the topic, and he really knows what he is doing. I appreciate the pacing and helps the trainees if there is a problem. He is also very engaging and very patient. Gives us words of encouragement very often and keeps training interesting.