SAP Basics & HANA Admin
APEC offers the best SAP Basics and HANA Admin course designed for students and professionals from both IT and non-IT backgrounds across diverse educational fields.
Syllabus
00 – INTRODUCTION TO ERP
- Introduction to SAP R/3
01 – SAP R/3 ARCHITECTURE
- Central System
- Distributed Presentation
02 – SYSTEM LANDSCAPE AND FLOW
- Single System Landscape
- Two System Landscape
- Three System Landscape
- Multi System Landscape
03 – INSTALLATION OF SAP
- Installation Concepts on Windows & UNIX and Quick Sizing
- Naming Convention, Software Kit, SAP Licensing
- Installation Procedure – Windows Application Server for UNIX SAP System
- R/3 Directory Structure, Kernel
04 – Work processes
- Dialog, background, spool, enque, update
05 – OPERATION MODES
- Manual Switching of OP Modes
- Exceptional Mode
- Monitoring
06 – PROFILE MAINTENANCE & PARAMETER SETTING
- System Profile
- Transport Profile
- Client Profile
- Authorization Profile
07 – USER ADMINISTRATION
- Creating and Maintaining Master Records, Architecture
- Logon and Password Security, Protecting Special Users
- Creating and Maintaining Single and Mass Users and User Groups
- Copying, Deleting, Locking/Unlocking Users
08 – CLIENT ADMINISTRATION
- Client Maintenance
- Copying Client within R/3 System (Local)
- Copying client between R/3 Systems (Remote)
- Export/Import
- Protecting Client
- Monitoring and Verifying a Client Copy
- Deleting Client
- Tips and Troubleshooting
09 – TRANSPORT MANAGEMENT SYSTEM
- TMS Terminology and Concepts
- Configuring TMS and Checking Transport Directory
- Configuring Transport Domain, Domain Controller and Group
- Configuring Virtual SAP System and Displaying Configuration
- Including SAP systems in the Transport Domain
- Creating Consolidation and Delivery Routes
- Maintaining SAP Systems without Common Transport Directory
- Configuring External Systems
- Locking and Unlocking TMS for a SAP System
- Deleting SAP System from the Transport Domain
- Deleting TMS Configuration
10 – PERFORMANCE TUNING
- OS, H/W Performance Considerations
- Memory, Management
- R/3 Buffers, Page Buffers, Extended and Heap Memory, PRIV Mode
11 – CHANGE AND TRANSPORT SYSTEM
- Releasing and Transporting Change Request and Tasks
- Customizing, Workbench, Transport Organizer
- Importing Change Requests
12 – SPOOL ADMINISTRATION
- Print related Terminology in OS/SAP Level
- Setting Local, Remote and Front-End Printing
- Logical and Real Spool Server
- Managing Spool Requests using Output Controller
- Connecting Output Devices to Window System
- SAPLPD, TemSE, Authorization
13 – PATCH AND KERNEL ADMINISTRATION
- Checking the Patch, Spam, Kernel Levels
- Downloading Installing Patches, Kernel
- Applying at OS Level, SAPNET, Front-End
- Troubleshooting Various Issues
14 – SPAM & SAINT upgrade
- Sap system patch upgrade
- Add-on installations
- Web-dispatcher & host agent upgrade
15 – SYSTEM MONITORING
- Daily, Weekly, Monthly Tasks
16 – DISTRIBUTED R/3 SYSTEM
- Creating Regular Instance
- Creating Logon Groups for Load Balancing
17 – OSS AND SNOTE CONCEPTS
- How to Use for Different Purposes
- Manually Applying OSS note on SAP Standard Program
18 – DATABASE MANAGEMENT (Oracle)
- Introduction to Oracle
- Oracle Architecture
- Introduction to SAPDBA
- Creating Tables and Table Space Adjustment
- Database Backup, Restore and Recovery
19 – DATABASE MANAGEMENT (Oracle)
- Introduction to Oracle
- Oracle Architecture
- Introduction to SAPDBA
- Creating Tables and Table Space Adjustment
- Database Backup, Restore and Recovery
HANA Administration
UNIT 1: SAP HANA Overview
- Introduction to SAP HANA
- In-Memory Strategy
- SAP HANA components
- SAP HANA Architecture
- SAP HANA versions
- SAP HANA Editions
- Installation of Hana Systems on ERP,CRM,SRM,SCM and Netweaver 7.4
- SAP HANA Landscape
UNIT 2: SAP HANA Sizing
- SAP HANA In-Memory Database Sizing elements
- RAM, Disk, CPU
- Memory Sizing
- CPU Sizing
UNIT 3: SAP HANA Installation
- Perquisites for a SAP HANA installation
- Verify Hardware And Operation System
- SAP HANA Server Installation
- SAP HANA Studio Installation
- SAP HANA Client Installation
UNIT 4: SAP HANA Administration Tool Overview
- SAP HANA Studio
- DBA Cockpit
- HDBSQL Command Line Tool
UNIT 5: System Administration
- Starting and Stopping SAP HANA Systems
- Start a System
- Stop a System
- Restart a System
- Stop and Start a Database Service
- Monitoring SAP HANA Systems During Stop and Start
UNIT 6: Setting Up and Configuring Multitenant Database Containers
- Convert an SAP HANA System to Support Multitenant Database Containers
- Create a Tenant Database
- Adding Single and Multitentant Databases to Hana Studio
- Stop and Start a Tenant Database
- Drop a Tenant Database
- Managing Resources in Multiple-Container Systems
- Migrated Statistics Server into Embedded Statistics Server
- System Views in Multiple-Container Systems
UNIT 7: Managing SAP HANA Licenses
- License Keys
- Check the Current License Key
- Install a Permanent License
- Delete an Existing Permanent License Key
UNIT 8: Managing Tables.
- Column-Based and Row-Based Storage in the SAP HANA Database
- Memory
- Management in the Column Store
- The Delta Merge Operation
- Data Compression in the Column Store
- Opening Tables and Views
- Converted Row Store Tables to Column Store tables
- Viewing Options for Tables and Views
- Export Tables and Other Catalog Objects
- Import Tables and Other Catalog Objects
- Database Save Points
UNIT 9: SAP HANA Pre & Post Installation
- Preparing HANA Installation
- Further Function on SAP HANA On-site configuration Tool
- Post-Installation Steps
UNIT 10: SAP HANA Operation
- Starting and stopping SAP HANA
- Configuring SAP HANA
- Periodic and Manual Tasks
UNIT 11: Backup & Recovery
- Concept of Backup and Recovery
- Configure backup settings
- Data area Backup
- Log area Backup
- Backup of configuration files and Backup catalog
- Backup up of Tenant databases
- Recovery
UNIT 12: 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
UNIT 13: Monitoring and Troubleshooting
- Monitoring with SAP HAN Studio
- Monitoring with DBACOKPIT
- Monitoring HANA Landscape
- System Monitoring
- Status Overview
- Services Overview
- System Load History
- Disk Usage Details
- Checking System Configuration
- Alerts
UNIT 14: SAP HANA Lifecycle Management
- SAP HANA Platform Lifecycle Management
- SAP HANA Application Lifecycle Management
UNIT 15: Advanced HANA
- SAP HANA System Copy
- SAP HANA System Migrations
- SAP HANA Database Upgrade from SP9 to SP10 to SP11
- SAP HANA Addon Deployment
FAQ's
SAP HANA Admin involves managing, configuring, monitoring, and maintaining SAP HANA systems to ensure smooth database performance and system stability.
Students, fresh graduates, IT professionals, system administrators, and career changers can join this course.
Basic knowledge of databases or IT concepts is helpful, but beginners can also start with SAP Basics before moving to HANA Administration.
The course covers SAP basics, HANA architecture, installation, configuration, user management, monitoring, backup & recovery, and performance tuning.
Yes, with proper foundational training, non-IT students can also build a career in SAP HANA administration.
Yes, the course includes hands-on practice with real-time scenarios and industry-based projects.
The course duration typically ranges from 2 to 3 months depending on the batch type and training schedule.
You can work as a SAP HANA Administrator, SAP Basis Consultant, SAP System Administrator, or SAP Technical Support Specialist.
Yes, APEC provides course completion certification and guidance for SAP global certification exams.
Yes, APEC offers resume preparation, interview training, and placement assistance.
Grow Your Career
There’s no shortage of possible career options in IT, and there’s no shortage of opportunities for promotion within specific IT niches. Full Stack Development, Data Science, ML & AI, Digital Marketing, Cloud Computing, Networking and Graphic Design all offer IT career growth and may be just right for you.