SAP HANA: SQL Basics (HA150)

In this course you can learn the basics of SAP HANA SQL or refresh your SQL knowledge, as well as the basics of SQL Script to create user- defined functions and database procedures in SAP HANA

Retail Price: $1,340.00

Next Date: Request Date

Course Days: 2


Request a Date

Request Custom Course


About This Course

In this course you can learn the basics of SAP HANA SQL or refresh your SQL knowledge, as well as the basics of SQL Script to create user- defined functions and database procedures in SAP HANA

Course based on software release:

  • SAP HANA SPS12

Course Objectives

This course will prepare you to:

  • 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

Course Audience

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

 


Course Outline

  • SQL and the relational database model
  • Reading data from a table or view
    • Calculated Columns and Functions
    • CASE expressions
    • Duplicate Elimination
    • Sorting and limiting result sets
    • The WHERE clause
    • Aggregating and grouping data

 

  • Reading data from multiple tables or views: Unions, Joins and Sub Queries
  • Understanding NULL values
  • Changing data stored in tables
  • Defining how data is stored using SQL
  • Creating user-defined functions and database procedures using SQL

 

    • SQL Script basics
    • Scalar user-defined functions
    • Table user-defined functions
    • Database procedures

 

  • Defining data access using SQL

 



Sorry! It looks like we haven’t updated our dates for the class you selected yet. There’s a quick way to find out. Contact us at 502.265.3057 or email info@training4it.com


Request a Date