Learn Sap Hana Cloud With User And Role Management [Handson]

Start SAP HANA Cloud Journey with Administration and Security using HANA Cockpit, SAP BTP, SAP CAP and HANA DB Explorer

What you'll learn

Learn in detail about - SAP HANA Cloud, HANA Cloud Central, HANA Cockpit, Database Explorer, BTP & BAS.

Step by step detailed guide on SAP HANA Cloud Security - User Management & Role Management

Introduction to SAP HANA Cloud. Architecture of HANA Cloud, SAP HANA (on-premise) Vs SAP HANA Cloud

Understand about - SAP BTP Key Terms, Place of HANA Cloud in SAP BTP Account Model

Create Multi-Environment edition of HANA Cloud, Assign Role Collections to access HANA Cloud

Create HANA Cloud Database Instances - Database Instance & Datalake Instance

Explore HANA Cloud Database Instance - Technical details, Monitoring Tiles, Configurations & System Services

Create standalone HANA Cloud, Data Lake Instance & Create DB Instances at Space Level

Learn to Create & Configure the CAP project and Prepare CAP project for Development.

Create design-time database(DB) objects in CAP Project, Create HDI Container service instance & Bind it to CAP project

Locally deploy design-time DB Objects to HANA Cloud & Check generated runtime objects in HANA Database Explorer

Build & Deploy CAP Project to deploy Design Time DB Objects to SAP HANA Cloud

Learn about SAP HANA Database(DB) Explorer - Explore Properties of DB Instance & DB artifacts from Catalog

Add HANA Cloud DB Instances at SAP HANA DB Explorer - Add Cockpit DB, HANA DB, Data Lake & HDI Container Instance

Explore technical details of Tables from HANA DB Explorer & Import data into DB Tables.

Create new DB Table using csv file at Catalog level & Explore table operations at HANA DB Explorer

Query with SQL Console in HANA DB Explorer - Execute different SQL queries & check output windows like Results, History

Query SQL Console in HANA Cloud Central - Connect / Disconnect to DB Instance

Run SQL Query as background activity & Run on multiple Databases. Connect SQL Console to different Databases

Learn about HANA Cloud Users - SAP Owned Users, Standard Users Vs Restricted Users

Learn about DBADMIN User - Conventions to use, Explore detail view, Check Object & System Privileges of DBADMIN

Explore SAP HANA Cockpit. Check 'Security & User Management' view

Create HANA Cloud Users using SQL Console & using HANA Cockpit. Set Authentication Properties.

Manage HANA Cloud Users - Edit, Activate / Deactivate, Delete

Learn about HANA Cloud User Groups - Need, Properties, Tasks & ways to create User Group. Explore 'User Group Management'

Create HANA Cloud User Group using HANA Cockpit - Assign Users & Create a new users in User Group. Set Password Policy & Explore 'User Group Management'.

Explore System Views for User (SYS_USER) & User Group (SYS_USERGROUP) in Database Explorer

Understand Authentication in HANA Cloud - Explore Authentication Methods as User Name & Password, SAML etc…

Understand Privileges in HANA Cloud - Use & Properties, Privileges Vs Roles, Explore System & Object Privileges and its use-cases

Understand relation between Users, User Groups & Privileges - Assign Privileges using DBADMIN & using Standard User

Create User Group & Assign Privileges using SQL Console - Need, Create User & Group with Standard User as Admin

Explore Roles in Role Management, Edit Role & Edit Privileges assigned to the Role. Check Role Groups

Create Catalog Roles using HANA Cockpit & Check relation between Users, Roles & Privileges.

Create HDI Roles using BAS. Generate design-time object for HDI Role & deploy it to HANA Cockpit to create HDI Role.

Apply & Test Catalog Role and HDI Role on Database Table.

Requirements

Basic Understanding of SAP

Description

This course will definitely help you to start your SAP HANA Cloud journey starting from the HANA Cloud concepts to the Creation of DB Instances, User & Role Management with HANA Cockpit & DB ExplorerThe course is carefully designed and topics have been explained in detail, step-by-step and simple manner.Course Goals - Learn about SAP HANA Cloud, HANA Cloud Central & HANA Cockpit Create HANA Cloud DB Instances, Manage it, Explore details of it, Do Instance mapping in Manage Configuration Create design-time DB Objects using CAP Project and Deploy it to HANA CloudExplore generated Runtime objects in HANA DB ExplorerExplore SAP HANA DB Explorer, Add HANA Cloud DB Instances & query with SQL Console in Cloud Central & in DB Explorer Learn HANA Cloud User Management - Explore HANA Cockpit User Management. Create & Manage Users, User Groups using HANA Cockpit & SQL Console Learn HANA Cloud Role Management - Create Privileges, Authentication, Catalog & HDI Roles. Learn & Test relation between Users, Roles & PrivilegesConcepts you will learn - About SAP HANA Cloud - It's Need, Architecture, Features, Use-cases & Place of HANA Cloud in SAP BTP Account ModelAbout SAP BTP Key Terms. What is HANA Cloud Central? What is HANA Cockpit? What is HANA DB Explorer? How to create different types of Cloud DB Instances? How to manage DB Instances? Need of Instance Mapping. Design-Time Vs Runtime DB Objects. Need to configure CAP Project to create design-time objects. How to add different types of Cloud DB Instances in DB Explorer? Explore technical details of DB artifacts & Import Data. Query with SQL Console. Conventions for DBADMIN, Standard Vs Restricted Users. How to Create Cloud Users & Groups using SQL Console & HANA Cockpit. About Privileges, Authentication, DB Roles, Catalog Vs HDI Roles. How to apply Roles on DB objects?Relation between Users, User Groups & Privileges. Relation between Users, Roles & Privileges.You will learn step-by-step - Step by step detailed guide for beginners to Create HANA Cloud DB Instances using SAP BTP & Cloud CentralCreate Multi-Env edition of HANA Cloud, Assign Role Collections to access HANA CloudCreate HANA Cloud Database Instances - Database Instance & Datalake InstanceCheck HANA Cloud Database Instance - Technical details, Monitoring Tiles, Configurations & System ServicesManage HANA Cloud DB Instances & Do Instance mapping in Manage Configuration Create standalone HANA Cloud, Data Lake Instance & Create DB Instances at Space Level Step by step guide to create Design Time Database ObjectsCreate & Configure the CAP project and Prepare CAP project for DevelopmentCreate Design Time DB Objects in CAP Project, Create HDI Container service instance & Bind it to CAP project Locally Deploy Design Time DB Objects to HANA Cloud & Check generated runtime objects in HANA DB ExplorerBuild & Deploy CAP Project to deploy Design Time DB Objects to SAP HANA CloudStep by step guide about SAP HANA DB Explorer, to add HANA Cloud DB Instances & Query with SQL ConsoleAdd HANA Cloud DB Instances at SAP HANA DB Explorer - Add Cockpit DB, HANA DB, Data Lake & HDI Container InstanceExplore SAP HANA Database(DB) Explorer to check Properties of DB Instance & DB artifacts from CatalogCheck technical details of Tables from HANA DB Explorer & Import data into DB TablesCreate new DB Table using csv file at catalog level & Perform table operations at HANA DB ExplorerQuery with SQL Console in HANA DB Explorer & in HANA Cloud CentralStep by step about User Management & Role Management in HANA Cockpit Check 'Security & User Management' Tile from HANA Cockpit. Know about DBADMIN user, Standard Users Vs Restricted UsersCreate HANA Cloud Users using SQL Console & using HANA Cockpit. Set Authentication & Manage Cloud UsersCreate HANA Cloud User Group - Assign Users & Create a new users in it. Set Password Policy. Check Authentication & Privileges in HANA Cloud, Privileges Vs Roles, Explore System & Object PrivilegesCreate Catalog Roles using HANA Cockpit & HDI Roles using BAS. Test Catalog & HDI Roles on Database TableKnow relation between Users, Groups, Role & Privileges - Assign Privileges using DBADMIN & using Standard User

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Introduction to SAP HANA Cloud

Lecture 2 Introduction to SAP HANA Cloud - Part 1

Lecture 3 Introduction to SAP HANA Cloud - Part 2

Lecture 4 Architecture of SAP HANA Cloud

Lecture 5 Ways to start with SAP HANA Cloud

Lecture 6 Create SAP BTP Trial Account

Lecture 7 Understanding SAP BTP Key Terms

Lecture 8 Place of HANA Cloud in SAP BTP Account Model

Section 3: Getting Started with SAP HANA Cloud with Instance Creation & Configuration

Lecture 9 Getting Started to Create SAP HANA Cloud

Lecture 10 Understanding SAP HANA Cloud Central

Lecture 11 Create SAP HANA Cloud Instances

Lecture 12 Explore HANA Cloud DB Instance Details

Lecture 13 Manage HANA Cloud DB Instances

Lecture 14 HANA Cloud Instance Mapping in Manage Configuration

Lecture 15 Create HANA Cloud DB Instances at Space Level

Lecture 16 Create HANA Cloud Data Lake Standalone Instance

Section 4: Create design-time Database Objects and deploy it to SAP HANA Cloud

Lecture 17 Start design-time Object Creation Process & Navigate to BAS

Lecture 18 Prepare CAP Project for Development

Lecture 19 Create design-time Objects in CAP Project

Lecture 20 Deploy design-time DB objects to HANA Cloud (Local Deploy)

Lecture 21 Deploy design-time DB objects to HANA Cloud (Build + Deploy) - Part 1

Lecture 22 Deploy design-time DB objects to HANA Cloud (Build + Deploy) - Part 2

Section 5: Explore SAP HANA DB Explorer, HANA Cloud DB Instances & SQL Console

Lecture 23 Walkthrough of SAP HANA Database Explorer

Lecture 24 Add HANA Cloud DB Instances at DB Explorer

Lecture 25 Import Data into Database Tables - Part 1

Lecture 26 Import Data into Database Tables - Part 2

Lecture 27 Query with SQL Console in Database Explorer - Part 1

Lecture 28 Query with SQL Console in Database Explorer - Part 2

Lecture 29 Query with SQL Console in SAP HANA Cloud Central

Section 6: SAP HANA Cloud User Management

Lecture 30 SAP HANA Cloud Users : Key Concepts

Lecture 31 SAP HANA Cloud Users : DBADMIN, Predefined Users

Lecture 32 Walkthrough of HANA Cockpit & User Management view

Lecture 33 Explore DBADMIN in User Management

Lecture 34 Create HANA Cloud Users using SQL Console

Lecture 35 Create HANA Cloud Users using SAP HANA Cockpit

Lecture 36 Manage HANA Cloud Users (Edit, Deactivate, Delete)

Lecture 37 Understanding HANA Cloud User Groups

Lecture 38 Getting started to create HANA Cloud User Group

Lecture 39 Create HANA Cloud User Group using SAP HANA Cockpit

Lecture 40 Explore System Views for User & User Group

Section 7: SAP HANA Cloud Role Management

Lecture 41 Relation between Users, User Groups & Privileges - Part 1

Lecture 42 Relation between Users, User Groups & Privileges - Part 2

Lecture 43 Create User Group & Assign Privileges using SQL Console - Part 1

Lecture 44 Create User Group & Assign Privileges using SQL Console - Part 2

Lecture 45 Understanding Authentication in SAP HANA Cloud

Lecture 46 Understanding Privileges in SAP HANA Cloud

Lecture 47 Understanding DB Roles in SAP HANA Cloud

Lecture 48 Explore Roles in Role Management

Lecture 49 Create Catalog Roles in Role Management

Lecture 50 Relation between Users, Roles & Privileges

Lecture 51 Apply & Test Catalog Role on Database Table

Lecture 52 Create HDI Roles in Role Management

Lecture 53 Apply & Test HDI Role on Database Table

Students or Employees who want to learn SAP BTP & SAP HANA Cloud,SAP Cloud Administrators & BASIS Consultants,SAP BTP Project Team members