SAP HANA SQL & SQL Scripting
4.9 (234 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
979 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SAP HANA SQL & SQL Scripting to your Wishlist.

Add to Wishlist

SAP HANA SQL & SQL Scripting

Learn how to develop SAP HANA Database Skills using SQL & SQL Scripting
4.9 (234 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
979 students enrolled
Created by Time4HANA (T4H)
Last updated 7/2017
English
Current price: $10 Original price: $140 Discount: 93% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 11.5 hours on-demand video
  • 1 Article
  • 9 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • SAP HANA SQL & SQL Scripting
  • User Defined Functions
  • Stored procedures
  • Scripted Calculation Views
  • Core Data Services (CDS)
  • Best practices and real world examples
  • SQL part in 'HANA Certification'
View Curriculum
Requirements
  • Access to SAP HANA System
  • If you don't have access to HANA system, I'll provide you instructions on how to get a free HANA system for learning purpose.
Description

*** This is the first comprehensive online course on SAP HANA SQL & SQL Scripting ***

Welcome to comprehensive SAP HANA SQL & SQL Scripting course. You want to learn how to develop SQL skills on HANA? This course is for you. 
It is perfect time to learn HANA technologies. There are lot of requirement for HANA Developers, 
as many SAP clients moving from traditional databases to HANA. This comprehensive tutorial teaches required skills to become HANA SQL Developer.  
This course covers almost all features SQL and SQL Script with real-world example (including Designtime objects and Core Data Services)

Here are few highlights of the course:

  1. Introduce HANA Express Edition (HXE) which is a free HANA Developer version for learning and prototyping purpose.
  2. Walk you through steps to setup your HANA studio for first time.
  3. Key HANA concepts (Row store vs Column store and Delta Merge)
  4. Multiple sample databases created by us for learning and practice
  5. Start with very basic SELECT SQL statements to advanced stored procedures using SQLScripting.
  6. Covers each and every key word of SQL & SQLScripting.
  7. More than 5 ways to create a table.
  8. Imperative and Declarative statements.
  9. Extensive content on SQLScripting.


    1. Scalar UDF's
    2. Table UDF's
    3. Stored Procedures
    4. Scripted Calculation views.
    5. Table Variables, Input Parameters etc..
  10. Provided detailed explanation on best practices to follow and real world examples.
  11. HANA Certification SQL part is covered.
  12. Special features like IDENTITY, Dynamic Filters, Exception handling and many more.
  13. Development objects and Designtime Objects.
  14. Core Data Services (CDS).
  15. By end of this course you will be very confident on SQL & SQLScripting.

As mentioned this is a comprehensive course and we'll keep add the content when new features available as part of new HANA versions.

Please feel free to checkout course content, preview videos and Youtube channel to know more about this course.

Who is the target audience?
  • Any one who is working in SAP / SAP HANA
  • Who wants to start a career with SAP HANA
  • Interest in learning Database Technologies
Students Who Viewed This Course Also Viewed
Curriculum For This Course
64 Lectures
11:14:51
+
Introduction
4 Lectures 35:29

Setup and understand HANA Studio
09:48

Row Store vs Column Store
13:57

Delta Merge
04:46
+
Reading data from a table
17 Lectures 02:18:03
Understanding Sample Data I
06:12

Reading Data
18:47

Comments
06:40

Sorting Data
05:38

Filtering Data (Basic)
08:45

Understanding NULL and NOT NULL
05:25

Filtering Data (Advanced)
12:10

IN Operator
05:29

LIKE Operator
08:59


Calculated columns
10:37


Solution
05:01

Functions
10:03

Aggregating Data
15:21

Exercises
01:07

Solution
00:01
+
Reading data from two or more tables
9 Lectures 01:41:08
Sub Query
13:28

Understanding Sample Data II
01:05

Set Functions
14:37

Cross Join
12:56

Inner Join
19:38

Exercise
02:50

Solution
13:52

Outer Join (+Exercise)
14:55

Solution
07:47
+
Development Objects
14 Lectures 02:47:14
INSERT Data
11:40

UPDATE, UPSERT, DELETE & DROP
11:52

Create Schema
11:16

Data Types
07:49

CREATE Table – Part I
17:53

CREATE Table – Part II
18:17

IDENTITY
16:28

CREATE Table – FORM Based
04:48

Create Table with Reference
10:01

Exercise - Create Table and Insert Data
04:04

Solution – Create Table and Insert Data
17:59

Load data from file
05:33

Changing Tables
14:20

Views using SQL DDL
15:14
+
SQL Scripting
17 Lectures 03:24:30
Introduction to SQL Scripting
04:32

Scalar Functions
14:34

Design Time Object (Scalar Function)
13:11

Exception Handling
11:57


Table Functions
10:17

Dynamic Filter
14:56

Elements of a Stored Procedure
11:34

Stored Procedure
13:20

Table Variables
14:45

Table Type
07:09

Call Procedure ‘WITH OVERVIEW’
10:15

Build Transactions application
19:23


Solution: Data Generator Application
12:54

Scripted Calculation View
16:39

Scripted Calculation View using Input Parameters
11:36
+
Core Data Service (CDS)
3 Lectures 28:26
Create Table – Design time Object: HDBTable
10:11

Create Table – Core Data Services: HDBDD
07:20

Importing data from file using CDS option
10:55
About the Instructor
Time4HANA (T4H)
4.9 Average rating
233 Reviews
979 Students
1 Course
SAP HANA SQL & SQL Scripting

Time4HANA (T4H) develop high quality training courses on SAP HANA Technologies. We are currently focusing on SQL Scripting, HANA Modeling and HANA Certification Courses. SQL is the first building block for any HANA course, that's the reason we started with 'SAP HANA SQL & SQLScripting' course. We are SAP certified HANA consultants/Architects and early adaptors of HANA Technologies. We did 4 HANA migration projects and 7 HANA implementations.