Contact Us
Company Name
Contact Person
Email Address or Phone
Detail

Course Code: IVC/SSB
Course Name: Workshop for SQL and SQL Script Basics for SAP HANA (HA150)
Time: 0930 - 1700
Duration: 2 days
Course Fee: HKD 10,000
Location: Lai Chi Kok

Goals

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

Audience

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

Course based on software release

  • SAP HANA SPS12

Content

  • 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

Notes

  • This course has been designed for consultants with no to little prior knowledge of SQL and for consultants who only used the very basic form of the SQL SELECT statement so far.