This SAP HANA training from IQ Intelligence will ensure you get a good grasp of SAP HANA fundamentals, learn and deploy real-time analytics. HANA is an on-premise application that is used for gathering real-time insights. In this SAP HANA training, you will learn about SAP HANA Studio, Modeling, Security features and various other aspects. You will understand why SAP HANA is a fundamentally different database engine upon completion of this SAP HANA course.
Why should you go for SAP HANA Online Training Course?
The basic database product, SAP HANA, currently has more than 6,400 customers. A SAP HANA consultant in the United States can earn $115,000 – indeed.com.
SAP HANA is one of those platforms that will find much demand form enterprises around the world due to its result-oriented approach to getting work done. This SAP HANA training certification course gives you hands-on experience and knowledge in one of the most sought-after technologies in the cloud, Big Data and analytics environment. This SAP HANA training is your road to getting high paying jobs in the technology industry.
- There are no prerequisites for taking up this SAP HANA course. Basis knowledge of SQL can help.
SAP HANA Overview
- Top 10 Reasons Customers Choose SAP HANA
- SAP HANA Choice of deployment
- SAP HANA Landscape
- SAP HANA Architecture Overview
- Advance Information on SAP HANA Architecture
- Row Store Vs Column Store
- SAP HANA – SQL Concepts
- SAP HANA – SQL Joins Inner Vs Outer Vs Self
SAP HANA Modeling
- Look & Feel
- Adding system to HANA Studio
- System Monitor
- Administration Console
- Creating a New Schema
- Create Table using HANA Studio
- Create Table using SQL Editor
- Table SQL Statements
- Creating a Database View
- Open Definition Vs Open Content Vs Open Data Preview
- Information Modeling Introduction
- Creating a Package & Sub package
Modelling Views
- Analytic View
- Attribute View
- Calculated Column View
- Input Parameter/Variable
- Calculation View Graphical
- Analytic Privilege
- Backup Mechanism
- Import & Export Delivery Unit
- Create Hierarchies
- Create Calculated and Restricted Columns
- Filter Data
- Use Variables and Input Parameters
- Implement Currency Conversion
- Create Decision Tables
- Introduce SQL and SQLScript
- Create Table Functions and Procedures
- Use the SQL Debug Tools
SAP HANA Data Provisioning
- Data Provisioning Overview
- Loading CSV Data
- SLT(SAP Landscape Transformation) Method
- ETL tool (BODS) Method
- DXC(Direct Extractor Connection) Method
- CTL (Extension) Method
- SAP HANA MDX (Multi-Dimensional Expressions) method
- Smart Data Access
SAP HANA Security
- Security Overview
- User Administration and Management
- Authentications
- Authentication methods
- License Management
- Auditing
SAP HANA Monitoring
- Monitoring and Alerting
- Persistent Layer
- Backup and Recovery
- High Availability
- Log Configuration
SAP HANA Reporting
- Introduction to Business Objects 4.2 SAP HANA Reporting Views
- IDT (Information Design Tool)
- UDT (Universe Design Tool)
- Web Intelligence
- SAP BI LaunchPad
- Crystal Reports
- SAP Lumaira
- Excel Integration
Advanced-Data Modeling With SQL Script
- Modelling 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
- Developers Best practices
- SAP HANA Certification
- Interview Questions and Answers
- Project-based Question and Answers
- Real-time Project Issues and Fixes
- Effective Resume
Projects
- ALL Outstanding FX Deals
- Daily Income Report Trading
- Foreign Exchange Subsystem
- Full Precision Revaluation
- Fx Cash Management
- Fx Back Office Deals Transactions
- Unrealised profit and loss