/
Browse
/
Courses
/
SAP HANA - SQL Script: Basics and Advanced for SAP HANA
/
Using Tools and Views for Analysis and Optimization
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.
In which direction are plan graphs read?
Choose the correct answer.
Bottom-up.
Inside-out.
Outside-in
Top-down.
2.
Which of the following are potential causes of SQL performance deterioration?
There are two correct answers.
Use of declarative SQL.
Growth of data over time.
Changes in SAP HANA version.
Queries that use views rather than tables.
3.
Which of the following accurately describes the behavior of SQL hints?
Choose the correct answer.
Hints allow you to directly influence the choice of execution plan.
Hints will always produce a better execution plan than the cost-based optimizer.
If data or usage patterns change after hints are introduced, they will dynamically adjust to retain their intended effect.