SAP HANA Admin Online Training

SAP HANA Admin Online Training

SAP HANA Admin Online Training, SAP HANA Admin Online Training in Hyderabad, SAP HANA Admin Training

SAP HANA Admin Online Training

Sap HANA Admin Online training course made easy through Eduwizz by its best available experienced SAP HANA Admin online tutors. Instructor led classes offer intensive, role-based training with fully equipped infrastructure and bring the Sap HANA Admin training best experience. We provide an opportunity to interact with the online tutors and peers, further enhance the Sap HANA Admin tutorials experience by sharing the real time tips, tricks and best Industry practices

SAP HANA Admin Training Course Content

  • User creation
  • Roles creation
  • Roles usages and when we will use roles
  • Role assignment
  • privileges (Analytical privileges /Object privileges (Sqlprivileges)/Package privileges)
  • Catalog export and import
  • Content export and import
  • Working on HANA Studio
  • HANA Monitoring using studio and Dashboards and through command prompt.
  • Alerts configuration on HANA studio
  • HANA Traces configuration
  • Tables creation
  • Schemas creation
  • Restrict a user to view data in a table/view
  • Restrict a user to view data on a particle field.
  • Restarting services (Names server/Index server/Statistics server/xsces engine...etc)
  • Stopping and starting Services
  • Stopping and starting HANA db Single system using command prompt and studio
  • Stopping and starting HANA multimode system using command prompt.
  • Adding new system in Studio
  • Table partitioning using HASH/ Round robin/ Range Partition based on the client requirement.
  • License installation
  • Working on Parameter setting
  • Explain global allocation limit and parameter setting
  • HANA administration, Security policies configuration.
  • HANA security auditing configuration.
  • Explaining briefly HANA backup and recovery and usages.
  • HANA Database backup using command prompt and studio.
  • HANA db restore using scenarios (Point in time recovery and Most recent state and Using existing backup)
  • Explain briefly why backup fails?
  • Explain Incidents and problem-solvingscenarios and working on trace files.
  • Explain crash dump analysis on Index server.
  • explain CPU issues, OOM (out of memory issues), Backup issues.
  • Installation of HANA DB, Client and Studio.
  • Upgradation of HANA DB, Client and Studio.
  • scaleup and scale out.
  • Explanation briefly about HANA Architecture.
  • Explanation of Multimode and HSR systems.
  • Explanation of Multitenant databases.
  • How to configure SLT
  • Delta Merge.
  • Runtime dump creation
  • Fullsysteminfo dump creation.
  • Analysis the traces (OOM, CRASH) for services.

Advanced Concepts will explain:

  • Single container
  • Multicontainer systems.
  • How to stop and Start Multicontainer (Tenant DBs)
  • SDA: Smart data access.
  • Replication technologies.
  • Explaining ATTV, ANV, CAV
  • EXCEL Integration