What you'll learn:
Native HANA Development
Stored Procedures
ADBC (ABAP DATABASE Connectivity)
AMDP (ABAP Managed Database Procedures)
IDA (Integrated Data Access)
CDS (CORE DATA Services)
HANA Modeling
Requirements:
GOOD Knowledge in ABAP and OOPS ABAP is required
Description:
SAP HANA IntroductionFeatures and Architecture of HANA DatabaseABAP HANA IntroductionRole of ABAP consultants in SAP HANAData to Code Vs Code to Data ApproachIntroduction to HANA StudioNative HANA DevelopmentIntroduction to SQL and Database ObjectsRow Store Table Vs Column Store TableDatabase Tables – CRUD OperationsTransaction Control StatementsOrder By, Group By, Having, Where ClausesPrimary key and Foreign Key ConstraintsGlobal Vs Local Temporary TablesDefining and Managing TriggersSequencesSynonymsAltering Database ObjectsTable TypesProceduresFunctionsTemporary Internal TablesConditional and Looping statementsCursorsException HandlingViewsArraysJoinsIndexesStandard SQL FunctionsSTORED PROCEDURESCreating Stored ProceduresCreating Database Procedure ProxiesConsuming Stored Procedure from ABAP ReportsScalar FunctionsTable FunctionsABAP HANA(PRE-REQUISITES: ABAP PROGRAMMING)3ADBC (ABAP DATABASE Connectivity)Introduction to ADBC FrameworkConsuming Select Queries in ABAP Reports using ADBCParameter Binding in Queries using ADBCConsuming Stored Procedures using ADBCParameter Binding in Stored Procedures using ADBCAccessing DDL and DML statements using ADBCAMDP (ABAP Managed Database Procedures)Introduction to AMDP and ADTCreating AMDP'sConsuming AMDP's from ABAP ReportsAMDP Vs Stored ProceduresPassing Parameters to AMDPSelect-option functionality in AMDPCDS (CORE DATA Services)Introduction and Components of CDS ViewsCDS simple viewsConsuming CDS views from ABAP Reports and ALV IDA ReportsCDS views with parametersCDS Views with Functions and Arithmetic ExpressionsCDS Views with Joins and AssociationsCDS view Implemented in AMDP Table Functions
Who this course is for:
For ABAP Developers who want to upgrade their skills to ABAP On HANA
Homepage