Eligibility Criteria:
Education: BCS / MCS / BCA / MCA / Graduation or Post graduation in IT background.
Work experience: Fresher or experience in coding.
SAP HANA – 360° Introduction
Course Content
- Describing SAP HANA
- Technical Requirements of SAP HANA
- Data Management with SAP HANA
- Analytical Processing with SAP HANA
- Powering Data Warehouses with SAP HANA
- Running SAP Applications on SAP HANA
- Developing Applications of SAP HANA
- Monitoring SAP HANA
- Security and Data Privacy with SAP HANA
- Migration to SAP HANA
SAP HANA 2.0 SPS05 Modeling
Course Content
- Information Views
- Introducing Information Views
- Understanding the Different Types of Views
- Working with Common View Design Features
- Using Nodes in Calculation Views
- Using Projection Nodes
- Using Join Nodes
- Working with Data Sets
- Aggregating Data
- Creating Cubes with Star Join Calculation Views
- Extracting Top Values with Rank Nodes
- Modeling Functions
- Create Restricted and Calculated Columns
- Filter Data
- Use Variables and Input Parameters
- Create Hierarchies
- Implement Currency Conversion
- Using SQL in Models
- Introducing SAP HANA SQL
- Working with SQLScript
- Query a Modeled Hierarchy Using SQLScript
- Creating and Using Functions
- Creating and Using Procedures
- CDS in SAP HANA Modeling
- Defining the Persistence Layer Using CDS
- Creating Views with CDS
- Optimization of Models
- Using Tools to Check Model Performance
- Implementing Good Modeling Practices
- Management and administration of Models
- Working with Modeling Content in a Project
- Creating and Manage Projects
- Enabling Access to External Data
- Working with GIT Within the SAP Web IDE
- Migrating Modeling Content
- Security in SAP HANA Modeling
- Understanding Roles and Privileges
- Defining Analytic Privileges
- Defining Roles
- Masking Sensitive Data
- Anonymizing Data
- Introduction to Advanced Modeling
