Chapter 1. Kickoff – Before We Start
This chapter intends to provide context and background to set the base with which we can manipulate the datasets to be used for data modeling. This section tries to act as a refresher that should help you understand and pick up modeling topics faster in upcoming chapters.
We start the chapter with Structured Query Language (SQL)—how we can use it for controlling and manipulating the SAP HANA database objects and data. Then we move on to create SQLscript and learn how to use it effectively. We will also discuss creation and call of procedure step by step in this chapter, which is a good tool for the upcoming topics. We will end the chapter with a detailed discussion on JOINS and how it can be used for connecting tables in SAP HANA.
After completing this chapter you will be able to:
- Understand and use SAP HANA SQL statements
- Create SQLscript and use it
- Create and call a procedure
- Connect tables using SAP HANA specific JOINS
