SAP HANA SQL Scripting - Step 2
4.0 (1 rating)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
34 students enrolled

SAP HANA SQL Scripting - Step 2

Take your SAP HANA SQL & SQL Scripting skills to next level.
New
4.0 (1 rating)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
34 students enrolled
Created by Time4HANA T4H
Last updated 6/2020
English
Current price: $100.99 Original price: $144.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 8 hours on-demand video
  • 1 article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Advanced SAP HANA SQL & SQL Scripting
  • Real-world problems and steps to solve them.
  • End to end solution on different ETL Models, which you can immediately apply in your project.
  • OLAP, Window partitioning, Triggers, Cursors, CTE, Temporary Tables and many more...
  • SQL part in HANA 2.0: Web IDE, Hierarchies, Libraries, Data masking, Debugging, etc...
  • Extensive list of problems to solve (Practice Marathon)
  • You will feel very confident after completing this course. This course designed in such a way, so that you can use it as a reference in your day to day job.
Requirements
  • Basic understanding of SQL & HANA system. If you are a beginner I strongly recommend to take our "SAP HANA SQL Scripting - Step 1" course
  • Access to SAP HANA System. If you don't have access to HANA system, We'll provide you instructions and resources on how to get a free HANA system for learning purpose.
Description

SAP HANA is one of the highly demanding skill in the market. HANA technology is improving rapidly to meet the customer requirements and many customer started upgrading their existing HANA systems to HANA 2.0 version. You can quickly ramp-up your skills to meet your day to day job demands.

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 solution which you can immediately apply in your project.

  • Window partitioning commands are very powerful. with very few lines of code you can solve great 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 this tool.

  • Hierarchies are long waiting featured from SAP and finally they are introduced in HANA 2.0. Let's crack it.

  • 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.

Probably Time4HANA courses are best in HANA World...!

Who this course is for:
  • Any one who is working in SAP / SAP HANA and willing to improve their SQL skills
  • HANA Developers who is willing to improve their DB skills
  • To get familiar with HANA 2.0 and Web IDE.
  • Need extensive problems to solve and become strong in HANA SQL Scripting
Course content
Expand all 87 lectures 07:57:43
+ How-To's
21 lectures 02:38:35
Transpose a String
05:10
String Aggregation
03:43
SQL Query Order of Execution
03:43
Referencing an Aliased Column in the WHERE Clause
05:44
Common Table Expression (CTE)
14:47
Complex data sorting
03:31
Aggregate before calculate
10:29
Calculate before Aggregate
04:28
Fetching Random Records from a Table
12:41
Data Cleansing with REPLACE_REGEXPR
06:16
Create a table with same structure of other table
08:41
History Table
11:02
Time travel Query
10:39
Identify missing values
08:57
Transforming NULLs into meaningfull
04:12
Casting to decimal issue
04:59
Common records between two tables
03:25
Triggers
12:11
Cleanup procedure using Cursor and Dynamic SQL
11:57
+ SQL in HANA 2.0
16 lectures 01:35:43
Connecting to Web IDE
03:28
Web IDE Overview
04:40
First project in HANA 2.0 using Web IDE
15:10
Connecting to HDI container from HANA Studio
05:34
Creating a new work space in Web IDE
03:50
Column store is default
03:16
CREATE or REPLACE procedure
04:47
WITH ENCRYPTION
02:10
BETWEEN operator & BOOLEAN Type
03:34
SEARCH Operator for Table Variables
03:46
Variable declaration using LIKE
02:18
Create CDS Table
10:12
Create Table Function
09:33
Create Procedure
06:20
Debugging using Web IDE
09:32
Debugging Cont
07:33
+ ETL Modeling
9 lectures 01:30:09
Inventory Snapshot -1 (Introduction)
05:08
Inventory Snapshot -2 (Setup)
07:06
Inventory Snapshot -3 (Procedure creation)
14:06
Inventory Snapshot -4 (Error Handling)
15:51
Delta Load -1 (Introduction)
08:20
Delta Load -2 (Setup)
07:17
Delta Load -3 (Stored Procedure)
09:34
Delta Load -4 (Testing)
11:47
Delta Load -5 (Duplicate records handling)
11:00
+ OLAP & Window partitioning
9 lectures 54:52
Window Functions Introduction
05:40
Row Number ( )
05:34
Rank( ) vs Dense Rank( )
03:32
Second Highest Salary
10:10
Cumulative Totals
06:06
Windows Framing
04:24
Moving Average
07:48
Lead( ) & Lag( )
05:15
Stock price difference
06:23
+ Practice Marathon
32 lectures 01:18:24
Introduction
01:33
Database Setup
03:04
Entity Relationship (ER) Model
01:49
Note
00:08
Countries where customers exist
02:14
Count of Contact titles
01:43
Who is the supplier of each product
01:09
What’s the shipper company name for order ID 10250
01:35
Total number of products in each category
02:18
In which city T4H have maximum number of customers
01:33
Products that need reordering
01:22
Products that need reordering - Cont.
01:31
Customer list by region
03:15
High freight charges
02:11
Employee order details
01:51
Customers with no orders
04:32
Customers with no orders for EmployeeID=4
01:53
High-value customers
03:22
High-value customers with discount
04:27
Month-end orders
01:16
Orders with more line items
03:35
Random orders
01:24
Double entry orders
04:58
Double entry orders - Cont.
02:27
Late order deliveries
02:05
Late orders by employee
01:34
Late orders vs total orders
03:25
Late orders vs total orders – Missing Employee
03:24
Late orders vs total orders – Percentage
03:08
Customer Grouping
03:35
Customer Grouping with percentage
03:14
Customer Grouping with control table
02:49