SAP HANA or High-Performance Analytic Appliance is an In-Memory, column-oriented relational database which combines with a revolutionary platform and is used for gathering real-time insights and deploying and developing real-time applications. It is a fundamentally different database engine and is ten times faster as compared to a traditional database. Furthermore, it is also combined with a pre-tuned server, networking hardware, and storage.
Module 1: Introduction to SAP HANA
Topic 1: Introduction to DBMS and RDBMS
Topic 2: History of RDBMS
Topic 3: Basic concepts RAM, SSD and Hard Disk
Topic 4: What is In-Memory Database?
Topic 5: What is SAP HANA?
Topic 6: How the difference with others database
Topic 7: HANA Evaluation
Topic 8: Why HANA Platform
Topic 9: What Hana cannot do
Topic 10: HANA Hardware size and Editions
Topic 11: How to install hana server and Studio
Topic 12: HANA Client JDBC and ODBC
Module 2: Database objects
Topic 1: Hana studio
Topic 2: HANA Schema
Topic 3: Database Objects (Tables, Views, Synonyms, Sequences, procedures and Indexing)
Topic 4: Materialized Views
Topic 5: Introduction to SQL (DDL, DML, DCL and TCL)
Topic 6: Row store and column store
Topic 7: Compression in Hana
Topic 8: Partitions on column store
Topic 9: How the HANA Column with good write capability
Topic 10: All Joins
Module 3: Multidimensional Modeling in SAP HANA
Topic 1: Multi-dimensional models
Topic 2: Attribute View
Topic 3: Analytic view
Topic 4: Calculation View
Topic 5: HANA Script
Topic 6: Star join
Topic 7: Hierarchies
Topic 8: Filter Operations Variables and Currency conversion
Topic 9: Fuzzy search
Topic 10: Decision Tables
Topic 11: Business Function Library
Topic 12: HANA Engines
Topic 13: HANA Security
Topic 14: HANA Transport
Topic 15: Backup and Recovery
Topic 16: Native hana apps development
Topic 17: HANA Architecture
Topic 18: Persistent Layer
Topic 19: Performance check tools
Topic 20: Dynamic tiring
Topic 21: Monitoring HANA
Module 4: BO Reporting
Topic 1: SAP Lumira
Topic 2: Design studio
Topic 3: Explorer
Topic 4: Native hana and Application powered by hana
Module 5: ABAP HANA
Topic 1: ABAP Dictionary Enhancements
Topic 2: Data Type Systems: ABAP & SAP HANA
Topic 3: Open SQL & ABAP Dictionary views
Topic 4: ABAP Managed Database Procedures
Topic 5: Native SQL
Topic 6: Debugging
Topic 7: ABAP CDS View
Topic 8: ABAP Manages Database Procedures in SAP BW powered by SAP HANA
Topic 9: Code Push down concepts using ADT
Module 6: Additional Topics
Topic 1: SAP SECC on HANA
Topic 2: HANA Live
Topic 3: Compare BW on HANA
Topic 4: Introduction to UI5 and S/4 HANA
