SAP HANA Training - Complete SAP HANA Course - SP9 and SP12 HD

This video covers SAP HANA Modeling which is part of our SAP HANA Training course. We offer complete SAP HANA Training. For complete course please visit http://www.tekvdo.com/course/sap-hana-online-training There are more SAP HANA Tutorials available in complete course. SAP HANA Training videos will help learning the module at your own pace.The best practice is to watch each video twice with the trainer and try to implement the same steps in your system. This way you will get a good grip in the module. Introduction to SAP HANA 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 Architecture 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 Using SQL in HANA Studio 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