Learn HANA® SQL

Learn HANA® SQL, available at $44.99, has an average rating of 3.15, with 52 lectures, based on 70 reviews, and has 1020 subscribers.

You will learn about At the end of the course you will have a strong understanding and practical knowledge about SAP® HANA® This course is ideal for individuals who are SAP Consultants or Architects or Developers or Senior Consultants It is particularly useful for SAP Consultants or Architects or Developers or Senior Consultants.

Enroll now: Learn HANA® SQL

Summary

Title: Learn HANA® SQL

Price: $44.99

Average Rating: 3.15

Number of Lectures: 52

Number of Published Lectures: 52

Number of Curriculum Items: 52

Number of Published Curriculum Objects: 52

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

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

Who Should Attend

SAP Consultants
Architects
Developers
Senior Consultants

Target Audiences

SAP Consultants
Architects
Developers
Senior Consultants

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

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction to the Course

Lecture 2: HANA®-Basics,Architecture,Parallel Processing,Column/Row Storage & Comparison

Lecture 3: HANA® Architecture Overview,Index Server,pre-processor Server, Persistence Layer

Lecture 4: HANA® Architecture Overview , Statistics Server, Name Server and XS Server.

Chapter 2: Getting Access to SAP® HANA® XS With Google® Cloud Platform With Free Trial

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

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

Lecture 3: Step 3 – Select HANA® Configuration on GCP

Lecture 4: Step 4 and 5 – Setup HXEADM and Public IP

Lecture 5: Admin to Developer to Functional Consultant – Switching Hats

Lecture 6: Getting Familiar With with GCP Dashboard

Lecture 7: Eclipse Neon and Setup of the Development Environment

Lecture 8: Add HANA® System to Eclipse Neon and Setup Development Environment

Chapter 3: Week 1 – HANA® Architecture and Native SQL Basics

Lecture 1: HANA® SQL – Basics, SQL DDL Statements Overview and Characteristics of DDL State

Lecture 2: HANA® SQL DDL Statements – Create, Alter, Rename and Drop Statements

Lecture 3: HANA® SQL DML Statement – Insert Statement and Select Statement with clauses

Lecture 4: HANA® SQL DML Statement – Select Statement clauses, Inner, Left Outer and Right

Lecture 5: HANA® SQL DML Statement – Update Statement and Delete Statement with Clauses

Chapter 4: Logical Containers in HANA-Attribute View,Analytical View,CalculationView & More

Lecture 1: Introduction for Week 2 : Logical Containers in HANA® and Views

Lecture 2: Hands-on Excercises for Week 2

Lecture 3: What We Have Covered So Far and Plan for This Week

Lecture 4: HANA® Modeling Basics-Views Basics,Filtering,Selecting,Decision Making

Lecture 5: HANA® Modeling Basics-Data Types in Views, Attributes, Measure & it's Sub-Types

Lecture 6: HANA® Modeling Attribute Views, Characteristics Of Attribute Views & their Types

Lecture 7: HANA® Modeling Attribute Views, Steps to create Attribute Views

Lecture 8: HANA® Modeling Attribute Views, Steps to create Attribute Views, Data Foundation

Lecture 9: HANA® Modeling Attribute Views, Steps to create Attribute Views

Lecture 10: HANA® Modeling Analytical Views & its Characteristics, Facts & Dimension Table

Lecture 11: HANA® Modeling Steps to Create Analytical Views, Attribute View

Lecture 12: HANA® Modeling Steps to Create Analytical Views, Adding Data Foundation & More

Lecture 13: HANA® Modeling Steps to Create Analytical Views, Input Parameters and More

Lecture 14: HANA® Modeling Steps to Create Analytical Views, Calculated Column Creation

Lecture 15: HANA® Modeling Calculation Views Basics,Characteristics,Nodes in CalculationView

Lecture 16: HANA® Modeling Steps to Create Graphical Calculation Views, Join, Union, & More

Lecture 17: HANA® Modeling Steps to Create Graphical Calculation Views, Using Nodes & More

Lecture 18: HANA® Modeling Steps to Create Graphical Calculation Views, Renaming Nodes &More

Lecture 19: HANA® Modeling Steps to Create Graphical Calculation Views, InputParameters&More

Lecture 20: HANA® Modeling Steps to Create Scripted Calculation Views, Steps, Output Columns

Lecture 21: HANA® Modeling Steps to Create Scripted Calculation Views, VAR_OUT, Input var

Chapter 5: HANA® Procedures

Lecture 1: Introduction to HANA® SQL Procedures and User Defined Functions

Lecture 2: HANA® Procedures Introduction For Week 3

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

Lecture 4: HANA® Procedures Create Procedures, In-out Parameters, Elements In Procedures

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

Lecture 6: HANA® Procedures Table Types, Steps To Create Table Types

Lecture 7: HANA® Procedures Table Types, Table UDF, Parameters in Table UDF

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

Lecture 9: HANA® Procedures Table UDF, Filtering, Input Parameters, Use Table UDF

Lecture 10: HANA® Procedures Read, Join The Tables, Return The Results

Lecture 11: HANA® Procedures Local Temporary Table, Create Local Tables, Arrays And Function

Lecture 12: HANA® Procedures Arrays And Array Functions

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

Lecture 14: HANA® Procedures Scalar UDF, Steps, IN/OUT, Calculations, Returns & More

Instructors

CS PRO
Computer Science for Professional
UI5 Community Network
Experts in Services, Consulting and Education

Rating Distribution

1 stars: 8 votes
2 stars: 8 votes
3 stars: 25 votes
4 stars: 16 votes
5 stars: 13 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu