Course Overview:
Course Name
SAP Native HANA
Demo Classes On
Demand
Mode of Classes Online
Course Duration 40-45 Hours
Class Availability Weekdays &
Weekends
Demo Training Email ID :
info@greenboardlearninghub.com
Native HANA means it is something build on top of the HANA BOX and it can
have the full HANA performance and benefits and there is another term
called non-native HANA applications which means the developments done
using other technologies can also run on top of HANA, like .net, java
applications.
The term HANA enterprise is related to the release like HANA platform
edition, enterprise edition and enterprise extended edition.
COURSE CONTENT
HANA as Database
Introduction to HANA Database and Architecture.
- HANA Servers, Engines and Data base versions.
- HANA Studio, HANA Web Workbench.
- Design and run time objects, Schema, Content and different prospective.
- XS classic and XS Advanced.
SQL programming– Coding
- SQL syntax for Creating Tables and Views.
- Insert, update and delete data using SQL
- Partitioning, Compression and Indexing.
- Synonyms, Data base Triggers and Sequences.
- SQL Queries, Sub Queries or nested.
- Joins, Union, Aggregation, Rank and Partition
SQL Scripting
- Standard SQL functions, Custom functions
- Stored Procedures
- CURSOR processing
- If then else and CASE statement.
- While loop and For Loops.
- Exception Handling
- Dynamic SQL
- SQL Code debugging.
- Performance optimization of code.
HANA as ETL and Data Warehousing
Data Provisioning
- BO Data Services, Data flows.
- Smart Data Access (SDA)
- Smart Data Integration (SDI)
- ETL using SQL code
- Flow Graphs and Replication tasks.
- Core Data Services for data persistency
Modelling
- Calculation views
- User Defined Table functions.
- Performance Optimization of the views.
- Decision tables
- Text analysis
- HANA Security, Analytical Privileges.
HANA as in for BW4 HANA and S4 HANA
BW/4 HANA
- HANA Optimized Cubes.
- Advanced DSO, Open ODS view and Composite Providers.
- SAP Classic object migration, Performance optimization projects.
- HANA Query Designer.
- Mixed approaches with Native HANA.
S/4 HANA Analytics
- Core Data Services, Data persistency and Consumption.
- ABAP CDS Views for analytics.
- Embedded analytics in OData browser.
HANA 2.0 SP 2, XS Advanced, using Web IDE for HANA
Database module
- HANA Express Edition on Google Cloud platform.
- XS commands in Secure Shell (SSH)
- HDI container, Database module deployment.
- Synonyms to access Classical schema.
- CDS artifacts
- ETL Flow graphs in Web IDE for HANA.
- GitHub Integration for Source control.
Node JS module and Web module
- Workshop on a complete native Object development.
- Server side Java Script or Node JS.
- OData Services to provide the data access.
- Web module development for user applications.
