HA 150 HANA SQL Course What you 'll Learn

What You Learn in HA 150?
This course refreshes your SQL knowledge and enables you to use advanced SQL techniques for querying and manipulating data in SAP HANA database.

What prereq knowledge you should have to learn HA 150?
Basic knowledge of SQL/Open SQL

Who can Learn  learn HA 150  Course?

  • Application Consultants with focus on modeling
  • Developers

Topics 

  • 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
Tags: SAP HANA HA 150 Course, HA 150
Share this article :

Post a Comment

 
Copyright © 2011. SAP HANA TUTORIALS FREE - S/4 HANA - All Rights Reserved