Getting Started

• Fast and effective walk through HDBSQL and SQLScript and its special functionalities
• Understanding SAP HANA extended application services and HDI to support SAP HANA development in SQL
• Learn to work with Web IDE for SAP HANA
• Quickly finding the right way to SQL solutions

• SQL Essentials
• SQL Logic Containers
  • Creating user-defined functions
  • Creating database procedures
  • Trapping errors in SQLScript
  • User defined libraries, functions and stored procedures
• Declarative Logic
  • Using declarative logic
• Imperative Logic
  • Using imperative logic if needed
  • How to implement transactional save points
• Working with temporal tables
• OLAP operations
  • Using OLAP analytic features
• Working with hierarchies
• Troubleshooting and best practices
  • Tools for troubleshooting and creating professional performance tuning
  • Best practices and how to reduce code volume while leveraging smart SAP HANA functionalities
• Appendix: Starting from the beginning with SQL fundamentals