Learn HANA® SQL
4.3 (19 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
678 students enrolled

Learn HANA® SQL

Learn HANA® Native SQL, Modelling , Procedures and Performance Enhancement
4.3 (19 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
678 students enrolled
Created by CS PRO
Last updated 8/2018
English
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5 hours on-demand video
  • 1 article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • At the end of the course you will have a strong understanding and practical knowledge about SAP® HANA®
Course content
Expand all 52 lectures 04:54:58
+ Getting Access to SAP® HANA® XS With Google® Cloud Platform With Free Trial
8 lectures 55:21
5 Simple Step to Install HANA on Google® Cloud Platform For Free
04:22
Step 1 and 2 : Create the Google® Account and Select Instance of HANA®
07:01
Step 3 - Select HANA® Configuration on GCP
07:49
Step 4 and 5 - Setup HXEADM and Public IP
08:58
Admin to Developer to Functional Consultant - Switching Hats
04:23
Getting Familiar With with GCP Dashboard
07:33
Eclipse Neon and Setup of the Development Environment
09:27
Add HANA® System to Eclipse Neon and Setup Development Environment
05:48
+ Week 1 - HANA® Architecture and Native SQL Basics
5 lectures 27:06
HANA® SQL - Basics, SQL DDL Statements Overview and Characteristics of DDL State
03:20
HANA® SQL DDL Statements - Create, Alter, Rename and Drop Statements
05:26
HANA® SQL DML Statement - Insert Statement and Select Statement with clauses
06:21
HANA® SQL DML Statement - Select Statement clauses, Inner, Left Outer and Right
06:04
HANA® SQL DML Statement - Update Statement and Delete Statement with Clauses
05:55
+ Logical Containers in HANA-Attribute View,Analytical View,CalculationView & More
21 lectures 01:54:19
Introduction for Week 2 : Logical Containers in HANA® and Views
05:45
Hands-on Excercises for Week 2
00:10
What We Have Covered So Far and Plan for This Week
01:30
HANA® Modeling Basics-Views Basics,Filtering,Selecting,Decision Making
06:51
HANA® Modeling Basics-Data Types in Views, Attributes, Measure & it's Sub-Types
05:33
HANA® Modeling Attribute Views, Characteristics Of Attribute Views & their Types
06:32
HANA® Modeling Attribute Views, Steps to create Attribute Views
05:06
HANA® Modeling Attribute Views, Steps to create Attribute Views, Data Foundation
07:31
HANA® Modeling Attribute Views, Steps to create Attribute Views
04:37
HANA® Modeling Analytical Views & its Characteristics, Facts & Dimension Table
05:02
HANA® Modeling Steps to Create Analytical Views, Attribute View
07:10
HANA® Modeling Steps to Create Analytical Views, Adding Data Foundation & More
05:34
HANA® Modeling Steps to Create Analytical Views, Input Parameters and More
05:32
HANA® Modeling Steps to Create Analytical Views, Calculated Column Creation
04:12
HANA® Modeling Calculation Views Basics,Characteristics,Nodes in CalculationView
06:03
HANA® Modeling Steps to Create Graphical Calculation Views, Join, Union, & More
09:41
HANA® Modeling Steps to Create Graphical Calculation Views, Using Nodes & More
05:25
HANA® Modeling Steps to Create Graphical Calculation Views, Renaming Nodes &More
04:50
HANA® Modeling Steps to Create Graphical Calculation Views, InputParameters&More
08:10
HANA® Modeling Steps to Create Scripted Calculation Views, Steps, Output Columns
04:08
HANA® Modeling Steps to Create Scripted Calculation Views, VAR_OUT, Input var
04:57
+ HANA® Procedures
14 lectures 01:24:23
Introduction to HANA® SQL Procedures and User Defined Functions
06:43
HANA® Procedures Introduction For Week 3
00:46
HANA® Procedures Data Types, SQL Logic, Overview Of Steps To Create Procedures
06:20
HANA® Procedures Create Procedures, In-out Parameters, Elements In Procedures
05:27
HANA® Procedures Parameter, Data Types, Filter And Return Table Records
05:30
HANA® Procedures Table Types, Steps To Create Table Types
04:13
HANA® Procedures Table Types, Table UDF, Parameters in Table UDF
06:57
HANA® Procedures Table UDF, Select, Return The Result, How To Use Table UDF
06:30
HANA® Procedures Table UDF, Filtering, Input Parameters, Use Table UDF
07:57
HANA® Procedures Read, Join The Tables, Return The Results
05:59
HANA® Procedures Local Temporary Table, Create Local Tables, Arrays And Function
06:58
HANA® Procedures Arrays And Array Functions
06:07
HANA® Procedures Control Structures, Loops, If Statements, Break and Continue
06:28
HANA® Procedures Scalar UDF, Steps, IN/OUT, Calculations, Returns & More
08:28
Requirements
  • Some level of experience in SAP®
Description

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.

Who this course is for:
  • SAP Consultants
  • Architects
  • Developers
  • Senior Consultants