SAP HANA Modeling & Security On Free Cloud Server
4.7 (34 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
233 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SAP HANA Modeling & Security On Free Cloud Server to your Wishlist.

Add to Wishlist

SAP HANA Modeling & Security On Free Cloud Server

Learn all aspects of SAP HANA Modeling and Security on Free Cloud Platform
4.7 (34 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
233 students enrolled
Created by Ayyub Patel
Last updated 2/2017
English
Curiosity Sale
Current price: $10 Original price: $95 Discount: 89% off
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 10 Articles
  • 5 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • learn how to do data analysis in SAP HANA
  • learn how to do business analysis and reporting on real-world data in SAP HANA
  • learn about Security in SAP HANA from Modeler's perspective
  • learn all the aspects of SAP HANA Modeling
  • learn how to create information models (views) on raw data
  • learn how to create new calculated columns
  • learn how to use input parameters and variables
  • learn how to create procedures in HANA
  • learn how to create and use Decision Tables
  • learn how to import data into HANA
  • learn how to create users
  • learn how to assign roles and giving privileges to the users
  • learn about other options available in HANA
  • learn about Data services
  • learn about SAP Lumira
  • learn how to use SAP HANA Cockpit and Web-based workbench
View Curriculum
Requirements
  • Basic computer skills, and a machine(Mac or PC), that's all. If you know basics of relational database(SQL), that would be a hugh advantage.
  • NO NEED to get any paid server access. This whole course is build on free cloud platform provided by SAP.
Description

With its unique features, SAP HANA is becoming the best product of SAP. In today's digital economy HANA is helping in making better business decisions in real time and it may soon become the future of databases.

In this course, we'll go through complete SAP HANA Modeling. You do not have to get any paid sever access. This whole course is build on free cloud platform provided by SAP. You can complete this short yet comprehensive course in your couple of weekend's free time.

We'll cover all the Modeling topics like Information Models, Procedures, Decision Tables etc. And, we'll also cover security in HANA from Modeler's perspective. We'll use real world data and we'll do our analysis on that. In the last section, I've covered couple of useful tools also, like BODS and Lumira (for these you need server).

Even if you are thinking about learning SAP HANA by getting paid server access, I'd recommend to take this course and make yourself 100% prepared so that you can make most out of your paid server.

Who is the target audience?
  • Database developers.
  • Front-end developers.
  • Project stakeholders.
  • Other SAP professionals.
  • Students.
  • Anyone who is interested in learning new technology.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
37 Lectures
03:53:54
+
Get Started
4 Lectures 13:37

Recommended read
00:03

Get Started
10:02

Creating Database and Version
00:37
+
Modeling
24 Lectures 02:45:00
What is Modeling
02:37

RDBMS
04:19

Recommended read
00:02

Joins
00:03

Please download these excel files. We are going to use this data as an example.

Data files
00:04

Import Data
19:57

Recommended read
00:02

Attribute View of subtype Standard
18:14

Attribute View of subtype Time and Derived
12:57

Hierarchies
04:59


Input Parameter to Calculate Measure
09:06

Variables and Restricted Columns
08:25

Dimension Calculation View
10:38

Cube Calculation View with Star Join
06:32

Cube Calculation View without Star Join
08:01

Calculation View with SQL Script
08:51

Calculation View using CE Functions
16:15

SQL Script for Our Calculation View
00:12

Recommended read
00:03

Column Views

Column Views
00:13

Procedure
06:38

Decision Table
08:37

Delivery Units and other Options
08:04
+
Security
6 Lectures 40:43
Introduction
02:20

Users
06:29

Privileges
11:18

Analytic Privilege
08:11

Roles
04:54

+
Extra
3 Lectures 14:37
Data Services
10:07

SAP Lumira
04:07

SLT
00:23
About the Instructor
Ayyub Patel
4.7 Average rating
34 Reviews
233 Students
1 Course
SQL BI Developer, Data Architect, Instructor, Student

Ayyub Patel is a SQL Server and Business Intelligence Developer and has been working as a contractor since 2012. He studied engineering at SGSITS Indore, India. He completed many data warehouse projects while working with different clients. He is also a graduate student at Loyola University Chicago. In his free time, Ayyub loves to play cricket and badminton. He also does web development for friends and family in his free time.