Sap Hana admin Training

1
SAP-HANA TRAINING
2

• SAP HANA Overview
• Introduction to SAP HANA
• SAP HANA components
• SAP HANA Revision Strategy
• SAP HANA Versions
• SAP HANA Editions
• Installation of Hana Systems on ERP, SCM, SRM,
  CRM, and Netweaver 7.4

3

• PREPARING SAP HANA Installation
• Sizing of SAP HANA
• CPU sizing
• Memory Sizing(Static RAM and Dynamic RAM)
• Disk Sizing
• Requirements
• Hardware Requirements
• Software Requirements
• Directories required for SAP HANA
•  System Types
• SAP HANA Main Components

4

• SAP HANA Lifecycle Management Tools
• SAP HANA Platform Lifecycle Management
• SAP HANA Application Lifecycle Management 
• SAP HANA Installation
• Perquisites for a SAP HANA installation
• SAP HANA Server Installation
• Performing distributed System Installation
• SAP HANA Studio Installation
• SAP HANA Client Installation
• Installing SAP HANA SHINE Content
• SAP HANA Post Installation
• Managing SAP HANA Licenses
• License Keys
• Check the Current License Key
• Install a Permanent License
• Delete an Existing Permanent License Key

5

• SAP HANA lifecycle Management Function Options
• Updating SAP HANA
• Two Ways for Upgrading SAP HANA
• Pre-requisites Of Updating SAP HANA
• Update Process Flow
• SAP HANA ARCHITECTURE
• SAP HANA Database Architecture
• Persistence
• Memory Usage
• Memory Management in column Store 
• SAP HANA Administration Tool Overview
• SAP HANA Studio
• SAP HANA Cockpit
• HDBSQL Command Line Tool
• DBA Cockpit

6

• System Administration
• Start a System
• Stop a System
• Restart a System
• Stop and Start a Database Services
• Monitoring SAP HANA Systems during Stop and Start
• Starting and Stopping SAP HANA Distributed
  Systems
• Table Administration
• Column-Based and Row-Based Storage in the SAP
  HANA Database
• Memory Management in the Column Store
• Creating tables by Different methods
• Load and unload column store tables manually
• Load tables to the memory of the HANA server
• Check the size of the memory consumption of main
  storage and delta storage

7

• Types of Delta Merges
• Trigger Delta Merge Operation Manually
• Data Compression in the Column Store
• Converted Row Store Tables to Column Storetables
• Viewing Options for Tables and Views
• Export Tables and Other Catalog Objects
• Import Tables and Other Catalog Objects
• SAP HANA Operation
• Starting and stopping SAP HANA
• Configuring SAP HANA
• Transporting Changes
• Periodic Tasks
• Initial tasks
• Regular tasks
• On Demand Tasks

8

• Backup Recovery
• Concept of Backup andRecovery
• Configure backup settings
• Data area Backup
• Log area Backup
• Backup of configuration files
• Backup of Tenant database
• Recovery of Tenant database
• Backup and Recovery Using Storage snapshot 
• Configuring Multitenant Database Containers
• Architecture of Multi Tenant Database Containers
• Migrated Statistics Server into Embedded
  Statistics Server
• Convert an SAP HANA System to Multitenant
  Database containers
• Create a Tenant Database
• Adding Single and Multitenant Databases to
  HANAStudio

9

• Drop a Tenant Database
• Stop and Start a Tenant Database
• Monitoring multiple database container systems
• Managing Resources in Multiple-Container Systems
• System Views in Multiple-Container Systems  
• Maintaining Users and Authorizations
• Users management
• Types of privileges
• Roles
• Assigning Role to User
• Assigning Privileges to Roles
• System privileges
• SQL privileges
• Package privileges
• Granted role privileges
• Object privileges
• Encryption

10

• Monitoring and Troubleshooting
• Monitoring with SAP HANA Studio
• Monitoring With SAP HANA Cockpit
• Monitoring with DBACOKPIT
• Status Overview
• Services Overview
• Diagnosis files
• Memory Usage details
• System Load History
• Disk Usage Details
• Checking System Configuration
• Alerts
• Check the alerts and error logs
• Performance Overview
• Volume configuration
• Check diagnosis files

11

• SAP HANA STRENGTHEN
• SAP HANA Scenarios
• SAP HANA Add-on Deployment
• SAP HANA Database Copy
• Upgrade SAP HANA Database from
• SPS9 to SPS10
• SPS10 to SPS11
• SPS11 to SPS12 
• Data Provisioning Tools
• SLT Basic Concepts and Landscape Options
• Details on Configuration Aspects and Replication
  Concept
• Configuration Monitoring Dashboard
• Important SAP LT Replication Server Jobs
• Monitoring of Load and Replication Process
•  

12

• Additional benefits from NBITS
• Course Material
• Sample resumes and Fine tuning of Resume
• Interview Questions
• Mock Interviews by Real time Consultants
• Certification Questions
•