SAP HANA SQL Scripting - Step 1

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.

Lessons:

• Setup and understand HANA Studio
• HANA eXpress Edition
• Row Store vs Column Store
• Delta Merge

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.

 Lessons: 

• Understanding Sample Data - I
• Reading Data
• Comments
• Sorting Data
• Filtering Data (Basic)
• Understanding NULL and NOT NULL
• Filtering Data (Advanced)
• IN operator
• LIKE operator
• DUMMY Table
• Calculated Columns
• CASE Expression with Exercise
• Solution to CASE Expression
• Functions
• Aggregating Data
• Exercises
• Solution to above

Here we'll focus on reading data from more than one table by using little advanced concepts like joins, sub queries and set operations.

 Lessons: 

• Sub Query
• Understanding Sample Data - II
• Set Functions
• Cross Join
• Inner Join
• Exercise
• Solution
• Outer Join with Exercise
• Solution

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.

 Lessons: 

• INSERT Data
• UPDATE, UPSERT, DELETE & DROP
• Create Schema
• Data Types
• Create Table - Part I
• Create Table - Part II
• IDENTITY
• Create Table - FORM based
• Create Table with Reference
• Exercise - Create Table and Insert Data
• Solution – Create Table and Insert Data
• Load data from file
• Changing Tables
• Views using SQL DDL

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.

 Lessons: 

• Introduction to SQL Scripting
• Scalar Functions
• Design Time Object (Scalar Function)
• Exception Handling
• While Loop
• Table Functions
• Dynamic Filter
• Elements of a Stored Procedure
• Stored Procedure
• Table Variables
• Table Type
• Call Procedure ‘WITH OVERVIEW’
• Build Transactions application
• Exercise: Data Generator Application
• Solution: Data Generator Application
• Scripted Calculation View
• Scripted Calculation View using Input Parameters

 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:

• You will learn about the real-time problems and steps to solve them.
• You learn about different types of ETL modelings. We'll cover end to end solutions, so you can immediately apply in your project.
• Window partitioning commands are very powerful. with very few lines of code you can solve tough challenges.
• Many new features introduced in HANA 2.0. We'll cover new features by using Web IDE instead of HANA Studio, so you'll be more familiar with Web IDE.
• You'll get extensive problems to solve. It'll sharpen your SQL skills. Not just problems, we'll provide solution as well.

There many more...feel free to checkout course content to know more about this course.