SQL Basics for HANA
- Product type
SQL Basics for HANA
Provider rating:
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
- 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…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
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
- 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 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.