Learn HANA in 1 Day

SAP Hana is popular due to its large main memories and massive parallel job processing capabilities. It makes SAP Hana real fast. The motive of this book is to develop a good understanding of how SAP Hana is used. The book doesn't need any experience with SAP HANA or software development. It’s a self-learning guide that even beginners can use. Everything about SAP HANA is explained like architecture, modeling, reporting, SQL script, and so on.

This book is full of information, hands-on and real life project experience learning.  In this edition, you will identify various components of SAP HANA and its working process.  Though the book size is small, it tried to justify almost all important topics of SAP HANA with examples and images. These includes SLT, the connection between SAP system and HANA, Data services, etc. You will also learn how to use SQL script in HANA.

By the end of this book, you will be able to integrate SAP HANA pretty much with any platform. Over a time you can use this edition as a handbook and harness your SAP Hana skills. So all and above this edition will save a lot of your expenses spend behind other courses and learning resources.

Table Content

Chapter 1: Introduction

1. Introduction SAP HANA
2. Why to choose SAP HANA?
3. SAP HANA In-Memory Strategy
4. SAP HANA Advantages
5. SAP HANA Compare to BWA (Business Warehouse Accelerator)

Chapter 2: Hana Architecture

1. SAP HANA Architecture
2. SAP HANA Landscape
3. SAP HANA Sizing

Chapter 3: SAP HANA Studio

1. Pre-Requisite for SAP HANA Studio
2. Supported Platform
3. Download & Install SAP HANA Studio
4. Add System in SAP HANA Studio
5. Work With SAP HANA Studio

Chapter 4: SQL Script, Data Type, Trigger, Sequence, Operator, Function, Expression, Identifiers

1. What is SAP HANA SQL
2. SAP HANA Identifiers
3. SAP HANA Data Type
4. SAP HANA Operator
5. SAP HANA SQL FUNCTIONS
6. SAP HANA SQL EXPRESSIONS
7. SAP HANA SQL Stored Procedure
8. SAP HANA Create Sequence
9. SAP HANA Create Trigger

Chapter 5: Data Provisioning

1. Overview of Replication Technology
2. SLT (SAP Landscape Transformation Replication Server)
3. SAP DS (SAP DATA Services)
4. SAP HANA Direct Extractor Connection (DXC)
5. Flat file Upload to SAP HANA

Chapter 6: Modeling

1. SAP HANA Modelling Overview
2. Join Method in SAP HANA
3. SAP HANA Best Practices for Creating Information Models
4. SAP HANA Attribute View
5. SAP HANA Analytic View
6. SAP HANA Calculation View
7. SAP HANA Analytic Privileges
8. SAP HANA Information Composer
9. SAP HANA Import and Export
10. SAP HANA Performance Optimization Technique

Chapter 7: Security

1. SAP HANA Security Overview
2. SAP HANA Authentication
3. SAP HANA Authorization
4. SAP HANA User and Role Administration
5. SAP HANA License Management
6. SAP HANA Auditing

Chapter 8: Reporting

1. Reporting In SAP BI (Business Intelligence) Overview
2. Reporting In Webi of SAP Business Objects (BO) on HANA
3. Reporting In Crystal Report
4. Reporting In SAP Lumira
5. Reporting In Microsoft Excel