Courses

Hana Development

Instructor
admin
0 Reviews

Course Description

1.   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.

 

2.   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

 Modeling

  • Calculation views
  • User Defined Table functions.
  • Performance Optimization of the views.
  • Decision tables
  • Text analysis
  • HANA Security, Analytical Privileges.

 

3.   HANA 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.

 

4.   HANA 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 Flowgraphs in Web IDE for HANA.
  • GitHub Integration for Source control.

 Node JS module and Web module

  • Workshop on a complete native Object development.
  • Serverside Java Script or Node JS.
  • OData Services to provide the data access.
  • Web module development for user applications.

About Instructor

  • admin

Reviews

0
0 Ratings
stars 5
0%
0
stars 4
0%
0
stars 3
0%
0
stars 2
0%
0
stars 1
0%
0

There are no reviews yet.

Leave a Review

Be the first to review “Hana Development”

Quick Contact