Course announcements

  • In this course, you will learn about the SAP HANA SQL or refresh your SQL knowledge. We will also take a deep dive into SQLScript and learn how to embed data-intensive application logic into SAP HANA using user- defined functions and database procedures.

Goals

  • This course will prepare you to:
    • Use SQL techniques to query and manipulate data in an SAP HANA database
    • Develop Scalar and Table User-Defined Functions using SQLScript
    • Trap errors in SQLScript, customize error conditions and control program flow to deal with errors
    • Create and use database procedures using SQLScript and understand how to debug them
    • Manage data access control at SQL level
    • Understand database index management
    • Understand database transactions in SAP HANA

Audience

  • Application Consultant
  • Database Administrator
  • Developer
  • Developer Consultant
  • Technology Consultant

Prerequisites

Essential

  • n/a

Recommended

  • n/a

Course based on software release

  • SAP HANA 2.0 SPS 02

Content

  • Motivation and Basic Concepts
    • Understanding SQL and relational model
  • Data from a Table or View
    • Using Data from a Table or View
  • Aggregation of Data
    • Understanding NULL Values
    • Aggregating Data
  • Data from Multiple Tables
    • Understanding Unions, Joins and Subqueries
  • Data Stored in Tables
    • Changing Data Stored in Tables
  • Data Storage
    • Defining How Data is Stored
  • Views for Data Access
    • Using Views for Data Access
  • OLAP Operations
    • Using OLAP Analytic Features
  • SQL Script Functions and Procedures
    • Creating User-Defined Functions
    • Creating Database Procedures
  • Data Access
    • Defining Data Access
  • Database Transactions
    • Explaining Database Transactions

Notes

  • This course is designed for consultants with no/little knowledge of SQL as well as for those who wants to learn about the SQL extension SAP HANA SQLScript.

This course is also available as a test system within SAP Live Access

Learn more