|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-hana-sql/
课程评论：没有评论
课程名称：学习HANA SQL 课程概述：本课程全面涵盖了HANA®开发的各个方面，旨在为您提供所需的知识。课程内容从基础到中级再到高级，逐步介绍了HANA®架构、HANA®建模、存储过程、XSJS和XS oData等多个主题。特别是在HANA®建模方面，我们创建逻辑容器来存储虚拟数据，包括属性视图、分析视图、计算视图，以及自定义计算列的创建，所有这些都通过详尽易懂的讲解和演示得到展示。 我们特别关注以下内容： - 过滤、选择、决策制定、数据类型、属性和度量 - 属性视图：关键字段、记录过滤和数据预览 - 分析视图：特征、事实和维度表概述 - 分析视图：数据基础和节点、选择列、连接和指定度量 - 分析视图：计算列和数据预览 - 计算视图：特征、节点和类型、添加数据源、选择列 - 图形计算视图（GCV）：连接、并集、投影、聚合和排名 - GCV：重命名节点、自动布局、关键和聚合 - GCV：输入参数、过滤和计算列 - 脚本计算视图 此外，我们还关注存储过程、XSJS和XS oData，确保您全面了解以下内容： - 表类型、本地临时表、标量变量和用户定义函数 - 表用户定义函数、存储过程中的循环概念 - 数组函数（如数组聚合）、命令式语句和声明式语句 - XSJS服务API，使用视图公开XS oData服务 本课程以简单易懂的方式和动手实践的方式全面讲解以上所有主题。欢迎参与学习！
This one comprehensive course covers all the aspect of HANA® Development to help you when it matter. We have covered all concepts from basics to intermediate to advance in step-by-step, We have covered the details of HANA® Architecture, HANA® Modelling, Procedure, XSJS and XS oData and lot More. Also, when it comes to HANA® Modeling. We create Logical Containers to hold our Virtual data in views, may it be Attribute Views, Analytical Views, Calculation View or even creating custom calculated column these takes lot of time to search through, and all of these are covered in a detail and simple way with demos in this course. We have given special attention to: Filtering, Selecting , Decision Making, Types, Attributes and measuresAttribute Views - Keys Fields Filtering Records and Preview DataAnalytical Views - Characteristics, Facts and Dimension Table OverviewAnalytical Views - Data Foundation and NodesAnalytical Views - Selecting Columns, Joins and Specifying MeasuresAnalytical Views - Calculated Column and Data Preview Calculation Views - Characteristics, Nodes and Types Calculation Views - Adding Data Source, Selecting Column Graphical Calculation Views(GCV) GCV - Join, Union, Projection, Aggregation and RankGCV - Renaming Nodes, Auto Layout, Keys and AggregationGCV - Input Parameters, Filtering And Calculated ColumnsScripted Calculation Views And not only this we have given attention to Procedure, XSJS and XS oData. So you would be able to get complete information on: Table types Local temporary tables Scalar Variables and User-defined functions Table User Defined Functions Looping concept inside Procedures Array functions like array aggregation Imperative statement and declarative statement XSJS Service API's Exposing xs oData Services with Views All covered in our course in simple to explanation and hands-on manner.
