UDEMY 2021 - Learn HANA® SQL

Learn HANA® Native SQL, Modelling , Procedures and Performance Enhancement

What you’ll learn

At the end of the course you will have a strong understanding and practical knowledge about SAP® HANA®

Requirements

Some level of experience in SAP®

Description

Filtering, Selecting , Decision Making, Types, Attributes and measures

Attribute Views – Keys Fields Filtering Records and Preview Data

Analytical Views – Characteristics, Facts and Dimension Table Overview

Analytical Views – Data Foundation and Nodes

Analytical Views – Selecting Columns, Joins and Specifying Measures

Analytical 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 Rank

GCV – Renaming Nodes, Auto Layout, Keys and Aggregation

GCV – Input Parameters, Filtering And Calculated Columns

Scripted 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.

Who is the target audience?

SAP Consultants

Architects

Developers

Senior Consultants

Created by CS PROLast updated 8/2018English

Size: 3.11 GB

Download File Here

https://www.udemy.com/learn-hana-sql/.