This course provides students with basic SQL knowledge or refreshes their SQL knowledge, and enables them to use basic and some advanced SQL techniques for querying and manipulating data in an SAP HANA database.

starstarstarstarstar_half

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

This course will prepare you to:
Push down data intensive tasks to the SAP HANA database using SQL and SQLScript
Understand how to code using advanced SQLScript techniques
Follow recommended practices for writing optimal SQL and SQLScript
Debug and analyze SQL and SQLScript code

1

  • Getting Started

  • 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
2

  • SQL Logic Container

  • Creating user-defined functions
    Creating database procedures
    Trapping errors in SQLScript
    User defined libraries
3

  • Declarative Logic

  • Using declarative logic
4

  • Imperative Logic

  • Using imperative Logic
5

  • Transactional Savepoints

  • How to implement transactional savepoints
6

  • Analytic Operations

  • Using OLAP Analytic features
    Implementing Temporal Tables
7

  • Working with Hierarchies

  • Working with Hierarchies
8

  • Troubleshooting and Best Practices

  • Tools for troubleshooting
    Best Practices
9

  • Appendix

  • Starting from the beginning with SQL fundamentals

Audience

This course is for those whose job role could be Application Developer, Data Modeler, BI / BW Consultant, Data Scientist, Database Administrator, SAP HANA Support Personnel.

Language

English

Prerequisites

Previous knowledge of ANSI-92 SQL HA100

$2,601

Length: 3.0 days (24 hours)

Level:

Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.

Loading...