SAP HANA ADMIN
Overview
SAP HANA ADMIN TRAINING IN PUNE
Learn SAP HANA Training with Projects
Duration of Data Science Training : 40 hrs
Number of Sessions : 15
Batch type : weekdays /weekends
Mode of SAP HANA Training: Classroom / Online / Corporate Training
SAP HANA Training , Real Time Projects , Assignments , scenarios are part of this course
Lessons
SAP HANA Technology Overview
1. SAP HANA Introduction
2. Understanding the need of In Memory Technologies
3. Understanding High performance Analytics
4. In-Memory Computing
5. SAP HANA row store vs Columnar store
SAP HANA Editions
1. Software Packaging
2. SAP HANA Platform Edition
3. SAP HANA Enterprise Edition
SAP HANA Deployment Scenarios
1. HANA as DataMart
2. Non-Native HANA Applications
3. Native HANA Applications
SAP HANA Architecture
1. Simplified Architecture of SAP HANA
2. SAP HANA Memory Management and Data Persistence
Preparing Installation
1. Sizing of SAP HANA
2. Sizing KPI's (Memory, CPU, HDD, Network)
3. Quick sizer
4. Sizing Requirements and assumptions
5. Experiencing HANA Appliance Models
Operating Systems
1. Operating Systems Supported (SLES&RHEL)
2. Linux Operating System Requirements
- File System Preparation
Installation
1. Introduction SAP HANA Lifecycle Management Tools
2. Install a Single-Host SAP HANA System
3. Advanced installation options
Post Installation
1. Post-Installation Steps
2. SAP HANA Studio installation
3. SAP HANA Client Installation
Admin Tools for SAP HANA
1. SAP HANA Studio and SAP HANA Cockpit
2. Connect to the SAP HANA Database Using SAP HANA Studio
3. DBA Cockpit
4. HDBSQL Command Line Tool
Database Administration Tasks
1. Starting and Stopping SAP HANA
2. Use Different Methods to Start and Stop the SAP HANA Database
3. HANA database services and their significance
4. Understanding Service Instances
5. Understanding the Run level parameter
6. Configuring the SAP HANA Database
7. Change SAP HANA Configuration Parameters
Backup and Recovery
1. Concept of Backup and Recovery
2. Need of Backup
3. Data Area Backup
4. Understanding Backup Destinations
5. Understanding BACKINT
6. Performing Data backup using HANA Studio, Sql Commands, DBA
7. Cockpit, HANA Cockpit
8. Scheduling backups using DBA Cockpit, HANA Cockpit, Backup script
9. Log Area Backup
10. Understanding the concept of Log area backup
11. Handling LOGFULL situations
12. Additional Backup Topics
- Taking backup of Configuration Files
14. Performing Storage SNAPSHOT backup
Recovery
15. Performing Database recovery
16. Recovery options
17. Recovery using Storage SNAPSHOT
18. Database Copy / Database refresh
19. Recovery Using HANA Cockpit 2.0
Security
1. Security Overview
2. Understanding levels of security
3. Understanding security in different scenarios
4. Authentication and Authorization
5. Encryption
6. Auditing and audit policy
Maintaining Users and Authorization
1. User Management
2. Creating users using HANA Studio and Web IDE
3. Types of Privileges
4. Working with Analytic privileges
5. Roles
6. Creating runtime Roles
7. Creating Repository Roles using Web IDE
8. Administrative Tasks
9. Information Sources for Administrators
HANA Application Life Cycle Management
1. Concept of HANA Development
2. Understanding Catalog and Content objects
3. Transporting using Export and Import
4. Concept of Deliver Unit
5. Setting up Transportation landscape
6. Configuring Transport Routes
7. Understanding the Import logs
8. Concept of CTS in SAP HANA
Multi tenant Database Containers
- Architecture and Technology
2. Comparing Deployment options
3. Installing MDC
4. Creating and Configuring Tenant Databases
5. Administration of Multi tenant Database Containers
6. Backup and Recovery of Multi tenant Database Containers
7. Convert a Single container to a multitenant System
High Availability and Disaster Tolerance
1. Need of Scalability
2. SAP HANA Scale up and Scale Out
3. Understanding Distributed database
4. High availability concept
5. Disaster Recovery
6. Configuring system replication
Database Operations
1. SAP HANA Table Administration
2. Periodic Tasks
3. Housekeeping activities
4. Delta Merge
5. SQL Console
Monitor and Administration of SAP HANA using SAP HANA
Cockpit 2.0
1. Installing SAP HANA Cockpit 2.0
2. Working with Cockpit Manager
3. Creating Resource Groups and adding Resources
4. Monitoring activities using Cockpit 2.0
5. Understanding new features of Cockpit 2.0
Additional Topics
- Configuring Data Replications using SLT
- SAP HANA Direct Extractor configuration
Teachers
Robert Deniro
Software Engineer
About Course
(47 Reviews)
SAP HANA Admin training tutorials provide you everything to learn about SAP HANA Admin implementation and end-user level process step by step with various screenshots.
- Software
- 8 Week
- Intermediate
- 12 Lesson
- 5 Quizzes
- Certificate
- English