TOP SAP HANA TRAINING INSTITUTES IN HYDERABAD

SAP HANA Training Institute in Hyderabad

INTRODUCTION OF HANA

SAP HANA is an in-memory column-oriented, relational database management system developed and marketed by SAP. Its primary function as a database server is to store and retrieve data as requested by the applications. In addition, it performs advanced analytics. SAP S/4HANA is an abbreviation of SAP Business Suite 4 SAP HANA, an enterprise resource planning (ERP) software package. Organizations use SAP S/4HANA to integrate and manage business functions – such as finance, human resources, procurement, sales, manufacturing and service – in real time. It natively integrates with line-of-business solutions from SAP SE. In addition to intelligent ERP functionality, the suite includes supplier relationship management (SRM), customer relationship management (CRM), supply chain management (SCM), and product lifecycle management (PLM) functionality

  • Introduction to SAP HANA
  • Why Sap HANA?
  • Introduction to OLTP &OLAP
  • Introduction to SAP In-Memory
  • Strategy and Technology
  • S/4 HANA
  • How HANA is Plat form, In memory Data base ,software, Hard ware with Architecture
  • Why is SAP HANA so FAST?
  • SAP HANA Architecture
  • SAP HANA Database concepts
  • HANA Compared to BWA
  • Columnar tables architecture
  • HANA Landscapes
  • HANA Sizing
  • HANA Scenarios
  • HANA Job Profiles
  • HANA Studio/Eclipse:

  • Introduction and Installation to SAP HANA Studio with different perspectives
  • Introduction to Eclipse with different perspectives
  • Handling Practice Environment
  • Handling Real time Environment
  • Catalog
  • Content
  • Provisioning
  • Security
  • Different perspectives in HANA studio/Eclipse
  • Schema
  • SQL
  • Tables –Row store Column store,Global,local temporary table ,logging tables ,Portioning
  • Create,Alter,Drop Queries
  • Load,Unload,Preload flags, Merging techniques
  • Database Views
  • Synonyms
  • Sequences
  • Triggers
  • Indexes
  • Procedures
  • Columnar views
  • In memory Computing Studio
  • Perspectives
  • Administration views
  • Navigation View
  • System monitor
  • Information modeler
  • Preferences
  • Local settings
  • Loading data into HANA
  • Data modelling concepts
  • Reporting
  • Backup and Recovery
  • MODELLING:

  • Understanding Different Types of Joins in SAP HANA
  • Inner ,Left Outer, Right Outer, Referential ,Text, Temporal,Spatial
  • Attribute View:

  • Standard Attribute View
  • Time Based Attribute View
  • Derived Attribute View
  • Creating Calculated Column
  • Creating Hierarchies in Attribute Views
  • Dynamic Filter-Using Input Parameters
  • Enabling Attribute View for Time Travel Queries by using History Table
  • Analytical View:

  • Understanding STAR Join Node
  • Creating Calculated Columns & Measures
  • Restricted Columns
  • Counters
  • Input Parameters
  • Variables
  • Semantics
  • Analytical View Properties
  • Focusing on Temporal Join in Analytical View
  • Calculation View:

  • Calculation View
  • Understanding Calculation view Properties-Data Category(Star Join)
  • SQL Scripted Based &Graphical Mode
  • Understanding different nodes in Calculation view
  • Projection
  • Aggregation
  • Join
  • Union
  • Rank
  • Understanding Dynamic Join
  • Understanding KEEP FLAG Property
  • Understanding Transparent Filter Property
  • Understanding STAR Join Node
  • Created Calculated Columns &Measures
  • Restricted Columns (Dynamic with Input Parameters)
  • Counters
  • Input Parameters
  • Variables
  • Semantics
  • Extract Semantics
  • Creating Hierarchies in Calculation View
  • Processing of HANA Models
  • Analytical Privileges:

  • Static
  • Dynamic with Stored Procedures
  • Decision Tables:

  • Updating
  • What if Analysis
  • Reporting:

  • HANA, Reporting Layer and Connectivity option
  • Business Objects BI 4.0(Just an overview)
  • Overview of others
  • Data Provisioning:

  • Overview
  • HANA as Primary data base
  • HANA as side car/Secondary data base
  • Smart Data Access
  • Smart access overview

    Replication of data through SDA

    Different landscapes

  • SLT

    SLT overview

    Replication of data through SLT

    Different landscapes

  • BODS

    BODSoverview

    Replication of data through BODS

    Different landscapes

  • Flat files

    Flat file overview

    Replication of data through Flatfile

    Different landscapes

    OBJECT ORIENTED ABAP (OOABAP)

  • Procedural and object oriented approach
  • OOABAP concepts
  • Local class
  • Global class
  • Instance and statics methods
  • Constructor ,class constructor
  • Interfaces
  • Super class ,subclass
  • ABAP ON HANA

  • SAP HANA as Secondary Database –Access via Open SQL
  • Preparing for SAP HANA
  • Improve Open SQL Using ABAP test Cockpit(ATC)
  • Use the SQL Performance Tuning Worklist to Analyze Static and Runtime Check Results
  • Improve Open SQL Statement Using The SQL Trace(ST05)
  • Performance Rules and Guidelines for SAP HANA
  • Optimizing ABAP on Primary Database SAP HANA New Open SQL:

  • Core Data Services in ABAP
  • New features in Open SQL
  • Associations in Core Data Services
  • Use Associations in Core Data Services in ABAP
  • Columnar/Row store Table creations through GUI
  • Code-To-Data with SAP HANA AS Secondary Database:

  • Classical Open SQL and its Limitations
  • ABAP Database Connectivity(ADBC)
  • Native SQL Syntax
  • Procedures
  • External Views
  • Calling SAP HANA Procedures in ABAP
  • Calling External views in ABAP
  • Using ABAP-Managed Database Procedures:

  • ABAP-Managed Database Procedures
  • Create and Call an ABAP-Managed Database Procedures
  • Debugging ABAP-managed Database Procedures
  • Integrating with UI5
  • Integrating with Calculation views
  • SAP HANA Proxy Objects:

  • Accessing SAP HANA Views via ABAP Dictionary External views
  • Create an External View for SAP
  • HANA View and Use it an Open SQL SELECT
  • Transport of SAP HANA Objects
  • Create HANA Transport Container for a Delivery
  • Calling SAP HANA Procedures via ABAP Database Procedure Proxies
  • S/4 HANA

  • S/4 Finance Overview
  • S/4 Finance simplified tables
  • S/4 Finance Fiori apps
  • S/4 Finance transactions
  • S/4 LogisticsOverview
  • S/4 Logistics simplified tables
  • S/4 Logistics Fiori apps
  • S/4 Logistics transactions
  • HANA Modelling,ABAP on HANA,UI5,Fiori,Data Provisioning in S/4 Hana
  • HANA Migration

  • ABAP Reports
  • ABAP Dictionary
  • Code review tools
  • ABAP coding standards and procedures
  • ABAP objects post HANA migration
  • Ui5, Fiori, Gateway:

  • Introduction to SAP UI5
  • Introduction to SAP NetWeaver Gateway
  • Introduction to SAP Fiori
  • Webdynpro ABAP overview .MVC Architecture
  • Webdynpro ABAP development
  • Difference between UI5/Fiori, Webdynpro& other Web Technologies
  • Difference between Webdynpro and ui5
  • Disadvantages of the Previous Technologies
  • Advantages of Sapui5 and how it overcomes the disadvantages of previous technologies
  • Understanding each layer of MVC model
  • Understanding on End to End Data flow in SAPUi5
  • SAP ODATA ABAP SERVICES ON NETWEAVER GATEWAY

  • Gateway Architecture Overview & Usage
  • Technical Components Involved
  • Introduction to REST, OData
  • OData advantages
  • OData formats JSON and XML
  • Structure of an OData Service
  • Service Document, Service Metadata Document
  • OData in SAP Solutions:

  • EDM data types
  • SAP NetWeaver Gateway Service Builder (SEGW)
  • Data Model:

  • Entity Types
  • Entity Sets
  • Properties , Navigation Properties
  • Association ( Referential Constraints, Principal Entity, Dependent Entity )
  • Association Set( Principle Entity Set, Dependent Entity Set )
  • Cardinality
  • Mappings
  • Runtime Artifacts:

  • Model Provider Base
  • Model Provider Extension
  • Data Provider Base
  • Data Provider Extension
  • Service Maintenance:

  • Registration in Hub Systems
  • Maintain
  • Error log
  • Gateway Client
  • HTTP Status codes, Common Messages and Common Errors
  • Debugging OData ABAP Services
  • With & Without Mapping in Odata Services:

  • BAPI's with Mapping ,
  • Database Views with Mapping
  • BAPI's without Mapping
  • Multiple BAPI's with Single Entity Set
  • CRUD Operations in OData Services:

  • CreateEntity( )
  • DeleteEntity( )
  • UpdateEntity( )
  • GetEntity ( Read )
  • GetEntitySet( Query )
  • GetExpandedEntitySet
  • UpdateStream()
  • GetStream( )
  • ExecuteAction( ) etc.
  • Service URL Parameters:

  • Filtering and Projecting ($filter, ?search and $select)
  • Sorting ($orderby) , Counting ($count)
  • Client-Side Paging ($top, $skip, and $inlinecount)
  • Inlining ($expand) , Formatting ($format)
  • Configuration AndMaintenance Of Gateway:

  • SPRO related Configurations
  • SICF related Configurations
  • Deploying SAP Fiori apps to SAP ABAP UI5 repository:

    SAP FIORI LAUNCH PAD CONFIGURATION

  • Launch Pad Instance Roles
  • Semantic Objects
  • Catalogs
  • Target Mappings
  • Tiles
  • Groups
  • PFCG Roles (Role to User Assignment)
  • Types of Models:

  • Resource Model,
  • JSON Model,
  • XML Model,
  • OData Model
  • Bindings:

  • One-way Binding, Two way Binding, One Time Binding
  • Data binding, Aggregate binding, Model binding
  • Data Types:

  • SAPUI5 Data Typing, User types
  • Integers, Floating-Point Numbers
  • String, Boolean, Variable, Date and Time,
  • Types of Views:

  • JavaScript Views, (imp)
  • Xml Views, (imp)
  • Json Views,
  • Html Views,
  • Implementing code in VIEWs and CONTROLLERs Technique.

    HANA Certification Guidance and Material, VIDEOS

    Discussion on HANA Best Practices

    Discussion on HANA Interview Questions