Learn HANA® SQL

Install HANA on Google Cloud Platform for free with a $300 credit; follow five steps to configure cores, memory, disk, zone, firewall, and admin settings for a HANA system.

Set up a Google Cloud Platform account, enter billing details to activate a $300 free credit, and launch a HANA Express Edition instance via the cloud launcher.

Configure HANA on Google Cloud Platform by selecting zone and memory, choose machine type and disk, manage ports and firewall, then deploy via the deployment manager.

Set the master database password and configure hxeadm, then assign a static external ip and open the required port to access the hana express engine in Google Cloud.

Explore switching between admin, developer, and functional consultant roles while setting up the Google Cloud platform, establishing a development environment with Eclipse, and examining HANA ERP data and MRP concepts.

Learn to navigate the Google Cloud Platform dashboard to manage a Compute Engine virtual machine, monitor external IP and billing details, and set budget alerts for development cost control.

Set up the SFP Hana development environment in eclipse neon, install the required plugins, and configure the workspace for Hana development.

Add a HANA system to Eclipse Neon by configuring Google Cloud Platform VM IP, port 80/90 for test traffic, and connect via SSO to set up the development environment.

Learn HANA SQL basics and the role of data definition language in shaping database structures, including creating tables, primary keys, and managing table definitions.

Create a customers table with primary key customer id in hana sql using ddl commands. Alter the table to add a region column, rename it, and drop it with cascade.

Master HANA® SQL data manipulation language basics, using insert statements to store data and select statements with where clauses to retrieve and filter records, including top n limits.

Learn how to use inner join, left outer join, and right outer join to fetch unique customer records from orders and customers tables.

Learn how to update a customer's phone number using the update statement with a where clause, and delete a customer with the delete statement, verifying results with a select.

Learn how logical containers and views in Hana optimize performance, save development time, and unify techniques for calculated column, input variables, and API efficiency.

Explore HANA database features, covering attribute views and analytical views, then learn the characteristics, types, and steps to create a calculation.

Explore how HANA views project data from underlying tables without storage, enabling selection across multiple tables, filtering records, and reporting to support decision making in HANA modeling.

Explore HANA® modeling basics by understanding data types in views, including simple measures, calculated measures, restricted measures, calculated columns, and local attributes in attribute, analytic, and calculation views.

Learn hana modeling attribute views: understand their characteristics and types—standard, derived, and named attribute views. Discover how to select columns, filter records, join tables, and create calculated columns.

Create hana attribute views by configuring packages and following attribute naming conventions. Join tables with inner, left, right, full, or referential joins and set cardinality.

Learn to build hana attribute views: add tables, join customers and orders on customer id, select columns, create calculated columns (concatenate title and name), validate syntax, and save.

Create and activate HANA attribute views by applying column filters, setting visibility, adding calculated fields, and previewing joined customer and order data to verify results.

Understand HANA analytical views that join a fact table with dimension tables, using various joins and aggregation to compute metrics like total spent, actual price, and attributes and measures.

Learn to create an analytical view in HANA, using an attribute view, define joins and cardinality, select columns, specify the input data model, and preview the results.

Learn HANA modeling steps to create analytical views by building a data foundation, defining joins and cardinality, and selecting measures from orders, order details, and customers.

Create analytical views in HANA using input parameters, define default values and data types, and apply parameters to filter the Orders table, then test results in the data preview.

Learn to create calculated columns in an analytical view to derive the actual price from unit price, discount, and quantity, with syntax validation and view activation.

Explore HANA calculation views basics and characteristics, including multi-fact support, graphical vs scripted types, and building nodes like joins, unions, and aggregations, with steps to create and preview a view.

Learn how to create graphical calculation views in HANA, including choosing data category cube or dimension, building joins and unions, configuring projections, aggregations, and ranking.

Create graphical calculation views in HANA® using projection nodes and joins. Define input parameters, calculated columns, and selected columns, then join customers and orders with an inner join.

Learn HANA® modeling steps to create graphical calculation views by joining customers and orders, adding order details, and defining aggregations and semantics for unit price, quantity, and discount.

Learn how to create a scripted calculation view in HANA® SQL, define its output columns, and join customers and orders to return customer ID, order ID, and actual price.

Learn hana sql modeling steps to create scripted calculation views, define var_out, and input var, join order details to orders, and apply a country filter.

Learn Hana sql through building robust procedures and user defined functions, using looping, scalar variables, and machine learning techniques to optimize in-memory performance for business logic.

Learn SAP HANA procedures and core database modeling concepts, including how analytical views, attribute views, and calculation views are used, and the steps to create these views within SAP HANA.

Learn HANA sql procedures by exploring data types, declarative and imperative logic, variables, control structures, and table types, then build and call procedures with table-valued outputs and user defined functions.

Create Hana studio procedures in Hana studio, define input and output parameters, specify target schema, and outline procedure elements, data types, and begin-end blocks for read/write operations.

Learn to create and test HANA procedures with parameters, data types, and output table returns by filtering the customers table with an input country parameter.

Create a table type to serve as the base structure for returning results from a hana sql procedure, defining columns like customer id, company name, city, and order details.

Create a table type and a table user defined function to join customers and orders, with a country filter on the results.

Learn how to create a table type for customer orders and use a table UDF to join customers and orders, select fields, and return results.

Filter records using a table UDF with a country input, handle nulls via an if statement, call the UDF in a customer orders procedure, and join with order details.

Learn hana® sql procedures by reading the ship table, joining it to the customer order details, and returning results through an activated procedure with input and output parameters.

Learn to create local temporary tables and local tables in HANA procedures, declare arrays, perform array aggregations, and call functions to process joined customer order data.

Learn HANA SQL through procedures and arrays, using array functions like cardinality and distinct to loop, select first elements, and concatenate arrays with break and continue.

Explore HANA® SQL procedures to implement for and while loops, if statements, break and continue, updating discounts by country, and using a scalar user defined function.

Create a scalar user-defined function in HANA studio named calculate actual price, with inputs quantity, unit price, and discount, returning the actual price and demonstrating its use inside a procedure.