Learn HANA® SQL Free Video Course Free Download

HANA® SQL Learn HANA® SQL Free Video Course, Modelling , Procedures and Performance Enhancement

What you will learn:

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

Requirements of HANA® SQL:

• Some level of experience in SAP®

Description of HANA® SQL:

HANA® SQL is 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

Course content of HANA® SQL:

Introduction of HANA® SQL:

• HANA®-Basics,Architecture,Parallel Processing,Column/Row Storage & Comparison
• HANA® Architecture Overview,Index Server,pre-processor Server, Persistence Layer
• HANA® Architecture Overview , Statistics Server, Name Server and XS Server.

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

• 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

Week 1 – HANA® Architecture and Native SQL Basics:

• HANA® SQL – Basics, SQL DDL Statements Overview and Characteristics of DDL State
• 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
• HANA® SQL DML Statement – Update Statement and Delete Statement with Clauses

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

• Introduction for Week 2 : Logical Containers in HANA® and Views
• Hands-on Excercises for Week 2
• What We Have Covered So Far and Plan for This Week
• HANA® Modeling Basics-Views Basics,Filtering,Selecting,Decision Making
• HANA® Modeling Basics-Data Types in Views, Attributes, Measure & it’s Sub-Types
• HANA® Modeling Attribute Views, Characteristics Of Attribute Views & their Types
• HANA® Modeling Attribute Views, Steps to create Attribute Views
• HANA® Modeling Attribute Views, Steps to create Attribute Views, Data Foundation
• HANA® Modeling Attribute Views, Steps to create Attribute Views
• HANA® Modeling Analytical Views & its Characteristics, Facts & Dimension Table
• HANA® Modeling Steps to Create Analytical Views, Attribute View
• HANA® Modeling Steps to Create Analytical Views, Adding Data Foundation & More
• HANA® Modeling Steps to Create Analytical Views, Input Parameters and More
• HANA® Modeling Steps to Create Analytical Views, Calculated Column Creation
• HANA® Modeling Calculation Views Basics,Characteristics,Nodes in Calculation
• HANA® Modeling Steps to Create Graphical Calculation Views, Join, Union, & More
• HANA® Modeling Steps to Create Graphical Calculation Views, Using Nodes & More
• HANA® Modeling Steps to Create Graphical Calculation Views, Renaming Nodes &More
• HANA® Modeling Steps to Create Graphical Calculation Views, InputParameters&More
• HANA® Modeling Steps to Create Scripted Calculation Views, Steps, Output Columns
• HANA® Modeling Steps to Create Scripted Calculation Views, VAR_OUT, Input var

HANA® Procedures:

• Introduction to HANA® SQL Procedures and User Defined Functions
• 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 Function
• 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 & More

Now! Learn HANA® SQL Free Video Course by clicking below download button, If you have a any question so! comment now!..

Join on Telegram

Wait 15 Second For Download This File For Free

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

if you find any wrong activities so kindly read our DMCA policy also contact us. Thank you for understand us…