SAP Native HANA online training
pvv technologies provides a SAP Native HANA online Training. This course all key capabilities of SAP HANA at a high level. This Course focus on the core capabilities of SAP HANA for modelling. And covers mainly graphical modelling, which is illustrated by the SAP HANA Live virtual data model. You well learn the essential techniques and tools of data provisioning and data transformation for SAP Native HANA. And it provides a complete knowledge to build a SQL data warehouse in HANA.
Utilize this opportunity in pvvtechnologies to improve your skills in this course. We providing a job placements in top MNC’s companies. We providing a real time online courses certification certification courses and we also providing a 1500 placements and we tie- up with top MNC’s companies and we are providing a training with expert trainers and our team is fully support to your training time
Couse Content:
- HANA as Database:
1.1. 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.
1.2. 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
1.3. 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
2.1. 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
2.2. 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
3.1. 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.
3.2. 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
4.1. 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.
4.2. 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.
