SAP HANA (In-Memory Database & Modeling)
SAP HANA is the column-oriented in-memory database platform that powers modern SAP S/4HANA systems. This course covers the architecture of HANA, table partitioning, data loading using SDI/SDQ, model creation (Attribute, Analytic, Calculation views), and database administration tasks.
Program Highlights
Target Audience
Database Developers, Business Intelligence (BI) Analysts, ABAP Developers, and BASIS Consultants.
Prerequisites
Good understanding of standard SQL commands and relational database designs.
Job Roles & Careers
SAP HANA Developer, HANA DB Modeler, Database Consultant.
Salary Outlook
₹6 LPA - ₹14 LPA
Detailed Course Syllabus
- In-Memory Database concepts: Column vs Row storage
- SAP HANA Memory structures (Index Server, Name Server, Preprocessor)
- Multi-tenant Database Containers (MDC) architecture
- Creating Schemas, Tables, and Views using SQL Console
- Table partitioning techniques (Hash, Range, Round-Robin, Multi-level)
- Database constraints and indexing optimization
- Creating Attribute Views and Analytic Views (for legacy reference)
- Building Calculation Views (Graphical & Scripted)
- Implementing Joins, Projections, Unions, and Aggregations
- Defining Input Parameters and Variables
- Introduction to SQLScript (procedures and table functions)
- Writing stored procedures with parameters
- Debugging procedures in HANA Studio/Web IDE
- Data replication using SAP Landscape Transformation (SLT)
- Smart Data Integration (SDI) and Smart Data Quality (SDQ) basics
- Backup/Recovery, user administration, and privileges
Batches & Timings
Weekday Batch
Monday - Friday (6:30 PM - 8:30 PM)
Weekend Batch
Saturday & Sunday (12:00 PM - 4:00 PM)
Career Benefits & Outcomes
Access to SAP HANA Studio and Web IDE console environment
Configuring real calculation views and advanced scripting
Data replication scenarios using SLT and Smart Data Integration
Practical tuning of query performance for massive datasets
Mock tests for SAP HANA Certification
Quick Summary
- Duration: 2.5 Months
- Format: Classroom & Online
- Placement Support: 100% Assistance
- Batch: Weekday / Weekend
- Live Projects: HANA Projects
Quick Enquiry
Have questions? Ask our academic counselors.