UI5CN

Introduction to the Course

HANA® Architecture Overview , Index Server, pre-processor Server, Persistence Layer and Repositories.

HANA® Architecture Overview , Statistics Server, Name Server and XS Server.

Ask Your Questions

5 Simple Step to Install HANA on Google® Cloud Platform For Free

Step 1 and 2 : Create the Google® Account and Select Instance of HANA®

Step 3 - Select HANA® Configuration on GCP

Step 4 and 5 - Setup HXEADM and Public IP

Admin to Developer to Functional Consultant - Switching Hats

Getting Familiar With with GCP Dashboard

Eclipse Neon and Setup of the Development Environment

Add HANA® System to Eclipse Neon and Setup Development Environment

HANA® SQL - Basics, SQL DDL Statements Overview and Characteristics of DDL Statements.

HANA® SQL DDL Statements - Create, Alter, Rename and Drop Statements.

HANA® SQL DML Statement - Insert Statement and Select Statement with clauses.

HANA® SQL DML Statement - Select Statement clauses, Inner, Left Outer and Right Outer Joins.

HANA® SQL DML Statement - Update Statement and Delete Statement with Clauses

Ask Your Questions

Hands-on Excercises for Week 2

HANA® Modeling Basics - Views Basics, Filtering , Selecting , Decision Making, Data Types, Attributes and measures .

HANA® Modeling Basics - Data Types in Views, Attributes, Measure and it's Sub-Types, Types of Information Views.

HANA® Modeling Attribute Views, Characteristics Of Attribute Views, Types Of Attribute Views.

HANA® Modeling Attribute Views, Steps to create Attribute Views

HANA® Modeling Attribute Views, Steps to create Attribute Views, Data Foundation, Fields Selection, Joins, Calculated Column.

HANA® Modeling Attribute Views, Steps to create Attribute Views, Keys Fields Selection, Filtering Records and Preview Data.

HANA® Modeling Analytical Views and its Characteristics, Facts and Dimension Table Overview.

HANA® Modeling Steps to Create Analytical Views, Attribute View as data Foundation, Nodes in Analytical View.

HANA® Modeling Steps to Create Analytical Views, Adding Data Foundation, Selecting Columns, Joins and Specifying Measures.

HANA® Modeling Steps to Create Analytical Views, Input Parameters, Filtering Records with input parameters.

HANA® Modeling Steps to Create Analytical Views, Calculated Column Creation, Data Preview .

HANA® Modeling Calculation Views Basics, Characteristics, Nodes in Calculation Views, Types Of Calculation Views.

HANA® Modeling Steps to Create Graphical Calculation Views, Join, Union, Projection, Aggregation and Rank Nodes

HANA® Modeling Steps to Create Graphical Calculation Views, Using Nodes, Adding Data Source, Selecting Column.

HANA® Modeling Steps to Create Graphical Calculation Views, Renaming Nodes, Auto Layout, Keys Selection and specify Aggregation types.

HANA® Modeling Steps to Create Graphical Calculation Views, Input Parameters, Filtering Records And Calculated Columns.

HANA® Modeling Steps to Create Scripted Calculation Views, VAR_OUT, Input variables, Filtering Records and data previews.

Ask Your Questions

HANA® Procedures Introduction For Week 3

HANA® Procedures Data Types, SQL Logic, Overview Of Steps To Create Procedures

HANA® Procedures Create Procedures, In-out Parameters, Elements In Procedures

HANA® Procedures Parameter, Data Types, Filter And Return Table Records

HANA® Procedures Table Types, Steps To Create Table Types

HANA® Procedures Table Types, Table UDF, Parameters in Table UDF

HANA® Procedures Table UDF, Select, Return The Result, How To Use Table UDF

HANA® Procedures Table UDF, Filtering, Input Parameters, Use Table UDF

HANA® Procedures Read, Join The Tables, Return The Results

HANA® Procedures Local Temporary Table, Create Local Tables, Arrays And Functions

HANA® Procedures Arrays And Array Functions

HANA® Procedures Control Structures, Loops, If Statements, Break and Continue

HANA® Procedures Scalar UDF, Steps, IN/OUT, Calculations, Returns and Use Scalar UDF

Ask Your Questions

What we have covered so far and plan for this week

Architecture Overview of Hana XS Services, XSOdata, Overview On steps to create XSOdata

Create XSOData, XSAccess, Structure, Namespace, Expose Tables, columns visibility - Part 2

Expose Views, Key fields, Local Key fields

Association and navigation in XSOdata, Aggregation, Parameters in XSOData - Part 2

Association and navigation in XSOdata, Aggregation, Parameters in XSOData - Part 3

Custom exits, modification Exits

Custom exits, validation Exits, Before, After, Precommit, Postcommit

What and Why XSJS service, Overview of steps to create XSJS service

Create XSJS Service, Return a response from XSJS Service, Postman Client

Input Parameters For XSJS, Filtering the Records

Call procedure from XSJS, Input Parameters, Preview Result

Insert The Record Into Table, JSON Parameters, Preview Status

Update The Record From Table, Preview Status

Delete The Record Into Table, Preview Status

Ask Your Questions