Logali Tech
HANA · Logali Books

SAP HANA Cloud: Mastering SQL and SQLScript

A hands-on guide: from your first SELECT to professional SQLScript, working the Logali Tech data right where it lives.

Master native SAP HANA Cloud SQL and SQLScript, with every statement executed against a real HANA database.

Level: Intermediate Prerequisites: Basic SQL.

PDF + EPUB · 15 chapters · 1st edition · ES · EN

$19

Buy the book View preview (PDF)
Who this book is for
  • Developers, analysts, and modelers working directly on SAP HANA
  • Consultants writing performance SQL and SQLScript
  • Data teams consuming HANA from external tools
What you will learn
  • Choose the right types and functions in HANA
  • Query with joins, subqueries, CTEs, and window functions
  • Package logic in views, sequences, and SQLScript procedures
  • Write declarative and imperative SQLScript, functions, and triggers
  • Manage transactions and security
  • Optimize by thinking in columnar storage
Table of contents
  1. 01 Introduction: SAP HANA Cloud and the Power of Native SQL
  2. 02 The LOGALI Data Model and the SQL Console
  3. 03 Data Types: The Raw Material of Queries
  4. 04 Essential SELECT: Filtering and Sorting with Precision
  5. 05 Aggregate and Group: The First Reports
  6. 06 Joins: Uniting the Business Model
  7. 07 Subqueries and CTEs: Questions Within Questions
  8. 08 SQL Functions: Strings, Dates, and Conversions
  9. 09 Window Functions: Analysis Without Losing Detail
  10. 10 Views, Sequences, and Other Objects at the Service of Consumption
  11. 11 Declarative SQLScript: Procedures and Table Variables
  12. 12 Imperative SQLScript: Flow Control, Cursors, and Exceptions
  13. 13 User-Defined Functions and Triggers
  14. 14 Transactions, Consistency, and Security
  15. 15 Performance: Thinking in Columns
About the author

Gheorghe Valer Scurtu — 20+ years on SAP projects in industry, banking, retail, and the public sector. Founder of Logali Tech. He writes the collection he wished he had found.

More about his work
100% to open-hand.org

100% of this book’s price is donated to open-hand.org — Logali covers the payment fee.

How it works

Frequently asked questions

What format do I get?

PDF and EPUB, DRM-free, with immediate download after purchase from your account. Read anywhere: tablet, e-reader, or screen.

Is it in Spanish and English?

Yes. Every title is available in both editions, written with the correct technical vocabulary in each language — not machine-translated.

Are there future updates?

Revisions of the same edition are included: if we fix errata or update code, you receive the new version at no cost.

Where does my money go?

100% of the price is donated to open-hand.org. Logali covers the payment fee, so the donation is complete. We publish a quarterly report.

How is it delivered after purchase?

Card checkout via Stripe. On payment you receive an email with the download links, and they stay available in your logalitech.com account.

The complete collection

08

01

05

02

03

04

06

07

10

11

 Back to the collection

SAP, ABAP, SAP S/4HANA, SAP BTP, SAP HANA, and the other SAP products and services mentioned are trademarks or registered trademarks of SAP SE. They are used for editorial and identification purposes only, with no sponsorship or affiliation with SAP SE.