SAP HANA SQL Script – First Steps
Hello all to the very first SAP HANA SQL Script specific tutorial post. In this post, we talk about what SQL is, how it is relevant in HANA development and if it is as hard as it appears to be.
Over the years, while working on different developments in SAP, the one constant I always found funny was that whenever I had a screen open with some random lines of code open, anyone who saw me looked at me as a genius. Coding is a fear that many SAP back end developers carry around without ever facing it. Through my series of tutorials, I intend to present SQL of HANA in a simple and fun way to my audience so that you can finally see how handicapped you currently are how powerful you can become with the knowledge of SQL. Trust me with your time and patience and I assure you of excellence.
What is SAP HANA SQL Script now?
To anyone new to technology, let’s talk about what SQL really is. SQL stands for Structured Query Language and is used to communicate with the database. It’s a language that relational databases understand. So if you want to ask a school’s database to provide you the list of students from the sixth grade with attendance less than 50%, all you need is a simple SQL request to get the data. Such requests are called “Queries”. Similarly, there are different type of commands for different purposes – to add data to the tables in database, to change data, renaming tables and many more.
With my enterprise HANA tutorials, you will see that you don’t need to code to create most views and tables in HANA. You have a simple graphical interface to drag and drop and create the logic you need. But there are some times where it’s more flexible to create an HANA object with SQL and I personally find it more fun to do so. Plus sometimes, performance issues cause developers to switch to SQL also as it gives you the ultimate power to run a SQL query in the best way you feel fit. Whenever you use a standard graphical logic without coding, you allow the software to decide the best path of execution (which is never a bad thing as usually it knows the optimal way) but if softwares were perfect, you and I would be looking for other lines of work.
Bottom-line is that SQL makes gives you the raw power to do amazing things and by choosing to be afraid, you let go of an opportunity to excel at your craft.
Can you pick up HANA SQL with no coding experience?
I started learning SQL from scratch starting with basic statements working all the way up to complex queries and that will be how I structure this tutorial – just the way I picked it up. Again, with ample amount of time, practice and regularly reading these tutorials, I assure you that you will be a great SQL coder in no time.
Be sure to help this website grow by using the share buttons to spread this post on social media. This will also keep me motivated to write more.
Watch out for more tutorials coming soon.
Goodbye for now future SQL Experts!SAP HANA SQL Script