Contact Us
Company Name
Contact Person
Email Address or Phone
Detail

Course Code: IVCPC/HAD
Course Name: SAP HANA Development (HA300 & HA400)
Duration: 4 days
Course Fee: HKD 20,000
Location: Kowloon Tong
Course Details: SAP Course details

Goals

This course will prepare you to:

  • develop more concise and well-performing ABAP programs using new features of the ABAP programming language
  • develop and optimize ABAP applications that access data stored in the SAP HANA Database
  • Develop information models following SAP best practices for maximum performance and flexibility
  • Implement security and data access controls around SAP HANA data models
  • Get started with advanced data processing such as text, spatial, predictive and graph

Audience

  • Data Consultant / Manager
  • Database Administrator
  • Application Developer
  • System Analyst

Content

    Information Views
    • Connect Tables
    • Create Dimension and Cube Calculation Views
    Modeling Functions
    • Create Hierarchies
    • Create Calculated and Restricted Columns
    • Filter Data
    • Use Variables and Input Parameters
    • Implement Currency Conversion
    SAP HANA Studio Modeling Virtual Data Models in SAP HANA
    • Use SAP HANA Live
    • Overview of Virtual Data Models built with Core Data Services (CDS)
    Management and administration of Models
    • Work with Modeling Content
    • Create and Manage Projects
    • Overview of classical models migration to Web IDE
    Security in SAP HANA Modeling
    • Understand the Key Concepts of SAP HANA Security
    • Define Data Access Security
    • Define Roles
    Overview of Text, Spatial, Predictive and Graph Modeling Introduction
    • Understanding SAP HANA and how it impacts the ABAP development paradigm
    • Introduction to ABAP Development Tools (also known as ABAP in Eclipse)
    Taking ABAP to SAP HANA
    • Accessing SAP HANA as a Secondary Database
    • Tools to detect potential functional and performance issues when migrating to SAP HANA: Code Inspector and ABAP Test Cockpit, ABAP Trace and ABAP Profiler, SQL Trace
    • Tools to prioritize performance issues: SQL Monitor, SQL Performance Tuning Worklist
    • Performance Rules and Guidelines for ABAP in the context of SAP HANA
    SAP HANA Proxy Objects
    • Creating and using External Views
    • Database Procedure Proxies
    • HANA Transport Container
    Advanced Topics
    • Using SAP HANA Full Text Search in ABAP
    • Enabling input fields for type-ahead search
    • SAP List Viewer (ALV) for SAP HANA