SAP HANA Online Training

SAP HANA online training

SAP HANA is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE.[1][2] Its primary function as a database server is to store and retrieve data as requested by the applications. In addition, it performs advanced analytics (predictive analytics, spatial data processing, text analytics, text search, streaming analytics, graph data processing) and includes ETL capabilities as well as an application server.

Training Modes

Training Method- Instructor led Online Class

Duration- 60 hrs

Class Duration- 90 mins

Training Method- Instructor led Online Class

Duration- 60 hrs

Class Duration- 90 mins

SAP HANA

• About SAP • SAP Releases and Versions • What Is SAP ERP • SAP Modules
• Star Schema, Snow flake schema, Extended Star Schema • OLTP Vs OLAP • What EDW? • What is ETL? • RDBMS Vs IMDB
• Introduction to SAP HANA • Importance of SAP HANA IMDB • SAP HANA Applications overview • SAP HANA Evaluations • SAP HANA IMDB storage types • Row oriented storage • Column oriented storage • SAP HANA Compression & Portioning • SAP HANA Memory allocations, e.t.c
• Architecture of SAP HANA • Importance of In-memory database. • Join Engine • OLAP Engine • Calculation Engine
• SAP HANA Versions • SAP HANA Platform Edition • SAP HANA Enterprise Edition • SAP HANA Enterprise Extended Edition
• What is PERCEPTIVES • What is catalog • What is Content • What is schema & How to create Schema • How to create Package • How to create Attribute View • Importance of Text Join • How to create Hierarchies • How to create Analytical View • Importance of Data Foundation • Importance of Save & Activate, Data Preview • How to create Calculation View • What is Calculation View • Importance of Save, Attributes, Measures, Variables • Importance of Find Column • Importance of UNION/JOIN & PROJECTION • Importance of Decision Table • Importance of Analytical Privileges • Overview on SQL Script related to HANA
• General DWH concepts • Importance of Data Modeling • ER Model • Multi-Dimensional Model • Star Schema • Implementing Data models in BW • Implementing Data models in Hana • Levels of modeling
• Time Dimension Attribute View • Derived Attribute Views • Shared Attribute Views • Calculated columns • Hidden Attribute Views • Using Hierarchies • Implementing Leveled Hierarchies • Parent Child Hierarchies • Applying Filters
• Analytic Views • Multi-Dimensional Model with Analytic Views • Calculated Measures • Calculated Attributes • Restricted Measure • Concept Variables and Input Variables
• Graphical Calculation Views • Using Union, Join, Projection, Aggregation • Scripted Calculation Views • Approaching HANA modeling • Choosing Views for Information Model • Connecting tables • Using Inner Join, Left Outer Join, Right Outer Join • Full Outer Join, Text Join, Referential Join, Union.
• HANA SQL DDL • HANA SQL DML • HANA SQL DCL • SAP HANA Referential Join • Procedures • Creating Table Types • Calling Procedures
• Control Statements • CE_COLUMN_TABLE • CE_JOIN_VIEW • CE_OLAP_VIEW • CE_CALC_VIEW • ETC..
• Loading Data from Excel File to HANA Database Table • Loading Data from Flat File to HANA Database Table • Using Template Tables • Loading Data from Oracle Database to HANA Database • Loading Data from SAP ECC to HANA Database • Loading Data from SAP BW to HANA Database • Loading metadata from SAP ECC to HANA Database
• Data Services-One stop solution • Data Integration, Data Quality, Data Profiling • Metadata management and Text data analysis • Working with BODS • BODS Server • Repository • Job Server • Management Console • Data Services Designer • Creating Formats • Creating Data stores • Creating projects • Creating Batch jobs • Scheduling and monitoring Batch jobs • Creating Dataflows • Creating Connection to HANA DB
• SAP Landscape Replication server for HANA • Key benefits of SLT Replication server • Key benefits of Trigger-Based Approach • Architecture for SAP source Replication • Architecture for Non-SAP source Replication • Configuration and monitoring Dashboard for HANA(LTR) • Creating new Configuration for SAP Sources • Creating new Configuration for Non-SAP Sources • Result of Creating New Configuration • Launching Data provisioning UI in HANA studio • Start Load/Replication • Stop/Suspend Replication • Status Monitoring in HANA Studio • SLT based transformation Concept • Advanced Replication Settings • Change of table Structuring and Partitioning Filtering and Selective data replication
• HANA Privileges • Creating Users • Normal Users Vs Restricted Users • Creating Roles • Normal Run Time Roles Vs Design Time Roles • Assigning Privileges and Roles to Users
• User Creation • Role Creation • How to assign role to user • How to assign Analytical privileges to role
• Introduction to Transport Connection • Overview on SAP Transport Connection • HANA Transports
• System • SQL • Package • Granted Role

Other Popular Online Courses

SAP SCM Online Training

SAP SCM Training SAP SCM is a tool provided by SAP AG for managing the supply chain process of an organisation. SCM helps in planning, networking ...
Read More

SAP SD Online Training

SAP SD(Sales and Distribution) Online Training SAP SD (Sales and Distribution) is one of the worth noting modules of SAP ERP. It encloses all the information regarding customer ...
Read More

SAP QM Online Training

SAP MM Online Training The QM application component supports tasks associated with quality planning, quality inspection and quality control. In addition, it controls the creation of ...
Read More

SAP MM Online Training

SAP Materials Management(MM) Online Training SAP MM is one of the critical components in SAP ECC. Part of SAP ECC's logistics function, SAP MM plays a vital role ...
Read More

SAP HR Online Training

SAP HR Online TrainingSAP Human Capital Management (SAP HCM) is one of the key modules in SAP and is also called SAP Human Resource (HR). SAP ...
Read More

SAP HANA Online Training

SAP HANA online training SAP HANA is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE.[1][2] Its primary function as a database server is to store and retrieve data as requested ...
Read More

SAP FI/CO Online Training

SAP FI/CO Online Training SAP FICO is the Finance and Cost controlling module in SAP ERP where FI stands for Financial Accounting and CO stands for ...
Read More

SAP BW Online Training

SAP BW Online Training Because SAP Business Warehouse is unlike any other data warehousing application on the market. SAP BW runs on traditional RDBMS databases – ...
Read More

SAP BI Online Training

Business intelligence (BI) is an application used for giving meaning to raw data that an organization has. The raw data is cleansed, stored and applied with ...
Read More

SAP Basis Online Training

SAP Basis Online Training SAP Basis refers to the administration of SAP system that includes activities like installation and configuration, load balancing, and performance of SAP ...
Read More