Course Content - SAP Hana DB Administration Online Training

1)user creation
2) roles creation
3) Roles usages and when we will use roles                        
4) Role assignment
5) Privileases(Analytical privileases/Object privileases (Sql Privileases)/Package privileases)
6) Catalog export and import
7) Content export and import
8) Working on HANA Studio
9) HANA Monitoring using studio and Dashboards and through command prompt.
10) Alerts configuration on HANA studio
11) HANA Traces configuration
12) Tables creation
13) Schemas creation
14) Restrict a user to view data in a table/view
15) Restrict a user to view data on a particle field.
16) Restarting services(Names server/Index server/Statistics server/xsces engine...etc)
17) Stopping and starting Services
18) Stopping and starting HANA DB Single system using command prompt and studio 
19) Stopping and starting HANA multinode system using command prompt.
20)Adding new system in Studio
21) Table partitioning using HASH/ Round robin/ Range Partition based on the client requirement.
22) License installation
23) Working on Parameter setting
24) Explain global allocation limit and parameter setting
25) HANA administration , Security policies configuration.
26) HANA security auditing configuration.

27) Explaining briefly HANA backup and recovery and usages.
28)HANA Database backup using command prompt and studio.
29) HANA DB restore using scenarios (Point in time recovery and Most recent state and Using existing backup)
30) Explain briefly why backup fails?
31) Explaining Incidents and problem-solving scenarios and working on trace files.
32) Explain crash dump analysis on Index server.
33) explain CPU issues, OOM (out of memory issues), Backup issues.
34) Installation of HANA DB, Client and Studio.
35) Upgradation of HANA DB, Client and Studio.
36) scaleup and scaleout.
37) explained briefly about HANA Architecture.
38) Explanation of Multimode and HSR systems.
39) Explanation of Multitenant databases.
40) How to configure SLT
41) Delta Merge.
42) Runtimedump creation
43) Fullsysteminfo dump creation.
44) Analysis the traces (OOM, CRASH) for services.
Along with Advanced Concepts will explain.
1) Single container
2) Multi-container systems.
3) How to stop and Start Multicontainer (Tenant DBs)
3) SDA: Smart data access.
4) Replication technologies(SLT and BODS)
5) How to work on HANACOCKPIT

Share this with your friends:

Faculty Registration

Student Registration