SAP HANA DB Security Made Easy

BY
Udemy

Gain an in-depth understanding of the strategies and methodologies involved with SAP HANA database security operations.

Mode

Online

Fees

₹ 449 1799

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

SAP HANA is a cross-database that maintains stored information rather than on a hard drive. This enables much faster data transmission than traditional disk-based information systems, enabling advanced, actual analytics. Subba Rao Parvathaneni - Sr. SAP Security Architect developed the SAP HANA DB Security Made Easy certification course, which is available on Udemy and is designed for learners who want to become certified system administrators and SAP technical consultants.

SAP HANA DB Security Made Easy online course provides a thorough learning experience that will enable students to master the principles and practices of SAP HANA database security. SAP HANA DB Security Made Easy online classes include 29 hours of digital resources divided into various short films to make it easier for learners to comprehend. topics like account administration, database roles, auditing, data masking, privileges, and objects.

The highlights

  • Certificate of completion
  • Self-paced course
  • 29 hours of pre-recorded video content
  • Learning resources

Program offerings

  • Online course
  • Learning resources. 30-day money-back guarantee
  • Unlimited access
  • Accessible on mobile devices and tv

Course and certificate fees

Fees information
₹ 449  ₹1,799
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

Troubleshooting

After completing the SAP HANA DB Security Made Easy online certification, learners will gain hands-on experience with the strategies and methodologies associated with the SAP HANA studio. Learners will explore the features of privileges such as system privilege, analytic privilege, object privilege, and application privilege, as well as catalog and repository objects. Learners will study account administration, data masking, and database role strategies. Learners will also study techniques for auditing and troubleshooting.

The syllabus

Introduction to SAP HANA STUDIO

  • INTRODUCTION TO HANA STUDIO - ADMINISTRATION CONSOLE
  • INTRODUCTION TO HANA STUDIO - PERSPECTIVES

Introduction to Privileges

  • SYSTEM PRIVILEGES
  • OBJECT PRIVILEGES
  • ANALYTIC PRIVILEGES
  • PACKAGE PRIVILEGES
  • APPLICATION PRIVILEGES

Catalog Objects

  • OVERVIEW
  • SCHEMAS
  • TABLES

Repository Objects

  • SCHEMAS
  • TABLES

User Account Administration

  • OVERVIEW
  • USING SQL STATEMENTS
  • USING SAP HANA STUDIO
  • USING SAP HANA WEB IDE
  • USER VIEWS
  • DELETING USERS
  • CONVERTING USER IDS IN HANA DB
  • CONVERTING USER IDS IN HANA DB - DEMO OF USING RESTRICTED USER ID
  • GRANTING AND REVOKING PRIVILEGES - SYSTEM PRIVILEGES - SQL STATEMENTS
  • GRANTING AND REVOKING PRIVILEGES - CATALOG SCHEMA - SQL STATEMENTS
  • GRANTING AND REVOKING PRIVILEGES - REPOSITORY SCHEMA - SQL STATEMENTS
  • GRANTING AND REVOKING PRIVILEGES - APPLICATION PRIVILEGES - SQL STATEMENTS
  • GRANTING AND REVOKING PRIVILEGES - REPOSITORY ANALYTIC PRIVILEGE - SQL STATEMENT
  • GRANTING AND REVOKING PRIVILEGES - PACKAGE PRIVILEGES - SQL STATEMENTS
  • GRANTING AND REVOKING PRIVILEGES - SAP HANA STUDIO
  • GRANTING AND REVOKING PRIVILEGES - SAP HANA WEB IDE
  • GRANTING AND REVOKING ROLES - CATALOG ROLES - SQL STATEMENT
  • GRANTING AND REVOKING ROLES - REPOSITORY ROLES - SQL STATEMENT
  • GRANTING AND REVOKING ROLES - REPOSITORY ROLES - SAP HANA STUDIO
  • GRANTING AND REVOKING ROLES - ROLES - SAP HANA WEB IDE

Database Roles

  • OVERVIEW
  • CREATING AND DELETING ROLES - SQL STATEMENTS
  • CREATING AND DELETING ROLES - SAP HANA STUDIO
  • CREATING AND DELETING ROLES - SAP HANA WEB IDE
  • GRANTING AND REVOKING PRIVILEGES - SYSTEM PRIVILEGES - USING SQL STATEMENTS
  • GRANTING AND REVOKING PRIVILEGES - CATALOG SCHEMAS - USING SQL STATEMENTS
  • GRANTING AND REVOKING PRIVILEGES - REPOSITORY SCHEMAS - USING SQL STATEMENTS
  • GRANTING AND REVOKING PRIVILEGES - CATALOG OBJECTS - USING SQL STATEMENTS
  • GRANTING AND REVOKING PRIVILEGES - REPOSITORY OBJECTS - USING SQL STATEMENTS
  • GRANTING AND REVOKING PRIVILEGES - REPOSITORY ANALYTIC PRIVILEGES - USING SQL ST
  • GRANTING AND REVOKING PRIVILEGES - APPLICATION PRIVILEGES - USING SQL STATEMENTS
  • GRANTING AND REVOKING PRIVILEGES - PACKAGE PRIVILEGES - USING SQL STATEMENTS
  • GRANTING AND REVOKING PRIVILEGES - USING SAP HANA STUDIO
  • GRANTING AND REVOKING PRIVILEGES - USING SAP WEB IDE
  • NESTED ROLES

Repository Roles

  • OVERVIEW
  • CREATING A PACKAGE AND REPOSITORY ROLE
  • GRANTING SYSTEM PRIVILEGES
  • GRANTING ACCESS TO CATALOG SCHEMA
  • GRANTING ACCESS TO CATALOG OBJECTS
  • GRANTING ACCESS TO REPOSITORY SCHEMA
  • GRANTING ACCESS TO REPOSITORY OBJECTS
  • GRANTING ACCESS TO ANALYTIC PRIVILEGES
  • GRANTING ACCESS TO PACKAGE PRIVILEGES
  • GRANTING ACCESS TO APPLICATION PRIVILEGES
  • CREATING REPOSITORY ROLE USING SAP HANA WEB IDE
  • GRANTING REPOSITORY ROLES TO USERS - WITH STORED PROCEDURES
  • GRANTING REPOSITORY ROLES TO USERS - WITH SAP HANA STUDIO AND WEB IDE
  • DEMO EXAMPLE - SECURITY ADMINISTRATOR ROLE

DEMO EXAMPLE - BASIS ADMINISTRATOR ROLE

System Privileges

  • RELATED TO DEVELOPMENT
  • RELATED TO SECURITY ADMINISTRATION
  • RELATED TO SYSTEM ADMINISTRATION
  • GRANTING TO USERS AND STANDARD ROLES
  • GRANTING TO REPOSITORY ROLES

Object Privileges

  • OVERVIEW
  • GRANTING AND REVOKING PRIVILEGES USING SQL STATEMENTS
  • GRANTING AND REVOKING PRIVILEGES USING SAP HANA STUDIO AND WEB IDE
  • GRANTING AND REVOKING PRIVILEGES USING REPOSITORY ROLES

Packages Privileges

  • OVERVIEW
  • GRANTING PACKAGE PRIVILEGES - USING SQL
  • GRANTING PACKAGE PRIVILEGES - WITH SAP HANA STUDIO AND SAP HANA WEB IDE
  • GRANTING PACKAGE PRIVILEGES - WITH REPOSITORY ROLES

Analytic Privileges

  • INFORMATION VIEWS - OVERVIEW
  • CLASSICAL ANALYTIC PRIVILEGE - PART 1
  • CLASSICAL ANALYTIC PRIVILEGE - PART 2
  • CLASSICAL ANALYTIC PRIVILEGE - PART 3
  • SQL ANALYTIC PRIVILEGE - PART 1
  • SQL ANALYTIC PRIVILEGE - PART 2
  • SQL ANALYTIC PRIVILEGE - PART 3
  • DYNAMIC CLASSICAL ANALYTIC PRIVILEGE - PART 1
  • DYNAMIC CLASSICAL ANALYTIC PRIVILEGE - PART 2
  • DYNAMIC SQL ANALYTIC PRIVILEGE - PART 1
  • DYNAMIC SQL ANALYTIC PRIVILEGE - PART 2
  • GRANTING ANALYTIC PRIVILEGES
  • GRANTING ANALYTIC PRIVILEGES USING REPOSITORY ROLE

Auditing

  • USING HANA STUDIO
  • USING SAP HANA WEB IDE
  • USING SQL STATEMENTS
  • QUERYING AUDIT DATA

Troubleshooting

  • TRACING USING SAP HANA STUDIO
  • TRACING USING SQL STATEMENTS
  • EFFECTIVE PRIVILEGES - GRANTED_PRIVILEGES
  • EFFECTIVE PRIVILEGES - GRANTED_ROLES
  • EFFECTIVE PRIVILEGES - ACCESSIBLE_VIEWS
  • EFFECTIVE PRIVILEGES - EFFECTIVE_PRIVILEGE_GRANTEES
  • EFFECTIVE PRIVILEGES - EFFECTIVE_STRUCTURED_PRIVILEGES
  • EFFECTIVE PRIVILEGES - EFFECTIVE_PRIVILEGES
  • EFFECTIVE PRIVILEGES - EFFECTIVE_ROLE_GRANTEES
  • EFFECTIVE PRIVILEGES - EFFECTIVE_ROLES

Data Masking

  • IMPLEMENTING DATA MASKING

Instructors

Mr Subba Rao Parvathaneni
Instructor
Freelancer

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books