logo
Home

HA150 SAP HANA SQL and SQLScript for SAP HANA

  • CMDBID 102630
  • Course Code HANA,SAP,HA150,SQL
  • Duration 2 Days
Scroll

SAP Course

course overview

Click to View dates & book now

Overview

In order to maximize the performance of data models and applications running on SAP HANA, it is essential that all data related tasks are programmed at the database level. The language used is SQL and its very special extended variant called SQL Script. This short course covers programming with SQL and SQL Script on the SAP HANA database and includes all key areas for writing efficient declarative and imperative code. You will also be guided on the use of recommended approaches.

This course assumes students already have a basic knowledge of standard SQL and the focus is on SQL Script. But the course does include excellent and comprehensive coverage of standard SQL in the appendix for those who need to start from the very beginning. The appendix content will not be covered in class and is for offline use only.

This course is based on SAP HANA 2.0 and uses Web IDE / XSA but is useful for customers working with SAP HANA 1.0 using Studio / XS.

This course is based on software release:

  • SAP HANA 2.0 SPS 03

Audience

  • Application Developer
  • Data Modeler
  • BI/BW Consultant
  • Data Scientist
  • Database Administrator
  • SAP HANA Support Personnel

Skills Gained

This course will prepare you to:

  • Push down data intensive tasks to the SAP HANA database using SQL and SQL Script
  • Understand how to code using advanced SQL Script techniques
  • Follow recommended practices for writing optimal SQL and SQL Script
  • Debug and analyze SQL and SQL Script code

Prerequisites

Essential

  • Previous knowledge of ANSI-92 SQL

Recommended

  • HA100 SAP HANA Introduction

The supply of this course by DDLS is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Outline

  • Getting Started
  • SQL Logic Containers
  • Imperative Logic
  • Transactional Savepoints
  • Analytic Operations
  • Working with Hierarchies
  • Troubleshooting and Best Practices
  • What is SQL and SQLScript?
  • Understanding how ABAP developers work with SQLScript
  • Understanding XS Advanced and HDI
  • Working with Web IDE for SAP HANA
  • Understanding the course data
  • Creating user-defined functions
  • Creating database procedures
  • Trapping errors in SQLScript
  • User defined libraries
  • Using declarative logic
  • Using imperative logic
  • How to implement transactional savepoints
  • Using OLAP Analytic features
  • Implementing Temporal Tables
  • Tools for troubleshooting
  • Best Practices

Appendix: Starting from the beginning with SQL fundamentals

Talk to an expert

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. Its a cost effective option. One on one training can be delivered too, at reasonable rates.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

All $ prices are in USD unless it’s a NZ or AU date

SPVC = Self Paced Virtual Class

LVC = Live Virtual Class

Please Note: All courses are availaible as Live Virtual Classes

Trusted by over 1/2 million students in 15 countries

Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well as public sector institutions such as the Department of Defence and the Department of Health.