/
Browse
/
Courses
/
SAP HANA - SQL Script: Basics and Advanced for SAP HANA
/
Introducing SQLScript for SAP HANA
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 4 right to pass this unit.
1.
The SQL Console is found in the Development view of the SAP Web IDE for SAP HANA.
Choose the correct answer.
True
False
2.
What is the SAP HANA Deployment Infrastructure (HDI)?
Choose the correct answer.
An isolated environment for storing SAP HANA database runtime objects
A source code versioning framework for SAP HANA source files
A type of application that is built from components developed in multiple languages
3.
When an HDI container is compiled, it produces an XS Advanced container and an XS Classic Container.
Choose the correct answer.
True
False
4.
What is SQLScript?
Choose the correct answer.
A replacement for SQL that provides a more powerful language for developers
A set of extensions on top of standard SQL that leverage the specific features of SAP HANA
An open source version of SQL that is supported by most well-known databases
5.
In the SAP Web IDE for SAP HANA, when you create a new SAP HANA database module, what is added to the mta.yaml file?
There are two correct answers.
A module of type HDB
A route to the SAP HANA database
A service of type com.sap.xs.hdi-container
A service of type OData