After completing this course, you as an SAP HANA database administrators will be able to install, upgrade, configure, monitor, and operate an SAP HANA database system. You will be able to use the SAP HANA administration tools like SAP HANA cockpit, database explorer, and hdbsql to perform the daily system administration tasks on the SAP HANA database system.
AI Engineer - Learn how to integrate AI into software applications
Learn Backend Development Part-Time, Online
Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Syllabus
- Discovering SAP HANA
- Identifying the Need for SAP HANA
- Illustrating the Need for In-Memory Technology
- Discovering SAP HANA
- Preparing the Installation
- Performing SAP HANA Sizing
- Identifying Supported SAP HANA Hardware
- Identifying the Linux Operating System Requirements
- Outlining how to use the Hardware Measurement Tool
- Preparing the Installation
- Installing the SAP HANA Database System
- Installing SAP HANA 2.0
- Describing Advanced Installation Options
- Illustrating Deployment Options
- Installing the SAP HANA Database System
- Installing the SAP HANA Cockpit
- Illustrating SAP HANA Administration Tools
- Installing SAP HANA Cockpit
- Describing the SAP HANA Cockpit Architecture
- Configuring SAP HANA Cockpit
- Updating SAP HANA Cockpit
- Installing the SAP HANA Cockpit
- Performing the Post-Installation Tasks
- Illustrating Post-Installation Steps
- Updating SAP HANA
- Illustrating the Resident HDBLCM
- Creating, Renaming, and Deleting a Tenant Database
- Explaining the Revision Strategy of SAP HANA
- Using the SAP HANA HDBSQL Command-Line Tool
- Performing the Post-Installation Tasks
- Working with Database Explorer
- Using Database Explorer
- Importing and Exporting Database Content
- Displaying Table Information
- Using the SQL Console
- Using the SAP HANA Statement Library
- Working with Database Explorer
- Monitoring using SAP HANA Cockpit
- Locating Databases in SAP HANA Cockpit
- Checking the SAP HANA Services
- Checking the Memory Usage
- Checking the SAP HANA Persistence Storage
- Checking for SAP HANA Alerts
- Checking the SQL Statements
- Monitoring using SAP HANA Cockpit
- Administering using SAP HANA Cockpit
- Starting and Stopping SAP HANA
- Changing Database Configuration Parameters
- Describing Further Configuration Functions
- Describing the Concept of Delta Merge
- Working with SAP HANA Traces
- Administering using SAP HANA Cockpit
- Performing Backup and Recovery
- Describing Backup and Recovery
- Performing Data Backups
- Scheduling Data Backups
- Configuring Log Backups
- Performing Database Recovery
- Describing Additional Backup Topics
- Illustrating Advanced Backup and Recovery Techniques
- Creating a Fallback Snapshot
- Identifying Database Copy Scenarios
- Performing Backup and Recovery
- Describing SAP HANA Security Features
- Illustrating the SAP HANA Security Functions
- Describing Encryption
- Setting Up Auditing
- Describing SAP HANA Security Features
- Performing User and Authorization Maintenance
- Describing SAP HANA Authentication and Authorization
- Describing SAP HANA Privileges and Roles
- Managing Users
- Managing Groups
- Describing Information Sources for Administrators
- Performing User and Authorization Maintenance
- Describing SAP ABAP Systems on SAP HANA
- Illustrating SAP ABAP Systems on SAP HANA
- Describing SAP ABAP Systems on SAP HANA