SAP HANA

SAP HANA DEVELOPMENT COURSE CONTENT

1. Introduction to SAP HANA

2. How different from other Data bases?

3. SAP HANA In-Memory Strategy

4. Why is SAP HANA?

5. SAP HANA Architecture - Understanding about Index Server & Engines

6. SAP HANA Use Cases

7. Introducing SAP HANA Studio

8. SAP HANA Database Concepts

8.1 Schema

8.2 Database Tables

– Row Store & Column Store
- Column Store Concepts

8.3 Database Views

8.4 Synonyms

8.5 Triggers

8.6 Sequences

8.7 Table-UDF(User Defined Functions)

8.8 Introduction to Stored Procedures

8.9 Introduction to Table Types

8.10 Column Views

9. Basic SQL

10. SQL Scripts, CE Functions

11. Stored Procedures

11.1 Simple Stored Procedures

11.2 Looping Statements

11.3 Conditional Statements

12. SAP HANA Modeling

– Different types of Views
- Variables in HANA
- Export / Import Models

13. Data Provisioning

SLT BODS SDA

14. Flat File Upload to SAP HANA

15. Reporting

– HANA Reporting Layer
- Creating Universe
- Web Intelligence
- Design Studio
- BO Analysis for Office

Installation

  • Introduction SAP HANA Lifecycle Management Tools
  • Advanced installation options
  • SAP HANA Studio installation
  • SHINE – SAP HANA Interactive Education
  • Performing a Distributed System Installation

Post Installation

  • Post-Installation Steps
  • Updating SAP HANA

Architecture and Scenarios

  • SAP HANA Memory Management and Data Persistence
  • Software Packaging
  • SAP HANA Roadmap and Scenarios
  • Deployment Options

Admin Tools for SAP HANA

  • SAP HANA studio for administrator
  • DBA Cockpit