SQL Basics for HANA

HA150 2 days

Classroom

SQL Basics for HANA

Delivery:
Classroom
Country:
Display Language:
Spanish
Rating:
Insufficient data for accurate rating at this time.

Goals

  • This course refreshes your SQL knowledge and enables you to use advanced SQL techniques for querying and manipulating data in SAP HANA database.

Audience

  • Application Consultants with focus on modeling
  • Developers

Prerequisites

Essential

  • Basic knowledge of SQL/Open SQL

Recommended

  • None

Course based on software release

  • SAP HANA 1.0 SPS05 (Revision 45)

Content

  • Motivation & Basic Concepts
  • Reading from a table or view
  • SELECT Clause
  • Functions
  • Tuple Variables
  • Case Expression
  • Duplicate Elimination
  • Sorting
  • WHERE Clause
  • Aggregate Expressions
  • Grouping
  • Reading data from multiple tables or views
  • Union and Join
  • Sub Queries
  • Changing database access
  • INSERT, UPDATE, DELETE statements
  • Data definition and access control
  • Data Types
  • CREATE, ALTER, DROP table
  • Renaming Columns
  • Views
  • Granting and Revoking privileges
  • Access Paths and Indexes
  • Database transactions
  • COMMIT, ROLLBACK
  • Multi-user mode and synchronization
  • NULL values

Popular tags

No tags submitted for this course yet

Share this course: Print