Learn HANA® SQL
Learn HANA® SQL, available at $44.99, has an average rating of 3.15, with 52 lectures, based on 70 reviews, and has 1020 subscribers.
You will learn about At the end of the course you will have a strong understanding and practical knowledge about SAP® HANA® This course is ideal for individuals who are SAP Consultants or Architects or Developers or Senior Consultants It is particularly useful for SAP Consultants or Architects or Developers or Senior Consultants.
Enroll now: Learn HANA® SQL
Summary
Title: Learn HANA® SQL
Price: $44.99
Average Rating: 3.15
Number of Lectures: 52
Number of Published Lectures: 52
Number of Curriculum Items: 52
Number of Published Curriculum Objects: 52
Original Price: $199.99
Quality Status: approved
Status: Live
What You Will Learn
- At the end of the course you will have a strong understanding and practical knowledge about SAP® HANA®
Who Should Attend
- SAP Consultants
- Architects
- Developers
- Senior Consultants
Target Audiences
- SAP Consultants
- Architects
- Developers
- Senior Consultants
This one comprehensive course covers all the aspect of HANA® Development to help you when it matter. We have covered all concepts from basics to intermediate to advance in step-by-step, We have covered the details of HANA® Architecture, HANA® Modelling, Procedure, XSJS and XS oData and lot More.
Also, when it comes to HANA® Modeling. We create Logical Containers to hold our Virtual data in views, may it be Attribute Views, Analytical Views, Calculation View or even creating custom calculated column these takes lot of time to search through, and all of these are covered in a detail and simple way with demos in this course. We have given special attention to:
-
Filtering, Selecting , Decision Making, Types, Attributes and measures
-
Attribute Views – Keys Fields Filtering Records and Preview Data
-
Analytical Views – Characteristics, Facts and Dimension Table Overview
-
Analytical Views – Data Foundation and Nodes
-
Analytical Views – Selecting Columns, Joins and Specifying Measures
-
Analytical Views – Calculated Column and Data Preview
-
Calculation Views – Characteristics, Nodes and Types
-
Calculation Views – Adding Data Source, Selecting Column
-
Graphical Calculation Views(GCV)
-
GCV – Join, Union, Projection, Aggregation and Rank
-
GCV – Renaming Nodes, Auto Layout, Keys and Aggregation
-
GCV – Input Parameters, Filtering And Calculated Columns
-
Scripted Calculation Views
And not only this we have given attention to Procedure, XSJS and XS oData. So you would be able to get complete information on:
-
Table types
-
Local temporary tables
-
Scalar Variables and User-defined functions
-
Table User Defined Functions
-
Looping concept inside Procedures
-
Array functions like array aggregation
-
Imperative statement and declarative statement XSJS Service API’s
-
Exposing xs oData Services with Views
All covered in our course in simple to explanation and hands-on manner.
Course Curriculum
Chapter 1: Introduction
Lecture 1: Introduction to the Course
Lecture 2: HANA®-Basics,Architecture,Parallel Processing,Column/Row Storage & Comparison
Lecture 3: HANA® Architecture Overview,Index Server,pre-processor Server, Persistence Layer
Lecture 4: HANA® Architecture Overview , Statistics Server, Name Server and XS Server.
Chapter 2: Getting Access to SAP® HANA® XS With Google® Cloud Platform With Free Trial
Lecture 1: 5 Simple Step to Install HANA on Google® Cloud Platform For Free
Lecture 2: Step 1 and 2 : Create the Google® Account and Select Instance of HANA®
Lecture 3: Step 3 – Select HANA® Configuration on GCP
Lecture 4: Step 4 and 5 – Setup HXEADM and Public IP
Lecture 5: Admin to Developer to Functional Consultant – Switching Hats
Lecture 6: Getting Familiar With with GCP Dashboard
Lecture 7: Eclipse Neon and Setup of the Development Environment
Lecture 8: Add HANA® System to Eclipse Neon and Setup Development Environment
Chapter 3: Week 1 – HANA® Architecture and Native SQL Basics
Lecture 1: HANA® SQL – Basics, SQL DDL Statements Overview and Characteristics of DDL State
Lecture 2: HANA® SQL DDL Statements – Create, Alter, Rename and Drop Statements
Lecture 3: HANA® SQL DML Statement – Insert Statement and Select Statement with clauses
Lecture 4: HANA® SQL DML Statement – Select Statement clauses, Inner, Left Outer and Right
Lecture 5: HANA® SQL DML Statement – Update Statement and Delete Statement with Clauses
Chapter 4: Logical Containers in HANA-Attribute View,Analytical View,CalculationView & More
Lecture 1: Introduction for Week 2 : Logical Containers in HANA® and Views
Lecture 2: Hands-on Excercises for Week 2
Lecture 3: What We Have Covered So Far and Plan for This Week
Lecture 4: HANA® Modeling Basics-Views Basics,Filtering,Selecting,Decision Making
Lecture 5: HANA® Modeling Basics-Data Types in Views, Attributes, Measure & it's Sub-Types
Lecture 6: HANA® Modeling Attribute Views, Characteristics Of Attribute Views & their Types
Lecture 7: HANA® Modeling Attribute Views, Steps to create Attribute Views
Lecture 8: HANA® Modeling Attribute Views, Steps to create Attribute Views, Data Foundation
Lecture 9: HANA® Modeling Attribute Views, Steps to create Attribute Views
Lecture 10: HANA® Modeling Analytical Views & its Characteristics, Facts & Dimension Table
Lecture 11: HANA® Modeling Steps to Create Analytical Views, Attribute View
Lecture 12: HANA® Modeling Steps to Create Analytical Views, Adding Data Foundation & More
Lecture 13: HANA® Modeling Steps to Create Analytical Views, Input Parameters and More
Lecture 14: HANA® Modeling Steps to Create Analytical Views, Calculated Column Creation
Lecture 15: HANA® Modeling Calculation Views Basics,Characteristics,Nodes in CalculationView
Lecture 16: HANA® Modeling Steps to Create Graphical Calculation Views, Join, Union, & More
Lecture 17: HANA® Modeling Steps to Create Graphical Calculation Views, Using Nodes & More
Lecture 18: HANA® Modeling Steps to Create Graphical Calculation Views, Renaming Nodes &More
Lecture 19: HANA® Modeling Steps to Create Graphical Calculation Views, InputParameters&More
Lecture 20: HANA® Modeling Steps to Create Scripted Calculation Views, Steps, Output Columns
Lecture 21: HANA® Modeling Steps to Create Scripted Calculation Views, VAR_OUT, Input var
Chapter 5: HANA® Procedures
Lecture 1: Introduction to HANA® SQL Procedures and User Defined Functions
Lecture 2: HANA® Procedures Introduction For Week 3
Lecture 3: HANA® Procedures Data Types, SQL Logic, Overview Of Steps To Create Procedures
Lecture 4: HANA® Procedures Create Procedures, In-out Parameters, Elements In Procedures
Lecture 5: HANA® Procedures Parameter, Data Types, Filter And Return Table Records
Lecture 6: HANA® Procedures Table Types, Steps To Create Table Types
Lecture 7: HANA® Procedures Table Types, Table UDF, Parameters in Table UDF
Lecture 8: HANA® Procedures Table UDF, Select, Return The Result, How To Use Table UDF
Lecture 9: HANA® Procedures Table UDF, Filtering, Input Parameters, Use Table UDF
Lecture 10: HANA® Procedures Read, Join The Tables, Return The Results
Lecture 11: HANA® Procedures Local Temporary Table, Create Local Tables, Arrays And Function
Lecture 12: HANA® Procedures Arrays And Array Functions
Lecture 13: HANA® Procedures Control Structures, Loops, If Statements, Break and Continue
Lecture 14: HANA® Procedures Scalar UDF, Steps, IN/OUT, Calculations, Returns & More
Instructors
-
CS PRO
Computer Science for Professional -
UI5 Community Network
Experts in Services, Consulting and Education
Rating Distribution
- 1 stars: 8 votes
- 2 stars: 8 votes
- 3 stars: 25 votes
- 4 stars: 16 votes
- 5 stars: 13 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024