Course Description

SAP HANA is an In-Memory, Column Oriented relational database management system which is very hot in the market. Start learning today and get expert at your own pace with our video based SAP HANA Training Course. 

This course was initially recorded on SPS9 version. Now the course is upgraded to the new featuers of SPS10, 11 and 12. 
Show more

Share

About Trainer

Kumar(SPS9), Bhagat A(SPS10, 11 and 12)
Sr. SAP HANA Consultant/Trainer
Kumar is a seasoned SAP HANA Consultant and Trainer. He is technically very strong in BW and SAP HANA. Bhagat is experienced HANA/S4HANA Consultant and Trainer.
Show more

Duration

42 hrs | 61 Videos

SAP HANA SP9, 10, 11 and 12

Duration
42 hrs
$69.65 $199.00    
Expand all
Collapse all
  • Introduction to SAP HANA
    • 1. Introduction to SAP HANA
    • 2. Rapid Deployment options
    • 3. Deployment Options
    • 1. Introduction to SAP HANA
    • 2. Rapid Deployment options
    • 3. Deployment Options
  • Look and Feel (HANA Studio)
    • 1. Administration perspective
    • 2. Modeler perspective
    • 3. Developer perspective
    • 4. BW Tools
    • 5. Navigator View
    • 6. Quick launch screen
    • 1. Administration perspective
    • 2. Modeler perspective
    • 3. Developer perspective
    • 4. BW Tools
    • 5. Navigator View
    • 6. Quick launch screen
  • Architecture
    • Architecture Overview
    • ......1. IMCE and Surroundings
    • ......2. Row Store
    • ......3. Column Store
    • Persistent Layer
    • Backup & Recovery
    • Architecture Overview
    • ......1. IMCE and Surroundings
    • ......2. Row Store
    • ......3. Column Store
    • Persistent Layer
    • Backup & Recovery
  • Data Provisioning
    • Method 1: Data loading from Flat files using HANA Studio
    • Method 2: Data loading using Data Services 4.0 (ETL Based Approach)
    • ......1. Data Services 4.0 Architecture in detail
    • ......2. Data Stores in BODS
    • ......3. BODS Objects and different components
    • ......4. Building Data Flows in Designer (to Load the Data to SAP HANA)
    • ......5. Query Transform in the Data Flow
    • ......6. Loading the Data from diff files to SAP HANA using SAP BODS (Text files, spread sheets, XML files)
    • ......7. Using Merge Transform, Date Generation Transform, SQL Transform, Pivot Transform
    • ......8. Using Reverse Pivot, Match Transform, Case Transforms, Validation Transforms
    • ......9. Using KEY Generation Transform, Table Comparison Transform
    • ......10. Using History Preservation Transform
    • ......11. Map operation Transform in BODS Data Flow to load the data to SAP HANA
    • ......12. Creating Repository Users
    • ......13. Creating a Local Repository
    • ......14. Loading data from SAP ERP system to HANA.
    • ......15. Loading the Data from Non-SAP Source Systems to SAP HANA using SAP BODS
    • Method 3: Data provisioning using SLT (Real-time)
    • ......1. Positioning and Key Concepts
    • ......2. Overview on Configuration Aspects
    • ......3. Selective Data replication
    • Method 4: Data provisioning using Direct Extractor Connection (DXC)
    • ......1. Using SAP provided Business Content Extractor
    • ......2. ABAP Data Flows for Table and Pool clusters
    • Method 5: Data provisioning using Sybase Replication (Real-time)
    • ......1. Introduction to SRS
    • ......2. How to perform real-time replication using SRS
    • Method 1: Data loading from Flat files using HANA Studio
    • Method 2: Data loading using Data Services 4.0 (ETL Based Approach)
    • ......1. Data Services 4.0 Architecture in detail
    • ......2. Data Stores in BODS
    • ......3. BODS Objects and different components
    • ......4. Building Data Flows in Designer (to Load the Data to SAP HANA)
    • ......5. Query Transform in the Data Flow
    • ......6. Loading the Data from diff files to SAP HANA using SAP BODS (Text files, spread sheets, XML files)
    • ......7. Using Merge Transform, Date Generation Transform, SQL Transform, Pivot Transform
    • ......8. Using Reverse Pivot, Match Transform, Case Transforms, Validation Transforms
    • ......9. Using KEY Generation Transform, Table Comparison Transform
    • ......10. Using History Preservation Transform
    • ......11. Map operation Transform in BODS Data Flow to load the data to SAP HANA
    • ......12. Creating Repository Users
    • ......13. Creating a Local Repository
    • ......14. Loading data from SAP ERP system to HANA.
    • ......15. Loading the Data from Non-SAP Source Systems to SAP HANA using SAP BODS
    • Method 3: Data provisioning using SLT (Real-time)
    • ......1. Positioning and Key Concepts
    • ......2. Overview on Configuration Aspects
    • ......3. Selective Data replication
    • Method 4: Data provisioning using Direct Extractor Connection (DXC)
    • ......1. Using SAP provided Business Content Extractor
    • ......2. ABAP Data Flows for Table and Pool clusters
    • Method 5: Data provisioning using Sybase Replication (Real-time)
    • ......1. Introduction to SRS
    • ......2. How to perform real-time replication using SRS
  • Using SQL in HANA Studio
    • 1. Writing DDL statements
    • 2. Writing DML statements
    • 3. SQL Functions
    • 1. Writing DDL statements
    • 2. Writing DML statements
    • 3. SQL Functions
  • Modeling
    • 1. Use of SAP HANA Studio
    • 2. Different Modeling objects
    • 3. Attribute Views
    • 4. Different joins
    • ......a. Inner
    • ......b. Left Outer
    • ......c. Right Outer
    • ......d. Full Outer
    • ......e. Text
    • ......f. Referential and Union
    • 5. Using Hierarchies (Level Based and Parent-Child Hierarchies)
    • 6. Creating Calculated Column in Attribute View
    • 7. Analytic Views
    • 8. Calculation Views
    • 9. Creating Advanced Calculation Views using GUI and SCRIPT methods
    • 10. Creating Restricted and Calculated Measures
    • 11. Using Filter Operations
    • 12. Using Variables, input parameters
    • 13. Currency Conversion for Measures
    • 14. Export & Import: Server and Client sides
    • 15. SQL Script and Procedures
    • 16. Comparing Versions of Information Objects
    • 17. Checking Model References
    • 18. Generate Auto Documentation
    • 19. Managing Modeling Content
    • ......a. Manage Schemas
    • ......b. Import and Export data Models
    • ......c. Copy Information Objects
    • 1. Use of SAP HANA Studio
    • 2. Different Modeling objects
    • 3. Attribute Views
    • 4. Different joins
    • ......a. Inner
    • ......b. Left Outer
    • ......c. Right Outer
    • ......d. Full Outer
    • ......e. Text
    • ......f. Referential and Union
    • 5. Using Hierarchies (Level Based and Parent-Child Hierarchies)
    • 6. Creating Calculated Column in Attribute View
    • 7. Analytic Views
    • 8. Calculation Views
    • 9. Creating Advanced Calculation Views using GUI and SCRIPT methods
    • 10. Creating Restricted and Calculated Measures
    • 11. Using Filter Operations
    • 12. Using Variables, input parameters
    • 13. Currency Conversion for Measures
    • 14. Export & Import: Server and Client sides
    • 15. SQL Script and Procedures
    • 16. Comparing Versions of Information Objects
    • 17. Checking Model References
    • 18. Generate Auto Documentation
    • 19. Managing Modeling Content
    • ......a. Manage Schemas
    • ......b. Import and Export data Models
    • ......c. Copy Information Objects
  • Smart Data Access
    • 1. Introduction
    • 2. Configuring Oracle/SQL as SDA Source
    • 3. Create Connection and virtual tables in HANA
    • 4. Create Modeling objects in HANA
    • 1. Introduction
    • 2. Configuring Oracle/SQL as SDA Source
    • 3. Create Connection and virtual tables in HANA
    • 4. Create Modeling objects in HANA
  • Predictive Analytics Library
    • 1. Introduction
    • 2. Installation of PAL Library
    • 3. Executing PAL algorithms in HANA
    • 1. Introduction
    • 2. Installation of PAL Library
    • 3. Executing PAL algorithms in HANA
  • Reporting
    • 1. Introduction to reporting options on HANA
    • 2. Introduction to SAP BOBI 4.1
    • 3. Connectivity options to different BOBI tools
    • 4. Busing Universes using Information Design Tool (IDT)
    • 5. Reports creation using Web Intelligence
    • 6. Crystal Report for Enterprise with HANA
    • 8. Creating Analysis Views using Analysis edition for OLAP (HANA OLAP connection)
    • 9. Using SAP Lumira as reporting tool
    • 10. Others & MS Excel 2010
    • 1. Introduction to reporting options on HANA
    • 2. Introduction to SAP BOBI 4.1
    • 3. Connectivity options to different BOBI tools
    • 4. Busing Universes using Information Design Tool (IDT)
    • 5. Reports creation using Web Intelligence
    • 6. Crystal Report for Enterprise with HANA
    • 8. Creating Analysis Views using Analysis edition for OLAP (HANA OLAP connection)
    • 9. Using SAP Lumira as reporting tool
    • 10. Others & MS Excel 2010
  • User Management & Data Security
    • 1. Creation of Users
    • 2. Creation of Roles
    • 3. Creation of Role Hierarchy
    • 4. Assignment of Users to Roles
    • 5. Analytic Privileges
    • 1. Creation of Users
    • 2. Creation of Roles
    • 3. Creation of Role Hierarchy
    • 4. Assignment of Users to Roles
    • 5. Analytic Privileges
  • New features in SAP HANA SP9
    • 1. Advanced Data Processing
    • 2. Dynamic Tiering
    • 3. Enterprise Information Management
    • 4. Smart Data Streaming
    • 5. Spatial Analytics
    • 1. Advanced Data Processing
    • 2. Dynamic Tiering
    • 3. Enterprise Information Management
    • 4. Smart Data Streaming
    • 5. Spatial Analytics
  • New Features in SPS10, 11 and 12
    • Support for SQL based Analytic Privileges (SPS10)
    • Rank Node supporting output rank column (SPS10)
    • Multiple default values for IPs, VARs (SPS10)
    • SAP HANA Studio Development Perspective
    • Core Data Services - CDS
    • Support for CDS Entities as Data Source (SPS10)
    • SQL-based Analytic Privileges with CDS (SPS11)
    • Hierarchy Enhancements (SPS10)
    • Time dependent hierarchies (SPS10)
    • Hierarchy SQL Integration – Aggregation (SPS10)
    • Hierarchy SQL Integration – Filtering (SPS10)
    • Hierarchy SQL Integration – Additional Attributes (SPS10)
    • Hierarchy Variables (SPS10)
    • Hierarchy support with Analytic Privileges (SPS11)
    • Cycle handling in user-defined hierarchies (SPS11)
    • Unassigned / null member handling support (SPS12)
    • Composite keys for Parent-Child hierarchies (SPS12)
    • Migrating an Object Type to a Different Object Type (SPS11)
    • Converting Attribute / Analytic Views to Calculation Views (SPS11)
    • Considerations for converting Attribute- and Analytic Views (SPS11)
    • Simulate a Migration Activity (SPS11)
    • Activate Migrated Objects (SPS11)
    • Migration Log (SPS11)
    • Undo Migration Changes (SPS11)
    • Convert Script-based Calculation Views to Graphical Calculation Views (SPS11)
    • Convert Classical XML-based Analytic Privileges to SQL-based Analytic Privileges (SPS11)
    • Consideration for migrating Analytic Privileges (SPS11)
    • General migration procedure recommendations (SPS11)
    • Enhancement in migrating an Object Type to a Different Object Type (SPS12)
    • Support of Decision Table design time references in Calculation View (SPS10)
    • Migration of Decision Table (SPS12)
    • Support of SQL views as datasource (SPS10)
    • Support for Expression language selection for Calculation Views (SPS10)
    • Derived from SCALAR Function based on string-type output value (SPS10)
    • Support of Derived Input Parameter Enhancements (SPS10)
    • Label descriptions in Value Help Dialogs (SPS10)
    • Calculation View Editor Enhancements – Copy / paste of parts of a model scenario (SPS10)
    • Calculation View Editor Enhancements – Generate Select SQL (SPS10)
    • Calculation Views Enhancements –Re-use of partial scenarios (SPS10)
    • Enhanced support for Right Outer-/Full Outer-Joins (SPS11)
    • Temporal Join enhancement in Calculation View (SPS12)
    • Implicit Union-node pruning enhancement using union pruning metadata tables (SPS11)
    • Support for AVG / DEV / VAR as aggregation functions (SPS11)
    • SQL Expressions for filters, restricted measures and default values for Variables (SPS11)
    • Attribute value internal-/external conversion metadata support (SPS11)
    • Attribute value internal-/external conversion metadata support (SPS11)
    • Enhancing Query Result Cache Controls (SPS11)
    • Currency conversion on inner aggregation nodes (SPS12)
    • Calculation Views Enhancements - Aggregation node measure conversion support (SPS12)
    • Calculation Views Enhancements –Semantic Node (SPS12)
    • Spatial Expression Support (SPS12)
    • Support for SQL based Analytic Privileges (SPS10)
    • Rank Node supporting output rank column (SPS10)
    • Multiple default values for IPs, VARs (SPS10)
    • SAP HANA Studio Development Perspective
    • Core Data Services - CDS
    • Support for CDS Entities as Data Source (SPS10)
    • SQL-based Analytic Privileges with CDS (SPS11)
    • Hierarchy Enhancements (SPS10)
    • Time dependent hierarchies (SPS10)
    • Hierarchy SQL Integration – Aggregation (SPS10)
    • Hierarchy SQL Integration – Filtering (SPS10)
    • Hierarchy SQL Integration – Additional Attributes (SPS10)
    • Hierarchy Variables (SPS10)
    • Hierarchy support with Analytic Privileges (SPS11)
    • Cycle handling in user-defined hierarchies (SPS11)
    • Unassigned / null member handling support (SPS12)
    • Composite keys for Parent-Child hierarchies (SPS12)
    • Migrating an Object Type to a Different Object Type (SPS11)
    • Converting Attribute / Analytic Views to Calculation Views (SPS11)
    • Considerations for converting Attribute- and Analytic Views (SPS11)
    • Simulate a Migration Activity (SPS11)
    • Activate Migrated Objects (SPS11)
    • Migration Log (SPS11)
    • Undo Migration Changes (SPS11)
    • Convert Script-based Calculation Views to Graphical Calculation Views (SPS11)
    • Convert Classical XML-based Analytic Privileges to SQL-based Analytic Privileges (SPS11)
    • Consideration for migrating Analytic Privileges (SPS11)
    • General migration procedure recommendations (SPS11)
    • Enhancement in migrating an Object Type to a Different Object Type (SPS12)
    • Support of Decision Table design time references in Calculation View (SPS10)
    • Migration of Decision Table (SPS12)
    • Support of SQL views as datasource (SPS10)
    • Support for Expression language selection for Calculation Views (SPS10)
    • Derived from SCALAR Function based on string-type output value (SPS10)
    • Support of Derived Input Parameter Enhancements (SPS10)
    • Label descriptions in Value Help Dialogs (SPS10)
    • Calculation View Editor Enhancements – Copy / paste of parts of a model scenario (SPS10)
    • Calculation View Editor Enhancements – Generate Select SQL (SPS10)
    • Calculation Views Enhancements –Re-use of partial scenarios (SPS10)
    • Enhanced support for Right Outer-/Full Outer-Joins (SPS11)
    • Temporal Join enhancement in Calculation View (SPS12)
    • Implicit Union-node pruning enhancement using union pruning metadata tables (SPS11)
    • Support for AVG / DEV / VAR as aggregation functions (SPS11)
    • SQL Expressions for filters, restricted measures and default values for Variables (SPS11)
    • Attribute value internal-/external conversion metadata support (SPS11)
    • Attribute value internal-/external conversion metadata support (SPS11)
    • Enhancing Query Result Cache Controls (SPS11)
    • Currency conversion on inner aggregation nodes (SPS12)
    • Calculation Views Enhancements - Aggregation node measure conversion support (SPS12)
    • Calculation Views Enhancements –Semantic Node (SPS12)
    • Spatial Expression Support (SPS12)

Last Viewed Video

No Video Viewed.