Module 1: Introduction to SAP HANA & S/4HANA

Module 2: Overview

Topic 1: Traditional Software System

Topic 2: Path to In-memory Database System

Topic 3: Transactional Processing and Analytical Processing: OLTP and OLAP

Module 3: HANA Overview and Features

Topic 1: Row Store and Column Store

Topic 2: Compression

Topic 3: Partitioning

Topic 4: No Aggregate Tables

Topic 5: Insert only on Delta

Module 4: Development tools for HANA Development

Topic 1: HANA Studio

Topic 2: Web IDE – Web Integrated Development Environment

Topic 3: Eclipse Editor

Module 5: Installing required Components in HANA Studio for HANA Developments

Module 6: Perspectives Overview

Module 7: HANA Admin Console Perspective

Topic 1: Adding HANA systems to the HANA Studio

Topic 2: Catalog Folder - Schema

Topic 3: Content Folder- Package

Module 8: HANA Modeling Perspective

Module 9: ABAP Perspective

Topic 1: Adding ABAP system

Module 10: HANA Development Perspective

Module 11: SQL Basics and Script Programming

Module 12: SQL Commands

Topic 1: DDL – Data Definition Language Statements

Topic 2: CREATE Statement

Topic 3: ALTER Statement

Topic 4: DROP Statement

Topic 5: RENAME Statement

Topic 6: DML – Data Manipulation Language Statements

Topic 7: SELECT Statement

Topic 8: INSERT Statement

Topic 9: UPDATE Statement

Topic 10: DELETE Statement

Module 13: Primary Database artifacts

Topic 1: Tables

Topic 2: Views

Module 14: SQL Script Programming

Topic 1: Procedures

Topic 2: Read Only Procedures

Topic 3: Update Procedures

Topic 4: Functions

Topic 5: Scalar Functions

Topic 6: Table Functions

Topic 7: Additional Topics

Topic 8: Indexes

Topic 9: Sequences

Topic 10: Triggers

Topic 11: Database Transaction

Topic 12: COMMIT Statement

Topic 13: ROLLBACK Statement

Module 15: Data Modeling

Module 16: Calculation Views

Topic 1: Runtime artifacts: Column View, Table Type and Database Procedure

Topic 2: Functions

Topic 3: Calling the Procedure

Topic 4: Category

Topic 5: Standard Calculation View

Topic 6: Graphical Calculation Views: Dimension, Cube and Space

Topic 7: Script Based Calculation View

Topic 8: Time Calculation Views: Gregorian and Fiscal

Module 17: ABAP on S/4HANA 1709

Topic 1: Object Oriented Programming Overview

Topic 2: Important ABAP 7.4 and 7.5 Features

Topic 3: ABAP CDS (Core Data Services)

Topic 4: Parameters

Topic 5: Joins

Topic 6: Associations

Topic 7: Table Functions

Topic 8: Roles

Topic 9: Generating OData Service from CDS Views

Topic 10: Create FIORI apps using Smart templates

Topic 11: AMDPs (ABAP Managed Database Procedures)

Topic 12: HANA ADBC

Topic 13: Calling Native SQL Statements

Topic 14: Calling Table Functions

Topic 15: Calling Procedures

Module 18: HANA SALV IDA

Topic 1: Consume Tables

Topic 2: Set field Catalog

Topic 3: Set display Options

Topic 4: Handle events

Topic 5: Consume CDS views

Module 19: BOPF Overview

Module 20: HANA CDS

Topic 1: Create Elementary Types, Structure Types and Table types

Topic 2: Create entities

Topic 3: Create views

Topic 4: Create Associations