
Introduces SAP HANA as an in-memory, column-oriented platform that combines OLAP and OLTP in one database, enabling real-time analytics, text and graph processing, and on-demand calculations.
Set up a distributed SAP HANA landscape with a master node, slave or worker nodes, and a standby node, sharing a single SID and storage (/hana/shared, /hana/data, /hana/log) via hdblcm/hdblcmgui.
Explore SAP HANA cockpit 2.0, a web-based central tool to monitor and manage multiple HANA databases, run SQL queries, and perform admin tasks from a single interface.
Install SAP HANA cockpit by meeting hardware and OS requirements, installing HANA database, using HDBLCM to configure cockpit, creating cockpit_admin with a master password, and verifying URLs via xs login.
Explore SAP HANA scenarios and roadmaps, including sidecar and primary persistence, platform edition, agile and operational data marts, data replication, greenfield vs brownfield, and DMA to DMO migrations.
Upgrade SAP HANA with version, patch, and revision upgrade scenarios using HDBLCM. Manage uptime, downtime, prerequisites, backups, and licensing.
Explore backup strategies for multitenant SAP HANA, planning independent backups for system and tenant databases with full, differential, incremental, and log backups and recovery scenarios.
Learn to configure SAP HANA database backups using studio or cockpit, including complete, differential, and incremental backups, with scheduling, log backups, and backup catalogs.
Explore SAP HANA database recovery with full, delta, and incremental backups, log backups, and point-in-time options to reach the most recent consistent state or a specific time.
SAP HANA system administrators are responsible for installing and ensuring continuous operation of all SAP HANA databases deployed in the corporate environment. Proper management of SAP HANA requires a solid understanding of its internal mechanics to interpret the metrics that are monitored and their impact on system and application performance, as well as its administration and tooling capabilities to plan and execute a suitable database management strategy.
In this course, we’ll learn about the different tasks available to manage SAP HANA systems, with all administration tool, including SAP HANA cockpit web-based tool. We’ll examine the operations offered for both individual and multiple database administration, resource monitoring, configuration management and backup and recovery. We’ll also explore factors that affect performance, such as analyzing memory usage, SQL statements, and workloads.
Course also covers installation of SAP HANA, HANA replication server installation and configuration. This course uses demonstrations to highlight key aspects, and hands-on exercises to reinforce learning points.
Highlights :-
· Preparations of HANA Installation
· HANA Installation & Post Installation Tasks
· SAP HANA Architecture
· SAP HANA Cockpit 2.0
· SAP HANA Scenarios and Deployment Options
· Tools & Database Administration
· Backup and Recovery
· Managing Multitenant Database
· SAP HANA High Availability & SAP HANA Disaster Tolerance
· SAP HANA Fault Tolerance
· SAP HANA System & Proactive Monitoring