Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

SQL Basics for SAP HANA (HA150v11)

GK# 3849 Vendor# HA150v11

Course Overview

TOP

In this course, you will learn the basics of SAP HANA SQL or refresh your SQL knowledge. Additionally, you will learn the basics of SQL script to create user-defined functions and database procedures in SAP HANA.

This course is based on software release SAP HANA SPS11.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP
  • Use basic and some advanced SQL techniques for querying and manipulating data in an SAP HANA database
  • Develop user-defined functions and database procedures using SQL script

Outline

TOP
Viewing outline for:

Classroom Live Outline

Course Outline:

1. SQL and the Relational Database Model

2. Reading Data from a Table or View

  • The SELECT Statement
  • Calculated Columns and Functions
  • CASE Expressions
  • Duplicate Elimination
  • Sorting and Limiting Result Sets
  • The WHERE Clause
  • Aggregating and Grouping Data

3. Reading Data from Multiple Tables or Views

  • Unions, Joins, and Sub Queries

4. NULL Values

5. Changing Data Stored in Tables

6. How Data is Stored Using SQL

7. Creating User-Defined Functions and Database Procedures Using SQL

  • SQL Script Basics
  • Scalar User-Defined Functions
  • Table User-Defined Functions
  • Database Procedures

8. Data Access Using SQL

Who Should Attend

TOP
  • Developer
  • Development consultants
  • Technology consultants
  • Database administrator

Follow-On Courses

TOP
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 2 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 2 day

Request this course in a different delivery format.
Enroll