SQL Basics for HANA

2 Days

Description

Skills Gained

  • This course will prepare you to: 
       -Use basic and some advanced SQL techniques for querying and manipulating data in a SAP HANA database 
       -Develop user-defined functions and database procedures using SQL Script

 

Who Can Benefit

  • Developer

  • Developer Consultant

  • Technology Consultant

  • Database Administrator

Upcoming Classes

Virtual Classroom Live
December 18, 2017

$1,340.00
2 Days    9:30am EST - 5:30pm EST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

  • 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

Upcoming Classes

Virtual Classroom Live
December 18, 2017

$1,340.00
2 Days    9:30am EST - 5:30pm EST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

  • Essential:
       - None

  • Recommended:
       - None

Upcoming Classes

Virtual Classroom Live
December 18, 2017

$1,340.00
2 Days    9:30am EST - 5:30pm EST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date