/
Browse
/
Courses
/
SAP HANA - SQL Script: Basics and Advanced for SAP HANA
/
Describing Functions and Procedures
Introducing SQLScript for SAP HANA
Differentiating SQL and SQLScript
30 min
Explaining SAP HANA XS Advanced and SAP HANA Deployment Infrastructure
10 min
Describing SAP HANA Deployment Infrastructure
10 min
Describing SAP HANA Database Module
10 min
Working with the SAP Web IDE for SAP HANA
20 min
Quiz
Analyzing Queries
Examining Motivation and Basic Concepts
47 min
Using Data from a Table or View
1 hr 25 min
Interpreting NULL Values
25 min
Aggregating Data
38 min
Quiz
Expanding Queries
Using OLAP Analytic Features
1 hr 26 min
Using Unions
26 min
Using Joins
1 hr 6 min
Using Subqueries
55 min
Quiz
Creating and Populating Tables and Views
Creating and Modifying Tables
46 min
Utilizing Indexes
25 min
Changing Data
41 min
Querying Database Views
30 min
Working with Schemas and Managing Permissions
30 min
Quiz
Identifying the Purpose of Database Transactions and Isolation Requirement
Identifying the Purpose of Database Transactions and Isolation Requirements
1 hr 20 min
Quiz
Implementing Imperative and Declarative Logic
Implementing Imperative and Declarative Logic
1 hr 45 min
Quiz
Describing Functions and Procedures
Describing Scalar and Table User-Defined Functions
45 min
Managing Database Procedures
45 min
Trapping Errors
35 min
Using SQLScript Libraries
25 min
Quiz
Analyzing Temporal Tables and SAP HANA Hierarchies
Working with Cursors and Dynamic SQL
15 min
Working with Temporal Tables
40 min
Analyzing SAP HANA Hierarchies
40 min
Quiz
Using Tools and Views for Analysis and Optimization
Analyzing and Optimizing SQL Using Tools and Views
41 min
Applying Tools and Views
30 min
Mentioning Other Tools
35 min
Quiz
Introducing SQLScript for SAP HANA
Differentiating SQL and SQLScript
30 min
Explaining SAP HANA XS Advanced and SAP HANA Deployment Infrastructure
10 min
Describing SAP HANA Deployment Infrastructure
10 min
Describing SAP HANA Database Module
10 min
Working with the SAP Web IDE for SAP HANA
20 min
Quiz
Analyzing Queries
Examining Motivation and Basic Concepts
47 min
Using Data from a Table or View
1 hr 25 min
Interpreting NULL Values
25 min
Aggregating Data
38 min
Quiz
Expanding Queries
Using OLAP Analytic Features
1 hr 26 min
Using Unions
26 min
Using Joins
1 hr 6 min
Using Subqueries
55 min
Quiz
Creating and Populating Tables and Views
Creating and Modifying Tables
46 min
Utilizing Indexes
25 min
Changing Data
41 min
Querying Database Views
30 min
Working with Schemas and Managing Permissions
30 min
Quiz
Identifying the Purpose of Database Transactions and Isolation Requirement
Identifying the Purpose of Database Transactions and Isolation Requirements
1 hr 20 min
Quiz
Implementing Imperative and Declarative Logic
Implementing Imperative and Declarative Logic
1 hr 45 min
Quiz
Describing Functions and Procedures
Describing Scalar and Table User-Defined Functions
45 min
Managing Database Procedures
45 min
Trapping Errors
35 min
Using SQLScript Libraries
25 min
Quiz
Analyzing Temporal Tables and SAP HANA Hierarchies
Working with Cursors and Dynamic SQL
15 min
Working with Temporal Tables
40 min
Analyzing SAP HANA Hierarchies
40 min
Quiz
Using Tools and Views for Analysis and Optimization
Analyzing and Optimizing SQL Using Tools and Views
41 min
Applying Tools and Views
30 min
Mentioning Other Tools
35 min
Quiz
Knowledge quiz
It's time to put what you've learned to the test, get 5 right to pass this unit.
1.
Table User-Defined Functions can accept any number of input parameters and return any number of table results.
Choose the correct answer.
True
False
2.
What is the recommended approach for creating procedures?
Choose the correct answer.
Define a source file .hdbprocedure in the Development view of SAP Web IDE.
Use the CREATE PROCEDURE statement in the SQL Console.
3.
What is a user-defined library?
Choose the correct answer.
A group of variables, procedures, and functions, which are related.
A repository for storing custom SQL code that is used frequently.
A collection of frequently used input parameters that form part of a test script
4.
Which two statements are correct regarding table functions?
There are two correct answers.
They can have any number of input parameters.
They can return multiple tables.
They must be free of side effects.
They are used in the WHERE clause of a SELECT statement.
5.
Stored procedures must utilize only scalar parameters, or only table parameters.
Choose the correct answer.
True
False
6.
What is the difference between the SIGNAL and RESIGNAL commands?
Choose the correct answer.
RESIGNAL declares an exception to be in effect and SIGNAL does not.
SIGNAL only declares an exception to be in effect by value of :SQL_ERROR_CODE.
RESIGNAL is only used in an EXIT HANDLER and does not declare an exception to be in effect.
SIGNAL only declares an exception to be in effect if it was previously declared as a user-defined condition.