|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-ssas-query-languages-t-sql-mdx-dax-dmx/
课程评论：没有评论
**课程名称：** Mastering SQL Server Query Languages - T-SQL, MDX, DAX & DMX **课程概览：** 本课程旨在教授学员掌握 SQL Server 的四种核心查询语言：T-SQL、MDX、DAX 和 DMX。课程由一位拥有超过 14 年经验、为国际客户提供商业智能、数据挖掘和分析服务的微软 MVP、已出版作者和资深技术架构师讲授。 **课程亮点：** 1. **全能型学习体验：** 从零开始学习 T-SQL、MDX、DAX 和 DMX，并有机会直接向经验丰富的讲师提问。 2. **一站式掌握四种语言：** 无需任何查询语言基础，本课程将详细教授四种语言，使学员能够胜任 SQL 开发者、SSAS 开发者或数据挖掘开发者的职位。您还可以通过同一 instructor、同一份样本数据，直观地比较四种语言的查询技巧。 3. **海量实践查询：** 课程包含超过 1000 条针对 OLTP、OLAP 和数据挖掘模型的查询示例，并附有详尽解释。 4. **丰富的可下载资源：** 提供 15 份精选的 MSDN 参考指南，涵盖 SQL Server、数据挖掘、T-SQL、MDX、DAX 和 DMX 的理论、语法、示例和参考链接；1000+ 条即用型 T-SQL、MDX、DAX 和 DMX 查询；以及 1 个样本 OLTP 数据库、1 个样本数据仓库、1 个包含样本数据和数据挖掘模型的 OLAP Database 的链接。 **课程描述：** 无论您是否具有数据库查询开发经验，本课程都将循序渐进地培训您，让您能够自信地独立参与高性能数据库开发项目。课程结合了以求职为导向的实操查询、详细解释和分析，以及关键概念的理论讲解。本课程使用最新的 SQL Server 2016 版本，提供快速的学习路径，让您掌握四种查询语言的实际应用。课程甚至包含了 SQL Server、SSAS 的安装以及样本数据的配置。 **课程结构：** 课程内容主要分为以下几个部分：基础知识、T-SQL、MDX、DAX 和 DMX。所有查询语言都将涵盖相同的主题，包括选择、连接、分组、过滤、排序、导航和计算。
Top 4 Reasons to take this course: 1) You can learn T-SQL, MDX, DAX and DMX from scratch as well as ask questions directly to a Published Author, Microsoft MVP, and a Senior Technology Architect with more than 14 years of experience who actively practices Business Intelligence, Data Mining and Analytics in real-world client projects internationally. 2) In a single course, without any prior query development experience - You can learn four query languages - T-SQL, MDX, DAX and DMX, in such detail that you can apply for a job of SQL Developer / SSAS Developer / Data Mining Developer. Also you get to compare the querying techniques in 4 different query languages side by side using examples from a single course, taught by a single instructor on the same sample data. 3) More than 1000+ queries are explained in the course on OLTP, OLAP and Data Mining Models. 4) Downloadable Course Content: 15+ curated reference guides from MSDN which provides exhaustive theory, syntax, examples and reference links for SQL Server, Data Mining, T-SQL, MDX, DAX, and DMX.1000+ Ready-to-use T-SQL, MDX, DAX and DMX QueriesLinks to 1 Sample OLTP Database, 1 Sample Data Warehouse, 1 OLAP Database with sample data and data mining models. Course Description SQL Server and SSAS Query Languages - T-SQL, MDX, DAX and DMX is a course in which a student having no experience in database query development would be trained step by step to a level where the student is confident to independently work in a high-performing database development project. Course includes job-oriented practical hands-on queries with explanation and analysis, and theoretical coverage of key concepts. This is a fast track course to learn practical query development on 4 query languages using the latest version of SQL Server - 2016. No prior experience of working with any query language is required. Even installation of SQL Server, SSAS and Sample Data is covered in the course. The course is structured in the following categories: Fundamentals, T-SQL, MDX, DAX and DMX. All the query languages have a common coverage that explains Selection, Joins, Grouping, Filtering, Sorting, Navigation, Calculations on the corresponding data models.
