SAP BASIS R/3 & HANA Administration Training Course

Full Life Cycle End to End Implementation Course in Dubai

SAP BASIS—the underlying system software that forms an effective platform for customer and module specific applications, is typically a middleware program. It bridges the gap between the SAP computational architecture, its network and operating system; and the other modules like those linked with accounting, finance, quality management and so forth. SAP BASIS includes RDBMS, GUI and other powerful components for system administration.
This module describes the various fundamentals of SAP system administration and is an effective technology that provides the necessary support for SAP applications, system administration and memory management. BASIS emphasizes upon the administration of RDBMS (Relational Database Management System) or any other database used by the SAP environment, client-server architecture as well as the SAP GUI.
It is a definition of the interface between BASIS and system components; user/ system administration; and varied monitoring tools. It includes the data dictionary and a scalable development platform for SAP based applications too.
SAP BASIS is a very popular SAP module among graduates of all disciplines

Mode of Training:


Live Instructor Led

Self Paced Video

Appearance Criteria

SAP BASIS is a very popular SAP module among graduates of all disciplines. Candidates with prior knowledge of IT and other computer handling skills are obviously in a more advantageous position in the program.
MCAs, Bachelors in Computer science and students belonging to the engineering stream are generally preferred for this course.
Though prior SAP system hands -on experience and familiarity with the SAP working environment is not essential, it certainly helps.
Those targeting job profiles of a SAP BASIS administrator require a good knowledge base in system administration; with a university degree being an additional boon. Along with in – depth knowledge of system administration tools in diverse platforms like Linux or Windows; perspective candidates boasting of DBA skills, SAP Basi c certification and basic knowledge in other allied fields can look forward to lucrative job positions too.

Our SAP BASIS Trainers Profile


SAP Certified BPC, HANA or FI Solution Architect Trainer
20+ Years of Experience among which 12 years of experience as a Business Analyst, Techno-Functional Consultant and Trainer across varied Industries (Government – State and Federal, Service Sector, Manufacturing and Heavy Industry) in US/Europe/Australia/Malaysia/Thailand/India. He has also worked with SAP EPM, FI Implementation, BPC and Disclosure Management. He is an Core member of FRICEW teams on business requirements gathering, FIT-GAP business analysis, system design and architecture, and development, customization, testing, and support areas of enterprise-wide applications on SAP products. He also has well developed skills in – Budgeting (operating, cash and capital), Reporting (management and statutory) and Financial Management and Planning acquired during professional accounting and CPA program study and further developed while working.


CERTIFIED SAP PROFESSIONAL, SAP Basis, HANA, BW, GRC, Solman and Security Trainer/Architect
SAP Trainer for AS JAVA, ABAP, HANA, ORACLE, SYBASE ASE, SOLMAN administration and upgrade courses ADM100, ADM200, ADM800, ADM315, ADM325, ADM326, ADM328,HA100, HA200, GRC100, GRC300. BW310, BW360
SAP Trainer for Security and Audit ADM940, ADM950, ADM960 Courses.
SAP Trainer for Netweaver / Basis Administration TADM10, TADM12 Courses.
SAP Trainer for OS/DB Migration TADM70 Courses.
SAP Trainer for Database TADM51 and TADM56 Courses.
SAP trainer for End to End Solution E2E040, E2E060, E2E100 and E2E200 Courses.
SAP Trainer for Solution Manager SM100, SM200, SM300, SM400, SM500 Courses.
He has conducted Training in all the major cities around the World.

Key Difference in our SAP BASIS Training

Apart from our long experience in assisting professionals acquire their desired SAP position, unlike our competitors in this field of SAP training and certification, we will also provide you with a free 2 month access to an SAP cloud server to apply your newly gained knowledge.

Experienced & Professional Trainers
Certification Questions & Answers

Assingments & Case Studies

Confiquration Materials Soft-Copy
Free 60 Days Cloud Server Access

Recorded Session Videos

Upcoming Batch Schedules

Training Type Start Date Course fees
Blended – Classroom + Online 16.6.2017 AED 4999 Join Online
Live Instructor-Led Online 16.6.2017 AED 4499 Join Online
Online Video Training Self Paced AED 1999 Join Online

To know more visit our Free Seminar on Career’s in SAP
sap HANA course in dubai

SAP BASIS Training Course Content

  • Overview
  • An introduction to BASIS

    An introduction to Operating Systems
  • An introduction to Database Systems
  • Overview of computer Networks
  • Network types & devices
  • Protocol & IP Address concepts
  • An introduction to Kernel Software

  • Client / Server Solution
  • Overview of 3 layer interface
  • Types of Client / Server Architectures
  • An introduction to R/3

  • Presentation Interface
  • Application interface
  • Database interface
  • Overview of R/3 Architecture
  • Overview of Dispatcher & Work Processes
  • Concept of SAP Instance

  • Overview of Software Development
  • Overview of SAP Landscape
  • Landscape types
  • Lifecycle Implementation concepts


  • Elements in SAP R/3 installation
  • Installation requirement
  • System sizing
  • Installation of File Systems
  • Installation of RDBMS
  • Installation of SAP Installation tools
  • Install central instance
  • Load Database
  • Installation Database
  • Installation of Presentation Layer
  • Post installation Activities

  • Start & Stop SAP R/3 Server, Directory Structures
  • Overview of SAP MMC
  • SAP & Oracle Environment Variables
  • SAP Logon Pad configuration
  • Overview of SAP License system
  • Overview of Transaction & Dialog step

  • Overview of user Administration
  • Managing User Master Records
  • Managing User Groups
  • Mass User Management
  • Maaging Logged on Users
  • Central User Administration

  • Overview of System Profiles
  • Overview of Operation Modes
  • Overview of Background jobs
  • Overview of Log-on Load Balancing
  • Overview of Memory Management
  • Overview of workload monitor
  • Overview of OS Collector
  • Overview of Performance Management
  • Overview of alert monitoring
  • SAP system Pro-Active Health checks

  • Overview of Authorization System
  • Maintaining Authorizations
  • Working with Profile Generator
  • Creating Roles, Maintaining Org. Levels
  • User Information System
  • Overview of Users & Authorization Tables
  • System Profile Parameters for User

  • Overview of R/3 client
  • Client Copy methods
  • Client copy Requirements & Process
  • Open / Close R/3 Client
  • Overview of RFC
  • Deleting R/3 Client
  • Client Refresh
  • Copying DB Tables among clients
  • The Transport System
  • Overview of change Transport System

  • System Change Options
  • Working with Change and Transport Organizer
  • Overview of transport Management System
  • Configuring Systems and Domains
  • Configuring Transport Routes
  • Distributing and Verifying configuration
  • Overview of TP & R3trans
  • Performing Transports with TP Program
  • Overview of the Complete Process of Transporting

  • SAP Spool system Architecture
  • Introduction to SAP Access Methods
  • Defining R/3 Printer Devices
  • managing spool Requests
  • The SAPLPD Driver Program
  • EMSE object Databas
  • Troubleshooting printing problems

  • Overview of Support Packages
  • Plug-ins & Add-ons
  • Types of Support Packages
  • Downloading Support Packages
  • Support pack Dependencies and Requirements
  • Applying Support Packages
  • Plug-ins & Add-ons
  • SAP R/3 Kernel Upgrade

  • Introduction to Oracle Database Architecture
  • Oracle Directory structure for R/3
  • Overview of physical & Logical Layer
  • Introduction t o Cost – Based Optimizer
  • Introduction to SAPDBA & BRTOOLS
  • Table space Administration
  • Introduction to Database Reorganization
  • Database Backup & Restore & General Activities

  • Monitoring SAP Instances
  • Monitoring System Work Process
  • Managing User Sessions
  • Managing Update Records
  • Managing Lock Entries
  • Managing R/3 System Logs
  • Analyzing ABAP Dumps
  • System Tracing Utilities
  • Managing Batch Input Sessions

SAP BASIS Course Highlights

Classroom Training
Learn from Sap Basis Industry Experts and Prepare yourself for Google certification.
Study Material
Hard Copy of Study Notes
Online Materials
Topic Wise study material in the form of Presentation, Case Studies, Practical Exercises and Quiz or Assignments with detailed answers and explanation.
24×7 Forum
Doubt solving forum to interact with faculty & fellow students.
Assignments & Cases
Work on real time cases from different domains.
24×7 Online Access
24×7 Access to Course Material (Unlocked Excel Models, Presentations, etc)


SAP HANA is a database from SAP built on in-memory technology. SAP HANA usually needs less administration than other databases, HANA Database is 3500 times faster Analytics and 4500 times faster-reporting speed. The SAP HANA Studio is the main GUI tool for SAP HANA Administration Training, so the future would be the HANA database with most of the customers.


Our training covers the full cycle of administration of SAP Hana solutions. The SAP HANA Administration course aims not only imparting theoretical concepts, but also helps students explore and experiment the subject. Each Training Module builds on top of the preceding Module so that the learning process is progressive. The examples given in this training are practical, and you will be able to see the immediate result of your efforts. We will first cover setting up HANA Platform i.e. pre and post installations, Direct extractor configuration and much more, followed by project.
By the end of our training, students can confidently update their profiles with knowledge and Hands
on experience.

SAP HANA Administration Training Curriculum

Getting started with the Overview of the architecture of SAP HANA systems, Creation of HANA Columnar Store and Differentiate between SAP HANA row store vs Columnar Storage.

  • Introduction to SAP HANA SAP
  • In-Memory Strategy
  • HANA compare to BWA
  • In-Memory Computing
  • Hardware-Innovations
  • Software-Innovations
  • SAP HANA simplified and Extended Architecture
  • Business Intelligence Clients with HANA
  • HANA Columnar Store
  • SAP HANA row store vs Columnar Storage

This module focus on various SAP HANA editions, like the SAP HANA Platform Edition, SAP HANA Enterprise Edition and SAP HANA Enterprise Extended Edition which bundles additional components for data provisioning.

  • SAP HANA Platform Edition
  • SAP HANA Enterprise Edition
  • SAP HANA Enterprise Extended Edition

The critical factor for SAP HANA implementation is the right sizing of the server on the business requirement and this means correct calculation of the amount of memory, the CPU processing power. SAP HANA sizing consists of Memory sizing for static data, Memory sizing of objects created during runtime, Disk sizing, CPU sizing.

  • SAP HANA In-Memory Database Sizing elements
  • RAM, Disk, CPU
  • Memory Sizing
  • CPU Sizing
  • SAP HANA Scale Out

What are the steps to be configured during PRE, POST installations of SAP HANA and also gives you a brief overview about it.

  • Preparing SAP HANA Installation
  • Reviewing SAP HANA Installation
  • Post-Installation steps

Understand about Memory computing studio, Switching between different views and about system monitor in HANA.

  • In-Memory Computing Studio
  • Administration view
  • HANA Navigator View
  • System Monitor in HANA
  • Information Modeler

In this module, we will explain about the architecture of HANA, How to apply Backup and Recovery to the entire database and different storage formats in HANA.

  • Architecture Overview
  • IMCE and Surroundings
  • HANA Row Store
  • Column Store
  • Loading data into HANA
  • Data Modeling in HANA
  • Persistent Layer in HANA
  • Backup & Recovery

For SAP HANA several hardware and software requirements need to be fulfilled. I n this module, you can find a complete list of all SAP HANA components and the respective SAP HANA hardware and software requirements.

  • Prepare HANA Installation parameters
  • Users created during HANA Installation
  • HANA Required Installation media
  • Prepare Installer Configuration file

Learn, How to install SAP HANA from GUI as well as from Command prompt and also learn what are the components of HANA.

  • SAP HANA unified Installer, Tool Unified Installer to install the Sap HANA SERVER
  • HANA Components installed by Installer
  • Command based Installation
  • GUI based HANA Installation

By the end of this module, you will get an overview on SAP HANA studio, how the DBA Cockpit works with SAP HANA and also how to execute the SQL statements using HDBSQL command line tool.

  • SAP HANA Studio
  • DBA Cockpit
  • HDBSQL Command Line Tool

Know the system requirements and supported Platforms to install SAP HANA studio.

  • System Requirements
  • Supported Platforms
  • Install SAP HANA Studio

Understand how to monitor HANA Landscape, HANA Security, Start, Stop the HANA system and also know the logging on HANA system.

  • Starting and Stopping SAP HANA System
  • Displaying Process List
  • Logging on to HANA system using HANA studio
  • HANA User Security
  • Monitoring HANA Landscape


Here will focus on Start, Stop SAP HANA Database and also to monitor HANA landscape..

  • Starting & Stopping SAP HANA
  • Starting SAP HANA Database
  • Stopping SAP HANA Database
  • Displaying Process List
  • Monitoring HANA Landscape
  • Periodic Manual Tasks

This session presents you about configuring Steps, Set-up and Architecture for SLT replication server and also about positioning, Different types of benefits of SLT.

  • Positioning and benefit of SLT for SAP HANA
  • Key benefits of Trigger-Based Approach
  • Architecture and building Blocks
  • Architecture for SAP Source Replication
  • Architecture for NON-SAP Source Replication
  • Set-up of LT replication server
  • Installation Aspects
  • Configuration Steps for SLT replication server
  • Setup Data Replication
  • Database-Supportability
  • Landscape strategy of SLT replication server
  • SLT replication server Installation Options
  • Technical Requirements and system setup

In this module, we will provide you, how to configure, Import HANA Studio for Metadata and to Load Data via Data Services into SAP HANA…

  • Configuring HANA Studio for importing Metadata
  • Importing Metadata
  • Mass Import
  • Selective Import
  • Load Data Via Data services into SAP HANA

We’ll give an introduction to SAP HANA Direct Extractor in this module.

  • Introduction to SAP HANA Direct Extractor

Learn, how to enable the services, setup, configuration, and also to provide connections for SAP

  • Limitations of DXC
  • Setup and Configurations
  • Enabling Services
  • HTTP Connection and Test Connection

The identity of database users accessing SAP HANA is verified through a process called authentication. In this module, we’ll provide, how to create users, assign roles – privileges to the users as well as to the roles for SAP HANA Security.

  • Create Users
  • User and Role Concept
  • Creating Roles
  • Assigning Privileges to Roles
  • Privileges
  • SQL Privileges
  • System Privileges
  • Analytic Privileges
  • Reporting Privileges
  • Modeling required Privileges

Backup and restore is the process of copying/storing data pre-emptively for the specific purpose of restoring, that same data can be used for restoration in an event such as loss of data in case hardware failure or accidental deletion or corruption of data.

  • System Configuration Parameters
  • Monitoring and system state parameters
  • Backup & Recovery SAP HANA
  • Need for Backup
  • Backup Types
  • Dalita Backup
  • Log Backup
  • Recovery Options
  • Recovery in Replication Scenarios
  • Backup to External Backup Destinations
  • Recovery Scenarios
  • Power Failure
  • Disk Failure

Learn, How to monitor SAP HANA, Checking the availability of sett ing up, system monitoring, overview of Services and providing system alerts.

  • Configuring Remote Support
  • Solution Manager Integration
  • Remote Service Connection
  • Availability Monitoring
  • Setting up Monitoring
  • System Monitoring Setup
  • Status Overview
  • Services Overview
  • System Load History
  • Disk Usage Details
  • Checking System Configuration
  • Alerts

This module presents, how to troubleshoot performance in SAP HANA and also configuration to manage log file.

  • Regular administration tasks
  • Troubleshooting
  • Analysing performance
  • Auditing SAP HANA
  • Global Audit Configuration
  • Manage Audit Policies
  • Audit Events
  • Audit Trail


To know more visit our Free Seminar on Career’s in SAP
sap HANA online training in dubai

Request Course Brochure and Program Schedule

Note :
We are the only training company in UAE/ GCC Countries to provide one full life cycle End to End Implementation Training. Participants will get hands on experience with full Implementation Knowledge.