SQL Basics for HANA

Product type
Logo SAP Training
Provider rating: starstarstarstar_halfstar_border 6.5 SAP Training has an average rating of 6.5 (out of 2 reviews)

Need more information? Get more details on the site of the provider.

Description

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 d…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: SQL & MySQL, PL/SQL, Programming (general), IT Security, and Web Accessibility.

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

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.