SAP - Course Details

SQLBSAPHANA(HA150) SQL Basics for SAP HANA (HA150)

SAP Course Description:
This course refreshes your SQL knowledge and enables you to use advanced SQL techniques for querying and manipulating data in SAP HANA database.
SAP Course Duration:
2 DAYS
SAP Course Target Audience:
Application Consultants with focus on modeling,Developers
SAP Course Prerequisite:
Basic knowledge of SQL/Open SQL
Course Content:
  • Motivation & Basic Concepts

  • Reading from a table or view 
       -SELECT Clause 
       -Functions 
       -Tuple Variables 
       -Case Expression 
       -Duplicate Elimination 
       -Sorting 
       -WHERE Clause 
       -Aggregate Expressions 
       -Grouping

  • Reading data from multiple tables or views 
       -Union and Join 
       -Sub Queries

  • Changing database access 
       -INSERT, UPDATE, DELETE statements

  • Data definition and access control 
       -Data Types 
       -CREATE, ALTER, DROP table 
       -Renaming Columns 
       -Views 
       -Granting and Revoking privileges 
       -Access Paths and Indexes

  • Database transactions 
       -COMMIT, ROLLBACK 
       -Multi-user mode and synchronization

  • NULL values