180 likes | 257 Views
Learn SAP HANA Administration Training. NBITS provides best Sap HANA Admin Training with real time scenarios for India, USA, USE, Canada, Malaysia, and Bangalore. It can provide online and classroom training by real time industrial expert faculty.
E N D
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
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
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
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
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
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
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
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
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
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
Additional benefits from NBITS • Course Material • Sample resumes and Fine tuning of Resume • Interview Questions • Mock Interviews by Real time Consultants • Certification Questions