HANA® SQL Professional and Advanced
Learn HANA® Native SQL, Modelling , Procedures and Performance Enhancement
- 12.0 hrs
- 75 Videos
- 5 Disqus Discussions
- 1 Download
- Earn Completion Certification
- Lifetime Access
- Money-Back Guarantee
Abhinandan Shivaiah
HANA® SQL Professional and Advanced is a unique course which will allow you to understand HANA® Native development in details from :
✓ SQL side
✓ Procedure development
✓ Architecture side
✓ Data provisioning side
✓ HANA® data modelling side
Details of the topics covered are:
✓ HANA® is an in-memory data platform details.
✓ HANA® Data Modeling
✓ HANA® Administration
HANA Database Architecture
✓ Index Server
✓ Persistence Layer
✓ Preprocessor Server
✓ Statistic Server
✓ Name Server
✓ Session and Transaction Manager
✓ XS Engine
✓ Data Provisioning in one single suite.
✓ Row store concept
* The table needs to store a limited number of records.
* When accessing one row at a time.
* When all the record is accessed from the table.
✓ Column Store concept
* Calculation is limited for a limited number of columns.
* Searching the table with a limited number of columns.
* Number of columns is very high.
* Number of records in the table is very high.
✓ Parallel Processing.
✓ Limitations for Storage
✓ Data Types.
✓ SQL Statements.
* Data Definition Language (DDL).
* Data Manipulation Language (DML)
* Transaction Control Language (TCL).
and much more...
Introduction to the Course
HANA® - Basics, Architecture, Parallel Processing, Column/Row Storage and Comparison
FREE PREVIEWHANA® 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
Introduction for Week 2 : Logical Containers in HANA® and Views
FREE PREVIEWHands-on Excercises for Week 2
What We Have Covered So Far and Plan for This Week
FREE PREVIEWHANA® 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, Steps, Output Columns Definition and their Data types.
FREE PREVIEWHANA® Modeling Steps to Create Scripted Calculation Views, VAR_OUT, Input variables, Filtering Records and data previews.
Ask Your Questions
Introduction to HANA® SQL Procedures and User Defined Functions
FREE PREVIEWHANA® 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 1
FREE PREVIEWCreate 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 1
FREE PREVIEWAssociation 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
Handle HTTP Methods From XSJS Services, Read From Table
FREE PREVIEWInput 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