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

Created by: SAP CloudMax
Courses on SAP BTP domain

Created by: SAP TutorPro
Courses on SAP Cloud domain

What Will I 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

Target audience

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