HANA® SQL Professional and Advanced is a unique course which will allow you to understand HANA® Native development in details from :
https://www.ui5cn.com/courses/hana-sq...
✓ 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...