/
Browse
/
Courses
/
SAP HANA - SQL Script: Basics and Advanced for SAP HANA
/
Implementing Imperative and Declarative Logic
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 1 right to pass this unit.
1.
What is the purpose of conditional statements in SQLScript?
Choose the correct answer.
To replace the CASEpredicate.
To minimize the opportunities for parallel execution.
To maximize the opportunities for parallel execution.
To allow for the selective execution of specific code blocks.