HA 150 SQL Basics for SAP HANA

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

RELATED: HA 150 HANA SQL Course What you 'll Learn

HA 150 Hana 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
Tags: HA150, HA150 pdf download, HA 150 hana course material, HA 150 SQL Basics for SAP HANA
Share this article :

Post a Comment

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