HANA SYLLABUS

UNIT 1: SAP HANA Overview UNIT 2: SAP HANA Sizing UNIT 3: SAP HANA Installation UNIT 4: SAP HANA Administration Tool Overview UNIT 5: System Administration UNIT 6: Setting Up and Configuring Multitenant Database Containers UNIT 7: Managing SAP HANA Licenses UNIT 8: Managing Tables UNIT 9: SAP HANA Pre & Post Installation UNIT 10: SAP HANA Operation UNIT 11: Backup & Recovery UNIT 12: Maintaining Users and Authorizations UNIT 13: Monitoring and Troubleshooting UNIT 14: SAP HANA Lifecycle Management UNIT 15: Advanced HANA

HANA TASK

TASKS ON HANA ADMINISTRATION

---

• 1. SAP HANA Architecture and In Memory Computing.
• 2. Installation of SAP HANA 1.0 SP9 /SP10/SP11 with ERP, CRM, SRM and SCM Systems.
• 3. HANA Installation on SUSE Linux 11.3 after checking the Prerequisites.
• 4. Installation of HANA Studio and HANA Client and Establish Connectivity with database.
• 5. SAP HANA database Upgrade from SPS09 to SPS10.
• 6. SAP HANA database Upgrade from SPS10 to SPS11.
• 7. Migration of Oracle and MS SQL to HANA Database using SWPM.
• 8. Migration of Oracle Database to HANA Database using the database migration option (DMO) as part of software update manager (SUM).
• 9. Installation of SLT Server as an add-on.
• 10. Daily Checklist of HANA Database.
• 11. HANA Sizing to define the Memory, CPU and Storage.
• 12. HANA Server Components.
• 13. Migration of Statistics Server into embedded Index Server.
• 14. Conversion Single Database to Multi Tenant database.
• 15. Creation of Tenant Databases based on requirement.
• 16. Adding Single and Multitenant databases to HANA Studio.
• 17. HANA Backup and Recovery as Part of the Tape Consistency.
• 18. Managing and monitoring Memory Physical, Virtual, resident and Peak Memories.
• 19. Identifying the issues related to HANA Start up and Diagnosed using Diagnosis Option.
• 20. Tracing the Runtime Issues and Resolve the HANA Start-Up Issues(space and Memory).
• 21. Assigned Roles for Platform and Application Life Cycle Management.
• 22. Setup password Rules to Hardening the System.
• 23. Performing Backup up of Tenant databases.
• 24.Working on SAP HANA DBA Cockpit using UX(Fiori) (/sap/HANA/admin/cockpit).
• 25. Reset the password of System User.
• 26. Configuring parameters for HANA Database using Global.ini(configuration).
• 27. Installation of permanent License and deleted old license keys and enhanced the license based on Memory from service Market Place, through HANA studio.
• 28. Setting up the Index Server, memory and other Performance related Parameters.
• 29. Assigning and granting the roles related to System, Object catalogs, Objects, IDE, HANA Admin Cockpit, ALM and PLM.
• 30. Working on the Alerts and Diagnosis Files to Check the Errors.
• 31. Monitoring the Status and resource usage of all system components, for example, Name server, Index server, and so on.
• 32. Monitoring the Alerts issued by the system in relation to its status, performance, and resource consumption.
• 33. Monitoring the Disk space consumed by system processes for the various storage types (data, log, and trace).
• 34. Performing Capacity planning for HANA Database.
• 35. Working on Hana Migrations from Different database vendors such as Oracle and SQL Server.
• 36. Monitoring file system space, database allocation, etc.
• 37. Installation of HANA Addons Using hdbalm at command line,like HANA Product Add-ons (TM,GRC,EWM).
• 38. SAP HANA System Start and Stop (HANA Studio and OS Level).
• 39. Row Store Tables to Column Store tables Conversion based on Requirement.
• 40. HANA Administration Using HANA Studio.
• 41. HANA PLM.
• 42. HANA ALM.
• 43. Backup administration and monitoring tasks such as Monitor the progress of a running backup, Start and cancel a backup, Review the most recent successful backup, Configure backup settings, Monitor the backup catalog, Remove data and log backups from the backup catalog, and also physically delete data and log backups, View the backup log file.
• 44. Monitoring the System performance, for example, by analyzing performance indicators such as expensive statements, running threads, and load history.
• 45. Migration HANA content from development, testing environment to Production environment using delivery units.
• 46. Establishing, implementing, and testing disaster recovery and business continuity techniques for SAP HANA.
• 47. Providing efficient database environment to maximize productivity and improve performance.
• 48. Monitoring file system space, database allocation, etc.
• 49. Adding user to SAP HANA System, Exporting/ Importing SAP HANA System.
• 50. Installed Hana Addons using hdbalm at command line.
• 51. Managing Table in SAP HANA and Scaling SAP HANA System
• 52. SAP ERP Installation with SAP HANA Database.
• 53. Performing System Copy (Heterogeneous and Homogeneous).
• 54. SAP HANA Product Add-ons (TM, GRC, EWM).
• 55. Deploying Hana Delivery Units.
• 56. SAP HANA System Start and Stop (HANA Studio and OS Level).
• 57. Adding Single and Multitenant Databases to Hana Studio.
• 58. Monitor the Systems Using Systems Monitor.
• 59.Security Administration Tasks: Create, change, and delete database users, Create, change, and delete roles in run-time, Grant and revoke privileges/roles to/from users and roles, Configure the password policy and the password blacklist, View procedures and calculation views in the Authorization Dependency Viewer .
• 60. Installation of Hana on SAPERP, Netweaver 7.5, S4HANA.
• 61. Installation SAP Netweaver 7.5 on Windows and SQL Server.
• 62. Exporting the Netweaver 7.5 towards Hana Database Migration.
• 63. Importing the Netweaver 7.5 Export in Hana Database.
• 64. Installation Hana in Single Container Mode and MultiContainer Mode.
• 65. Converting Single Hana Database to Multitenant Database.
• 66. Creating, Starting, Stopping and Dropping the Tenant databases.
• 67. Performing Backup of Hana Database and Log Backup.
• 68. Working with Delta backup (Incremental and Delta backups).
• 69. Installed HANA Studio both on Windows and Linux Systems and Connected to Hana Database on Port 3nn15.