/
Browse
/
Courses
/
SAP HANA - SQL Script: Basics and Advanced for SAP HANA
/
Analyzing Temporal Tables and SAP HANA Hierarchies
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 3 right to pass this unit.
1.
What are temporal tables?
Choose the correct answer.
Tables that persist only during a session
Tables that support time travel queries
2.
What is the primary reason to not use Dynamic SQL?
Choose the correct answer.
Dynamic SQL requires the use of SQLScript variables.
Dynamic SQL is less flexible in creating SQL statements.
Dynamic SQL is susceptible to SQL injection that can harm the security or integrity of the database.
3.
What are the three types of hierarchy function?
There are three correct answers.
Navigation
Generation
Scalar
Table
4.
The results of a hierarchy generator function can be used only once.
Choose the correct answer.
True
False