Search Training
X

HA150 SAP SQL Basics for HANA

Course Overview

This course refreshes your SQL knowledge and enables you to use advanced SQL techniques for querying and manipulating data in SAP HANA database.

Who Should Attend

Application Consultants with focus on modeling and Developers

Course Outline

1 - Module 1

  • Motivation & Basic Concepts

2 - Module 2

  • Reading from a table or view

3 - Module 3

  • SELECT Clause

4 - Module 4

  • Functions

5 - Module 5

  • Tuple Variables

6 - Module 6

  • Case Expression

7 - Module 7

  • Duplicate Elimination

8 - Module 8

  • Sorting

9 - Module 9

  • WHERE Clause

10 - Module 10

  • Aggregate Expressions

11 - Module 11

  • Grouping

12 - Module 12

  • Reading data from multiple tables or views

13 - Module 13

  • Union and Join

14 - Module 14

  • Sub Queries

15 - Module 15

  • Changing database access

16 - Module 16

  • INSERT, UPDATE, DELETE statements

17 - Module 17

  • Data definition and access control

18 - Module 18

  • Data Types

19 - Module 19

  • CREATE, ALTER, DROP table

20 - Module 20

  • Renaming Columns

21 - Module 21

  • Views

22 - Module 22

  • Granting and Revoking privileges

23 - Module 23

  • Access Paths and Indexes

24 - Module 24

  • Database transactions

25 - Module 25

  • COMMIT, ROLLBACK

26 - Module 26

  • Multi-user mode and synchronization

27 - Module 27

  • NULL values

Enroll Today

This is a 2-day class

Price: $1,500.00
Payment Options

ILT Instructor‑Led Training

OLL Online LIVE

GTR  Guaranteed to Run

Class times are listed Eastern time. This class is available for Private Group Training

To sort by location or date, click the ‘When’ and ‘Where’ column headings.

Class dates not listed.
Please contact us for available
dates and times.