Loading...
Govt. Registered | ISO 9001 : 2015 Certified Institute | A National Programme of Information Technology Education & Development | Skill India Initiative | For Scholarship Call (+91) 87778 30039 | For Study Loan Call (+91) 82829 01694

SAP HANA Course

Course Detail

SAP HANA

Diploma in Web Design

Oxford Global Academy of Excellence, Kolkata offers placement focused best SAP HANA training in Kolkata. We have a specialized SAP HANA training course that includes both basic and advance level program training. As soon as you complete the SAP HANA training course, you will get direct placement in various MNC firms in Kolkata. All our expert professionals have years of experience in training candidates who are willing to gain project knowledge in SAP HANA. Depending upon the career objectives of the candidates, we have designed our SAP HANA training course content and syllabus.Our SAP HANA training course in Kolkata includes SAP HANA Introduction and Architecture, SAP HANA Appliance Model, SAP HANA Studio Features, Reporting on HANA with BI 4.0, Advanced Data Modeling with SAP HANA real time projects and also Placement training in Kolkata.Our SAP HANA training centers are well equipped with excellent infrastructure and lab facilities that further make things easier for each one of our students in Kolkata. Our course fee is definitely value for money and we offer day time training, weekend training and also evening and fast track classes.

We have the best courses for you!

Enroll today and learn something new.

Syllabus

Module 1
SAP HANA INTRODUCTION AND ARCHITECTURE:
  • SAP HANA Overview
  • SAP In-Memory Computing Overview
  • SAP HANA Features
  • Look and feel of SAP HANA
  • SAP HANA Architecture
  • SAP HANA Landscape
  • Structure of SAP in-memory Computing studio
  • Row store and column store Architecture
  • Multi Version Currency Control ( MVCC )
  • Persistence Layer in In-memory Computing Engine
  • Back up &Recovery
  • High-Availability
  • Distributed System
  • Data Provisioning options in SAP HANA
  • Reporting options on SAP HANA
  • Security options in HANA
  • SAP HANA Appliance Model
  • How SAP HANA Appliance is delivered
  • Sizing Considerations
  • SAP HANA – Licensing Options
  • SAP HANA Project Implementation
  • Overview: Key Activities
  • Key Roles
  • Key Points to keep in mind
  • Administration
Module 2
BASIC MODELING:
  • Modeling Overview
  • Terminology
  • SAP HANA Studio Features
  • Information Modeler Overview
  • Installation and Configuration of HANA Studio
  • Prerequisites for Modeling
  • Modeling Considerations
  • Levels of Modeling
  • Attribute Views
  • Analytic Views
  • Modeling Considerations
  • Joins: Different types and when to use what.
  • Where Class Vs Constraint Filters
  • HANA Studio Preview(use with Caution)
  • Impact of Query Execution
  • Demo
  • Modeling Suggestions
  • Troubleshooting Modeling Issues
  • Export and Import Models
Module 3
REPORTING ON HANA WITH BI 4.0:
  • HANA Reporting Layer & Connectivity Options
  • Reporting on HANA Clients
  • Reporting on HANA Open Interfaces
  • Prerequisites for reporting on SAP HANA
  • IMDB client installation
  • Setting up new connection
  • SAP Business Objects BI4.0:Overview & tool comparison
  • Analytical Reporting on HANA
  • Relational Reporting on HANA
  • Reporting on HANA Demo Included
  • Native Excel Interface via ODBO
  • SAP Business Object Analysis(Office Edition)
  • SAP Business Object Explorer
  • Semantic Layer Approach
  • IDT Vs Universe Designer
  • SAP BOBJ Web I
  • SAP BOBJ Xcelsius
  • SAP Crystal Reports
  • Enterprise Vs 2011
  • Front end tool reporting considerations on top of HANA
  • Troubleshooting common reporting issues
Module 4
ADVANCED DATA MODELING WITH SQL SCRIPT:
  • Modeling Overview
  • Calculation View :Overview & Types
  • SQL Script :Motivation
  • SQL Script: Overview
  • SQL Script Processing
  • Data Type Extensions
  • Scalar Data type
  • Table type
  • Functional Extension
  • Concept
  • Procedure
  • Procedure Calls
  • Implementing Functional logic
  • Operators
  • SQL Script/Built in Function
  • Debugging and troubleshooting SQL Script
  • Restrictions for SQL Statement
Module 5
DATA PROVISIONING: DATA SERVICES
  • Data Provisioning :Overview
  • Data Provision Options
  • Trigger Based Replication
  • ETL-Based Replication
  • Log-Based Replication
  • SAP Business Objects Data Services 4.0 and HANA
  • ODP enabled Extractor Support in Data Services 4.0
  • HANA and Data Service Process flow for SAP and non-SAP data
  • How it works for SAP System
  • How it works for Non-SAP System
  • Advanced Data Service options
  • Column tables creation
  • Bulk loader options & config
  • Bulk extracting options & config
  • Log based replication overview
  • Technical system landscape
  • User administration
  • Authorization
  • Installing log based replication
  • Updating the SAP host agent on source system
  • Installing Sybase components
  • Deploying the SAP HANA load controller and related components
  • Configuring log based replication
  • Configure SAP HANA load controller on SAP HANA system
  • Initializing replication using SAP HANA system
  • Initializing replication using SAP HANA load controller
Module 6
DATA PROVISIONING: SAP LANDSCAPE TRANSFORMATION (SLT):
  • Data provisioning overview
  • SAP landscape transformation set-up
  • Options for SLT landscape installation
  • Post installation stem
  • Concept of SLT replication
  • Architecture and key building block
  • Technical requirement and system set-up information for LT replication server
  • Key benefits of LT replicating server
  • Transformational capabilities
  • Operations
  • Security and user management in HANA
  • Creation of users
  • Creation of roles
  • Assignment privileges to roles
  • Assignment of users to roles

Career Opportunities

  • SAP consultant
  • SAP Hana architect
  • SAP project manager



Entry Qualification

  • Candidates will be admitted on the basis of interviews and / or group discussions.
  • 20% of the total seats will be reserved for SC, ST and OBC candidates.If the reserved seats are not filled within the specified period, the vacant seats will be offered to the general candidates.

Course Features

Instructor
Industry Experienced Trainer
Rating
4.9 (Google Review)
Study Mode
Offline & Online
Duration
6 month
Language
English, Bengali, Hindi
100% Job Assistance
Yes
Internship
Free & Paid
Course Price
Click to Know

Our Students Testimonials

Oxford Global Academy of Excellence Courses

MD Kashid Hossain

   I am MD Kasid Hossain. I am a student of Oxford Global Academy of Excellence, Kolkata. Here I am doing Spoken English class. Oxford Global Academy of Excellence is a very advantage platform by spoken English, computer course and more. There sirs, madams are very Helpful. All time they Support and guide us. I always enjoy my classes.