SAP Hana Admin
An SAP HANA system is identified by a single system ID (SID) and contains multiple isolated databases. Each database comprises multiple servers, for example, the index server. A system may consist of one host or a cluster of several hosts. This is referred to as a muliple-host or distributed system, and supports scalability and availability.
SAP Hana Admin Online Training
Training Mode: SAP Hana Admin Live Instructor-led (online) | SAP Hana Admin Corporate Training | SAP Hana Admin Job Support
Course Duration: 30-35 hours
Trainer: SAP Hana Admin Certified and expert instructors
An SAP HANA system is identified by a single system ID (SID) and contains multiple isolated databases. Each database comprises multiple servers, for example, the index server. A system may consist of one host or a cluster of several hosts. This is referred to as a muliple-host or distributed system, and supports scalability and availability.
- Training by Realtime Expert trainer
- Live Online Classes
- Free study material
- Online virtual Classes available in morning, evening and weekend
Before you start proceeding with this tutorial, we assume that you are well-versed with basic database concepts. You should have a good exposure to SQL, as SAP HANA is like a relational database.
We guarantee learning at your convenience & pace.
- Instant Access:
Get instant access to self-paced training after signup. - Streaming video recording:
Watch lessons any time at your schedule, free recording. - Exercises:
Practical exercises help you test what you are learning as you go. - Free Demo:
Sign up for free demo to check whether the course is right for you and interact with the faculty live. - Experienced Trainers:
We only hire the industry’s best trainers - Live free interactive web sessions:
Ask the Expert Shell Scripting trainers about the career prospects and clarify your questions any time after you complete the course. - Structured Curriculum Schedule:
Progress with your complete daily interactive lessons and assignments. - Faculty Mentoring:
Turn in daily and weekly homework for personalized feedback from faculty. - Virtual Office Hours:
Live interaction with the faculty and other students around the world. - Hands on Live Projects:
Work on live lab sessions to tackle real-world projects. Get 100% faculty guidance and ratings.
SAP Hana Admin Online Training
- SAP HANA Introduction
- Understanding the need of In Memory Technologies
- Understanding High performance Analytics
- In-Memory Computing
- SAP HANA row store vs Columnar store
- Software Packaging
- SAP HANA Platform Edition
- SAP HANA Enterprise Edition
- HANA as DataMart
- Non-Native HANA Applications
- Native HANA Applications
- Simplified Architecture of SAP HANA
- SAP HANA Memory Management and Data Persistence
- Sizing of SAP HANA
- Sizing KPI’s (Memory, CPU, HDD, Network)
- Quick sizer
- Sizing Requirements and assumptions
- Experiencing HANA Appliance Models
- Operating Systems Supported (SLES&RHEL)
- Linux Operating System Requirements
- File System Preparation
- Introduction SAP HANA Lifecycle Management Tools
- Install a Single-Host SAP HANA System
- Advanced installation options
- Post-Installation Steps
- SAP HANA Studio installation
- SAP HANA Client Installation
- SAP HANA Studio and SAP HANA Cockpit
- Connect to the SAP HANA Database Using SAP HANA Studio
- DBA Cockpit
- HDBSQL Command Line Tool
- Starting and Stopping SAP HANA
- Use Different Methods to Start and Stop the SAP HANA Database
- HANA database services and their significance
- Understanding Service Instances
- Understanding the Run level parameter
- Configuring the SAP HANA Database
- Change SAP HANA Configuration Parameters
- Concept of Backup and Recovery
- Need of Backup
- Data Area Backup
- Understanding Backup Destinations
- Understanding BACKINT
- Performing Data backup using HANA Studio, Sql Commands, DBA
- Cockpit, HANA Cockpit
- Scheduling backups using DBA Cockpit, HANA Cockpit, Backup script
- Log Area Backup
- Understanding the concept of Log area backup
- Handling LOGFULL situations
- Additional Backup Topics
- Taking backup of Configuration Files
- Performing Storage SNAPSHOT backup
- Performing Database recovery
- Recovery options
- Recovery using Storage SNAPSHOT
- Database Copy / Database refresh
- Recovery Using HANA Cockpit 2.0
- Security Overview
- Understanding levels of security
- Understanding security in different scenarios
- Authentication and Authorization
- Encryption
- Auditing and audit policy
- User Management
- Creating users using HANA Studio and Web IDE
- Types of Privileges
- Working with Analytic privileges
- Roles
- Creating runtime Roles
- Creating Repository Roles using Web IDE
- Administrative Tasks
- Information Sources for Administrators
- Concept of HANA Development
- Understanding Catalog and Content objects
- Transporting using Export and Import
- Concept of Deliver Unit
- Setting up Transportation landscape
- Configuring Transport Routes
- Understanding the Import logs
- Concept of CTS in SAP HANA
- Architecture and Technology
- Comparing Deployment options
- Installing MDC
- Creating and Configuring Tenant Databases
- Administration of Multi tenant Database Containers
- Backup and Recovery of Multi tenant Database Containers
- Convert a Single container to a multitenant System
- Need of Scalability
- SAP HANA Scale up and Scale Out
- Understanding Distributed database
- High availability concept
- Disaster Recovery
- Configuring system replication
- SAP HANA Table Administration
- Periodic Tasks
- Housekeeping activities
- Delta Merge
- SQL Console
- Installing SAP HANA Cockpit 2.0
- Working with Cockpit Manager
- Creating Resource Groups and adding Resources
- Monitoring activities using Cockpit 2.0
- Understanding new features of Cockpit 2.0
Contact us
Got more questions?
Talk to our team directly. A program advisor will get in touch with you shortly.
We’re happy to answer any questions you may have and help you determine which of our services best fit your needs.
Schedule a Free Consultation