Back
Next product
sap SD Training videos by praveen SAP SD  8,000.00  4,000.00
-50%

SAP HANA

 14,000.00  7,000.00

SAP HANA is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE. Its primary function as a database server is to store and retrieve data as requested by the applications.

Category:
Description

Description

72 / 100 SEO Score

SAP HANA2.0  COURSE CONTENT

what is SAP HANA
why is SAP HANA to Fast …?
SAP Hana Architecture
Understanding about Index server and engines
Discussion on SAP HANA UseCases
Introducing SAP HANA studio
SAP Hana Database concepts
  • Schema
  • Database Tables_Row Store and Column store
  • Database Views
  • Synonyms
  • Triggers
  • Sequences
  • Table_UDF(User Defined Functions)
  • Stored Procedures
  • Table Types
  •  Column Views
Basis SQL
Stored Procedures
  • Simple stored procedures
  • Looping Statements
  • Conditional Statements
  • Using Arrays
  • Using cursor
  • Using Temp and Table Types
  • Stored Procedures with Column views
  • using SQL functions
  • Using CE Functions
  • Debugging Stored procedures
SAP HANA MODELING
  • Introduction to the modeling
  • 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 calculating column
  • Creating Hierarchies in Attribute views
  • Dynamic filter_ Using input parameters
  • Enabling Attribute view for time travel queries by using history tables
 ANALYTICAL VIEW
  • Understanding STAR join Node
  • creating calculated columns and measures
  • Restricted columns
  • counters
  • Input parameters
  • Variables
  • Semantics
  • Analytical view properties
  • Focusing on Temporal join in Analytical view
  • Mapping of Input parameters
CALCULATION VIEW
  • Understanding Calculation view properties _ Data category(STAR JOIN)
  • SQL Scripted Based & Graphical Mode
  • Understanding different nodes in Calculation view
  • Projection
  • Aggregation
  • JOINS
  • UNION
  • RANK
  • Understanding Dynamic join
  • Understanding KEEP FLAG Property
  • Understanding Transparent filter property
  • Understanding STAR JOIN NODE
  • Creating calculated columns and 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 stored procedures
DECISION TABLES
  • Updating
  • What if Analysis
REPORTING ON SAP HANA
  • SAP Lumira (In detail and publishing sap lumira story boards and data sets into sap lumira server embedded on to HANA Server
  • Design studio( In Detail and publishing application on to SAP HANA access engine )
  • IDT and WEBI  ( Just on over view)
 DATA PROVISIONING
  • Using BODS
  • Using SLT
  • using DXC
  • Flat file imports
  • Bulk loading of flat file imports
  • Smart Data Access
  • Smart data integration
IMPORTING AND  EXPORTING OF SAP HANA OBJECTS
 SAP BW/4HANA
  • hana optimized info cube
  • hana optimized DSO
  • Transient Provider
  • consuming hana models in SAP BW
  • importing BW objects into SAP HANA
  • Operational Data Provisioning  using sources – ECC , SLT, HANA VIEWS
  • LSA ++
  • Advanced DSO
  • Open ODS
  • Composite Provider
  • Hana transformation
  • ABAP managed Database procedure
  • SAP hana  near line storage
  • BW work spaces
  • Semantic partitioned objects
S4HANA
  • Embedded analytics using Abap CDS views
  • HANA live (VDM)
  • ABAP CDS views
  • Exposing ABAP CDS views as ODATA Services\

                                                            Why we are the Best ???

    Everyone claims to be the best, so why are we different?  We won’t beat about the bush here, so here is a writedown on why we are different.

    • All Tech video Courses recorded by realtime experts.
    • You Can check the demo videos before making a purchase.
    • Transparent, Secured, Instant Support.
    • Lifetime access to download the videos or Life to access to play the videos from cloud drive.
    • If any case any technical issues will happen while downloading or playing the videos from the drive, We will provide support through the mail (or) we will take your system remotely and help you remotely.
    • We configured secured payment gateways to this website Instamojo( for Indians ), Paypal ( for NRIs)
    • Once done the payment, we will be sent the videos link to your mail with a downloadable option.

    Terms And Conditions:

    We are giving download option to the videos, so that before making a purchase, if you have any questions, please email me to info@techvideospoint.com , we will reply to your email. Once payment is done, we can’t take the return( NO Return, NO Refund policy ).  

     

 

 

 

 

 

 

 

 

 

 

 

 
 
Contact Us