SAP - Course Details

SQLBHANA(HA150) SQL Basics for 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