We are back. You can enroll now.
This chapter will help you to setup your HANA studio and core concepts of HANA like column store and delta merge. Also covers about HANA Express Edition (HXE) and prerequisites to setup HXE.
We will discuss about very basic concepts of SQL by focusing on reading data from a single table. This is the perfect place to start your HANA SQL learning journey.
Here we'll focus on reading data from more than one table by using little advanced concepts like joins, sub queries and set operations.
Previous 2 chapters are focused on DQL (Data Query Language). Focus of this chapter is on DDL (Data Definition Language) and DML (Data Manipulation Language). Along with SQL we'll also see how to create a table in graphical way.
You are ready to lean advanced concepts like stored procedures, functions, variables, loops, conditions, etc... We lean about 'Design time objects' and 'Run time objects' which very important in SAP HANA. We'll finish with 'Data Generator' application.
SAP HANA SQL Scripting - Step 1
As you see SAP HANA SQL Scripting - Step 1 course is mainly focused on fundamentals. If you would like to go further on SQL Learning, take a took a SAP HANA SQL Scripting - Step 2 course.
Here are few highlights of the course:
There many more...feel free to checkout course content to know more about this course.