Read Anywhere and on Any Device!

Subscribe to Read | $0.00

Join today and start reading your favorite books for Free!

Create Free Account

SAP HANA 2.0 SPS04 - SQL and SQLScript for SAP HANA

0/5 ( ratings)

Goals

This course will prepare you to:
Push down data intensive tasks to the SAP HANA database using SQL and SQL Script
Understand how to code using advanced SQL Script techniques
Follow recommended practices for writing optimal SQL and SQL Script
Debug and analyze SQL and SQL Script code

Audience
Application Developer
Data Modeler
BI / BW Consultant
Data Scientist
Database Administrator
SAP HANA Support Personnel

Content
Getting Started
What is SQL and SQL Script?
Understanding XS Advanced and HDI
Working with Web IDE for SAP HANA
Understanding the course data
SQL Logic Containers
Creating user-defined functions
Creating database procedures
Trapping errors in SQL Script
User defined libraries
Declarative Logic
Using declarative logic
Imperative Logic
Using imperative Logic
OLAP Operations
Using OLAP Analytic features
Working with Hierarchies
Working with Hierarchies
Troubleshooting and Best Practices
Tools for troubleshooting
Best Practices
Appendix: Starting from the beginning with SQL fundamentals.

Pages: 534

Format: Kindle Edition

Release: September 17, 2019

SAP HANA 2.0 SPS04 - SQL and SQLScript for SAP HANA

0/5 ( ratings)

Goals

This course will prepare you to:
Push down data intensive tasks to the SAP HANA database using SQL and SQL Script
Understand how to code using advanced SQL Script techniques
Follow recommended practices for writing optimal SQL and SQL Script
Debug and analyze SQL and SQL Script code

Audience
Application Developer
Data Modeler
BI / BW Consultant
Data Scientist
Database Administrator
SAP HANA Support Personnel

Content
Getting Started
What is SQL and SQL Script?
Understanding XS Advanced and HDI
Working with Web IDE for SAP HANA
Understanding the course data
SQL Logic Containers
Creating user-defined functions
Creating database procedures
Trapping errors in SQL Script
User defined libraries
Declarative Logic
Using declarative logic
Imperative Logic
Using imperative Logic
OLAP Operations
Using OLAP Analytic features
Working with Hierarchies
Working with Hierarchies
Troubleshooting and Best Practices
Tools for troubleshooting
Best Practices
Appendix: Starting from the beginning with SQL fundamentals.

Pages: 534

Format: Kindle Edition

Release: September 17, 2019

More books from SAP Publishing

SAP HANA 2.0 SPS4 - Installation and Administration

SAP Analytics Cloud 1911 for Planning - Advanced Planning: SAP Analytics Cloud with special view on planning functionalities.

Rate this book!

Write a review?