Hana
0 likes166 views
This document provides a summary of the course content for SAP HANA 100 and 300 certification training which covers topics such as HANA architecture, data modeling, administration, security, reporting and data provisioning. The 30 hour course teaches students how to work with the HANA in-memory database including loading and replicating data, creating attribute and calculation views, using SQL scripts and procedures, validating information models and managing security and authorizations. It aims to prepare students to work with and administer SAP HANA systems and pass the associated certification exams.
Hana
- 1. Self Learning SAP Center 2014 SAP HANA Consultant Course Content 30 hours HANA 100 & HANA 300 Course Content: SAP HANA 100 Certification Syllabus Introduction Introduction to SAP HANA SAP HANA In-Memory Strategy HANA Compared to BWA Look and feel In memory Computing Studio Administration views Navigator View System View Information Modeler -Architecture Architecture Overview IMCE and surroundings Row Store Column Store Loading data into HANA Data Modeling Reporting Persistent Layer Back & Recovery Data Provisioning Replication Server Replication process Replication Architecture Data services SAP BODS and HANA. Basic Data service connection types New to Data Services 4.0 Full Extractor through ODP. Configure Import server Create and execute a Data service job to populate H ANA. Modeling Purpose of information Modeler. Levels of modeling in SAP HANA. Attribute Views Calculation Views Export & Import
- 2. Self Learning SAP Center 2014 Reporting HANA Reporting Layer. Connectivity options. Business Objects BI 4.0 Business Objects BI 4.0 Explorer Business Objects BI 4.0 Enterprise Crystal reports via ODBC/JDBC Connections Others & MS Excel User Management Creation of Users Creation of Roles Creation of Role Hierarchy Assignment of users to roles Authentications IMCE Authorizations SAP HANA 300 Certification Syllabus DATA PROVISIONING USING SLT Positioning and key concepts Overview on configuration Aspects Data Replication at a glance. SLT based transformation concepts. Selective Data Replication. Transformation of Data. Extension of (target) table structure. Specific Considerations. Approaching SAP HANA Modeling Persistency Considerations SAP HANA Engine Overview Choosing views for the information Model. Connecting Tables How to connect tables Using: Inner Join Left Outer Join Right Outer Join Full Outer Join Text Outer Join Referential Join Union Advanced Modeling Creating Attribute Views. Using Hierarchies. Creating Restricted & calculated Measures. Using Filter Operations
- 3. Self Learning SAP Center 2014 Using Variables SAP HANA SQL Introduction. SQL Script and Procedures Using Currency Conversion. Processing Information Models Validating Models Comparing Versions of Information Objects Checking Model References Generating : Auto Documentation. Managing Modeling Concepts Schemas Import & Export Copying Objects Security and Authorizations User Management & Security Types of Privileges Template Roles Administrative Contact us for the SAP HANA Self Learning Videos at info@selflearningsap.com