SQLScript for SAP HANA, Second Edition
- 5h 30m
- Jörg Brandeis
- Rheinwerk Publishing Inc.
- 2021
New to SQLScript—or maybe looking to brush up on a specific task? Whatever your skill level, this comprehensive guide to SQLScript for SAP HANA is for you! Master language elements, data types, and the function library. Learn to implement SAP HANA database procedures and functions using imperative and declarative SQLScript. Integrate with ABAP, SAP BW on SAP HANA, and SAP BW/4HANA. Finally, test, troubleshoot, and analyze your SQLScript programs. Code like the pros!
- Learn SQLScript syntax and run your first routine in the SQL console
- Read and write to the SAP HANA database
- Integrate SQLScript with ABAP, SAP BW powered by SAP HANA, and SAP BW/4HANA
Language Elements
Learn about the key elements of SQLScript, from NULL values to the inner workings of SELECT statements. Walk though both declarative and imperative programming in SQLScript.
Database Elements
Change the contents of database tables using SQL statements. Learn how to create tables and other database objects directly, and delete and edit them as needed.
SQLScript in Practice
Work with detailed code examples to see concepts in action as they are introduced. Get insight into SQLScript with hundreds of line of code that have been tested in a live SAP HANA system.
- SAP HANA Studio
- SAP HANA Web-Based Development Workbench
- SAP Web IDE
- SQL console
- Language basics
- Declarative and imperative programming
- Data types
- Database programming
- ABAP-managed database procedures (AMDP)
- SAP BW and SAP BW/4HANA
- Clean code
- Troubleshooting and analysis
About the Author
Jörg Brandeis is the managing director of Brandeis Consulting GmbH in Mannheim, which offers training and consulting for SAP BW/4HANA, SAP HANA and SQLScript. Until mid-2015, Mr. Brandeis worked as head of development at zetVisions AG in Heidelberg, where he was responsible for the development and architecture of the SAP NetWeaver-based products zetVisions CIM and SPoT. In this role, he worked extensively with agile development methods and clean code.
In this Book
-
Introduction
-
SAP HANA
-
Getting Started with SQLScript
-
Declarative Programming in SQLScript
-
Data Types and Their Processing
-
Write Access to the Database
-
Imperative Programming
-
Creating, Deleting, and Editing Database Objects
-
SQLScript in ABAP Programs
-
SQLScript in SAP Business Warehouse
-
Clean SQLScript Code
-
Tests, Errors, and Performance Analysis
