SQLScript for SAP HANA (Second Edition) (SAP PRESS) - Hardcover

Jörg Brandeis

Hardcover

ISBN 10: 1493221396 ISBN 13: 9781493221394

Publisher: SAP Press, 2021

Synopsis

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 this title

About the Author

Jörg Brandeis is 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.

Edition details

• Publisher: SAP Press
• Publication date: 2021
• Language: English
• ISBN 10: 1493221396
• ISBN 13: 9781493221394
• Binding: Hardcover
• Edition number: 2
• Number of pages: 409