Learn SAP BTP HANA Cloud with User and Role Management

Learn SAP BTP HANA Cloud with User and Role Management free download

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

This course will definitely help you to start your SAP BTP HANA Cloud journey starting from the HANA Cloud concepts to the Creation of DB Instances, User & Role Management with HANA Cockpit & DB Explorer

The 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 Cloud

• Explore generated Runtime objects in HANA DB Explorer

• Explore 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 & Privileges

Concepts you will learn -

• About SAP HANA Cloud - It's Need, Architecture, Features, Use-cases & Place of HANA Cloud in SAP BTP Account Model

• About 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 Central

  1. Create Multi-Env edition of HANA Cloud, Assign Role Collections to access HANA Cloud

  2. Create HANA Cloud Database Instances - Database Instance & Datalake Instance

  3. Check HANA Cloud Database Instance - Technical details, Monitoring Tiles, Configurations & System Services

  4. Manage HANA Cloud DB Instances & Do Instance mapping in Manage Configuration

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

• Step by step guide to create Design Time Database Objects

  1. Create & Configure the CAP project and Prepare CAP project for Development

  2. Create Design Time DB Objects in CAP Project, Create HDI Container service instance & Bind it to CAP project

  3. Locally Deploy Design Time DB Objects to HANA Cloud & Check generated runtime objects in HANA DB Explorer

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

• Step by step guide about SAP HANA DB Explorer, to add HANA Cloud DB Instances & Query with SQL Console

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

  2. Explore SAP HANA Database(DB) Explorer to check Properties of DB Instance & DB artifacts from Catalog

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

  4. Create new DB Table using csv file at catalog level & Perform table operations at HANA DB Explorer

  5. Query with SQL Console in HANA DB Explorer & in HANA Cloud Central

• Step by step about User Management & Role Management in HANA Cockpit

  1. Check 'Security & User Management' Tile from HANA Cockpit. Know about DBADMIN user, Standard Users Vs Restricted Users

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

  3. Create HANA Cloud User Group - Assign Users & Create a new users in it. Set Password Policy.

  4. Check Authentication & Privileges in HANA Cloud, Privileges Vs Roles, Explore System & Object Privileges

  5. Create Catalog Roles using HANA Cockpit & HDI Roles using BAS. Test Catalog & HDI Roles on Database Table

  6. Know relation between Users, Groups, Role & Privileges - Assign Privileges using DBADMIN & using Standard User