Sap hana online training
Hello, We are from O2education, Online software Education and training team.
We are one of the best rated software training team, who are offering online software training from India.
We offer you efficient yet affordable online software training with quality as the main objective.
Our online education experts' team assists you in every phase of your online education.
We are the pioneers in offering practical industry-oriented online software training that makes you capable of handling real time situations by applying the concepts which you learn through our programming languages.
Initially, we make you understand about the software course contents and we will counsel you how the software course will be will be able to apply your practical skills in a real time environment.
for all major Software Technologies.
.
About our Faculty:
- We have Certified Instructors who have real time experience plus good orientation in Online Training.
We offer you:
- Interactive Learning at Learners convenience - Industry savvy Trainers - learn right from your place - 24/7 Technical Support - Highly affordable fee Satish@o2education.
com 1 Introduction An in-memory database is a database management system that primarily relies on main memory for computer data storage.
SAP HANA is SAP AGs implementation of in-memory database technology.
Following are the components related to SAP HANA , SAP HANA DB refers to the database technology itself, , SAP HANA Appliance refers to HANA DB as delivered on partner certified hardware as an appliance.
It also includes the modeling tools from HANA Studio as well replication and data transformation tools to move data into HANA DB, History:
HANA is the synthesis of three separate products TREX, P Time and MaxDB.
project at SAP in collaboration with DFKI.
TREX became a standard component in SAP NetWeaver in 2000.
In-memory attributes were added in 2002 and columnar data store was added in 2003, both as ways to enhance performance.
2.
In 2005 SAP acquired Menlo Park based Transact in Memory, Inc.
With the acquisition came P Time, an in-memory light-weight online transaction processing (OLTP) RDBMS technology with a row-based data store.
3.
MaxDB (formerly SAP DB), a 2003 collaboration between MySQL AB and SAP, was features like backup.
What is HANA? HANA (High performance Analytical Appliance) is a new In-Memory data management appliance released by SAP which is more of separate plug-in (Software & Hardware) for faster analytical activities.
This application allows processing of massive quantities of real time data in and pre-install the SAP in-memory solution on that hardware.
2 Why HANA ? 1.
While HANA has been called variously an acronym for HAsso's New Architecture (a reference to SAP founder Hasso Plattner) 2.
High Performance ANalytic Appliance.
3.
HANA is a name not an acronym.
Why SAP HANA (SAP In-Memory Appliance)? But why SAP HANA and not any of the other SAP modules such FI, MM, PP, CRM, etc? SAP Systems but also facilitates the Data Modeling also.
been engulfed in the field for a while I am convinced that BI Solutions, by nature, brings all the various functional modules together.
SAP HANA serves as a central repository where business owners pull information if they are interested in seeing all aspects of a project.
This ability is a sure sign that this will continue to be a highly lucrative area to be in.
.
Talk to recruiters and get a real sense of what is going on in your environment.
What are your interests? What is your background? What are your career goals? 3 Course Content SAP HANA 1.
0 SPS5 In-Memory Computing, Big Data and SAP HANA Introduction to In-Memory Computing and Big Data In-Memory Computing and Analytics Big Data Introduction Introduction to SAP HANA SAP HANA as in In-Memory Computing Solution SAP HANA as an Enabler of Big Data Solutions SAP HANA Capabilities SAP HANA Database Concepts.
.
Impact of Modern Hardware on Database System Architecture.
Architecture Hana Engine Overview IMCE surroundings Different HANA Engine Types Row Store Column Store Persistency Layer Business Impact of new architecture Columnar and Row-Based Data Storage Advantages of Columnar Tables Data Modeling with SAP HANA Studio SAP HANA Studio Overview and Terminology Getting Started with SAP HANA Information Modeler Adding a System Opening Perspectives Using Quick Launch Creating a Package Example Scenario Building Attribute Views Creating an Attribute View Defining Table Joins 4 Defining Output Checking, Saving, and Activating Views Creating the Time Attribute View Building Analytic Views Creating an Analytic View Copying an Analytic View Building Calculation Views Using the Graphical Method Implement information models in SAP HANA Advanced Concepts in SAP HANA Studio Derived Attribute Views Calculated Attributes Restricted and Calculated Measures Filter and Variable Operations Filters Variables and Input Parameters Currency Conversion Creating a Leveled Hierarchy Creating a Parent-Child Hierarchy Processing Content Objects Previewing Data of Content Objects Comparing Versions of Content Objects Viewing Version History of Content Objects Switching Ownership of Inactive Objects Generating Object Documentation Enabling Multilanguage Support for Objects Checking Model References Viewing the Job Log Personalizing Studio Versioning Checking Model References Customizing Perspectives HANA SQL Introduction to SQL script and script based ca lculation views 5 Using SQL & Using SQLScript Using SAP HANA Studio to Execute SQL and SQLScript Statements Table Type Definition CREATE TYPE DROP TYPE INSERT, UPDATE, DELETE statements Data definition and access control Data Types CREATE, ALTER, DROP Renaming Columns Functions & Expressions Procedures introduction Writing procedures Procedure Calls Data Provisioning Choosing a Data Provisioning Method Option 1:
Trigger-Based Replication:
SAP Landscape Transformation How SLT Works SLT Configuration SLT Administration (Start, Replicate, Stop, Suspend,Resume) Extended Features Option 2:
ETL-Based Replication:
SAP Data Services Preparing SAP HANA to Receive Data from SAP Data Services Loading Data Option 3:
Log-Based Replication:
Sybase Replication Server and Load Controller Option 4:
Direct Extractor Connection DXC Technology 6 Reporting SAP HANA and the SAP BusinessObjects BI Platform Overview of the SAP Business Objects Tools SAP Business Objects Dashboards (Xcelsius).
SAP Business Objects Web Intelligence SAP Business Objects Explorer SAP Business Objects Analysis SAP Business Objects Design Studio SAP Crystal Reports Connecting SAP Business Objects BI Tools to SAP HANA Universes with Open and Java Database Connections (ODBC/JDBC) Connecting to Excel with Open Database Objects (ODO) and MDX BICS Connections Connectivity Summary User Management & Administrator Security Creating Users Creating Roles Privileges User Administration 7 Hot Topics BW 7.
3 powered by HANA Overview Business Suite on HANA Overview HANA Innovations Information Composer Exercises CASE STUDY - COPA Scenario Steps:
Provisioning the relevant tables Creating attribute view, analytic view & calculation views for COPA Model Once you make the decision on SAP HANA, join us and lets have fun!.
Estimated Salary: $20 to $28 per hour based on qualifications.
We are one of the best rated software training team, who are offering online software training from India.
We offer you efficient yet affordable online software training with quality as the main objective.
Our online education experts' team assists you in every phase of your online education.
We are the pioneers in offering practical industry-oriented online software training that makes you capable of handling real time situations by applying the concepts which you learn through our programming languages.
Initially, we make you understand about the software course contents and we will counsel you how the software course will be will be able to apply your practical skills in a real time environment.
for all major Software Technologies.
.
About our Faculty:
- We have Certified Instructors who have real time experience plus good orientation in Online Training.
We offer you:
- Interactive Learning at Learners convenience - Industry savvy Trainers - learn right from your place - 24/7 Technical Support - Highly affordable fee Satish@o2education.
com 1 Introduction An in-memory database is a database management system that primarily relies on main memory for computer data storage.
SAP HANA is SAP AGs implementation of in-memory database technology.
Following are the components related to SAP HANA , SAP HANA DB refers to the database technology itself, , SAP HANA Appliance refers to HANA DB as delivered on partner certified hardware as an appliance.
It also includes the modeling tools from HANA Studio as well replication and data transformation tools to move data into HANA DB, History:
HANA is the synthesis of three separate products TREX, P Time and MaxDB.
project at SAP in collaboration with DFKI.
TREX became a standard component in SAP NetWeaver in 2000.
In-memory attributes were added in 2002 and columnar data store was added in 2003, both as ways to enhance performance.
2.
In 2005 SAP acquired Menlo Park based Transact in Memory, Inc.
With the acquisition came P Time, an in-memory light-weight online transaction processing (OLTP) RDBMS technology with a row-based data store.
3.
MaxDB (formerly SAP DB), a 2003 collaboration between MySQL AB and SAP, was features like backup.
What is HANA? HANA (High performance Analytical Appliance) is a new In-Memory data management appliance released by SAP which is more of separate plug-in (Software & Hardware) for faster analytical activities.
This application allows processing of massive quantities of real time data in and pre-install the SAP in-memory solution on that hardware.
2 Why HANA ? 1.
While HANA has been called variously an acronym for HAsso's New Architecture (a reference to SAP founder Hasso Plattner) 2.
High Performance ANalytic Appliance.
3.
HANA is a name not an acronym.
Why SAP HANA (SAP In-Memory Appliance)? But why SAP HANA and not any of the other SAP modules such FI, MM, PP, CRM, etc? SAP Systems but also facilitates the Data Modeling also.
been engulfed in the field for a while I am convinced that BI Solutions, by nature, brings all the various functional modules together.
SAP HANA serves as a central repository where business owners pull information if they are interested in seeing all aspects of a project.
This ability is a sure sign that this will continue to be a highly lucrative area to be in.
.
Talk to recruiters and get a real sense of what is going on in your environment.
What are your interests? What is your background? What are your career goals? 3 Course Content SAP HANA 1.
0 SPS5 In-Memory Computing, Big Data and SAP HANA Introduction to In-Memory Computing and Big Data In-Memory Computing and Analytics Big Data Introduction Introduction to SAP HANA SAP HANA as in In-Memory Computing Solution SAP HANA as an Enabler of Big Data Solutions SAP HANA Capabilities SAP HANA Database Concepts.
.
Impact of Modern Hardware on Database System Architecture.
Architecture Hana Engine Overview IMCE surroundings Different HANA Engine Types Row Store Column Store Persistency Layer Business Impact of new architecture Columnar and Row-Based Data Storage Advantages of Columnar Tables Data Modeling with SAP HANA Studio SAP HANA Studio Overview and Terminology Getting Started with SAP HANA Information Modeler Adding a System Opening Perspectives Using Quick Launch Creating a Package Example Scenario Building Attribute Views Creating an Attribute View Defining Table Joins 4 Defining Output Checking, Saving, and Activating Views Creating the Time Attribute View Building Analytic Views Creating an Analytic View Copying an Analytic View Building Calculation Views Using the Graphical Method Implement information models in SAP HANA Advanced Concepts in SAP HANA Studio Derived Attribute Views Calculated Attributes Restricted and Calculated Measures Filter and Variable Operations Filters Variables and Input Parameters Currency Conversion Creating a Leveled Hierarchy Creating a Parent-Child Hierarchy Processing Content Objects Previewing Data of Content Objects Comparing Versions of Content Objects Viewing Version History of Content Objects Switching Ownership of Inactive Objects Generating Object Documentation Enabling Multilanguage Support for Objects Checking Model References Viewing the Job Log Personalizing Studio Versioning Checking Model References Customizing Perspectives HANA SQL Introduction to SQL script and script based ca lculation views 5 Using SQL & Using SQLScript Using SAP HANA Studio to Execute SQL and SQLScript Statements Table Type Definition CREATE TYPE DROP TYPE INSERT, UPDATE, DELETE statements Data definition and access control Data Types CREATE, ALTER, DROP Renaming Columns Functions & Expressions Procedures introduction Writing procedures Procedure Calls Data Provisioning Choosing a Data Provisioning Method Option 1:
Trigger-Based Replication:
SAP Landscape Transformation How SLT Works SLT Configuration SLT Administration (Start, Replicate, Stop, Suspend,Resume) Extended Features Option 2:
ETL-Based Replication:
SAP Data Services Preparing SAP HANA to Receive Data from SAP Data Services Loading Data Option 3:
Log-Based Replication:
Sybase Replication Server and Load Controller Option 4:
Direct Extractor Connection DXC Technology 6 Reporting SAP HANA and the SAP BusinessObjects BI Platform Overview of the SAP Business Objects Tools SAP Business Objects Dashboards (Xcelsius).
SAP Business Objects Web Intelligence SAP Business Objects Explorer SAP Business Objects Analysis SAP Business Objects Design Studio SAP Crystal Reports Connecting SAP Business Objects BI Tools to SAP HANA Universes with Open and Java Database Connections (ODBC/JDBC) Connecting to Excel with Open Database Objects (ODO) and MDX BICS Connections Connectivity Summary User Management & Administrator Security Creating Users Creating Roles Privileges User Administration 7 Hot Topics BW 7.
3 powered by HANA Overview Business Suite on HANA Overview HANA Innovations Information Composer Exercises CASE STUDY - COPA Scenario Steps:
Provisioning the relevant tables Creating attribute view, analytic view & calculation views for COPA Model Once you make the decision on SAP HANA, join us and lets have fun!.
Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
