Course Content:

1.Introduction to SAP HANA & S/4HANA

2.Overview

• Traditional Software System
• Path to In-memory Database System
• Transactional Processing and Analytical Processing: OLTP and OLAP

3.HANA Overview and Features

• Row Store and Column Store
• Compression
• Partitioning
• No Aggregate Tables
• Insert only on Delta

4.Development tools for HANA Development

• HANA Studio
• Web IDE – Web Integrated Development Environment
• Eclipse Editor

5.Installing required Components in HANA Studio for HANA Development

6.Perspectives Overview

7.HANA Admin Console Perspective

• Adding HANA systems to the HANA Studio
• Catalog Folder – Schema
• Content Folder- Package
• Standard Schema list

8.HANA Modeling Perspective

9.ABAP Perspective

Adding ABAP system

10.HANA Development Perspective

11.SQL Basics and Script Programming

12.SQL Commands

• DDL – Data Definition Language Statements
  • CREATE Statement
  • ALTER Statement
  • DROP Statement
  • RENAME Statement

• DML – Data Manipulation Language Statements
  • SELECT Statement
  • INSERT Statement
  • UPDATE Statement
  • DELETE Statement

13.Primary Database artifacts

• Tables
• Views

14.SQL Script Programming

• Procedures
  • Read Only Procedures
  • Update Procedures
• Functions
  • Scalar Functions
  • Table Functions
• Additional Topics
  • Indexes
  • Sequences
  • Triggers
  • Database Transaction
  • COMMIT Statement
  • ROLLBACK Statement

15.Data Modeling

16.Calculation Views

• Runtime artifacts: Column View, Table Type and Database Procedure
• Functions
• Calling the Procedure
• Category
• Standard Calculation View
• Graphical Calculation Views: Dimension, Cube and Space
• Script Based Calculation View
• Time Calculation Views: Gregorian and Fiscal

17.ABAP on S/4HANA 1709

• Object Oriented Programming Overview
• Important ABAP 7.4 and 7.5 Features
• ABAP CDS (Core Data Services)
  • Parameters
  • Joins
  • Associations
  • Table Functions
  • Roles
  • Generating OData Service from CDS Views
  • Create FIORI apps using Smart templates
•  AMDPs(ABAP Managed Database Procedures)
• HANA ADBC
• Calling Native SQL Statements
• Calling Table Functions
• Calling Procedures

18.HANA SALV IDA

• Consume Tables
• Set field Catalog
• Set display Options
• Handle events
• Consume CDS views

19.BOPF Overview

20.HANA CDS

• Create Elementary Types, Structure Types and Table types
• Create entities
• Create views
• Create Associations