Topics ›
Programming-Tool>sql
23 tutorials tagged with Programming-Tool>sql.
Set up and use the Data Exploration Tools
This tutorial explains what the data exploration tools are, shows how they can be set up, and provides a few examples of using them in the SQL Console.
Query the Database Using SQL Statements
Learn how to create new tables, view table details, join tables, and extract specific data from tables using SQL statements in the SAP HANA database explorer.
Create Database Objects with SAP HANA Database Explorer
Create a user group, users, roles, and populate a sample schema that includes tables, views, functions and procedures using the SQL console.
Create a User, Tables and Import Data Using SAP HANA HDBSQL
Use the command line tool HDBSQL to connect to a SAP HANA database, create a user, and create tables which will be used in subsequent tutorials in this mission.
Authenticate to SAP HANA Cloud using X.509
Complete the provided steps to configure an SAP HANA Cloud, SAP HANA database instance to accept a login using an X.509 certificate. Examples will be provided …
Migrate to SAP HANA Cloud from SAP HANA Platform
This tutorial demonstrates a migration from an on-premise SAP HANA database to an SAP HANA Cloud database.
SAP HANA Cloud, Data Lake Client Interfaces Overview
Learn about SAP HANA Cloud, data lake, how to create a free tier instance, how to examine the data lake Relational Engine using SAP HANA Cloud Central, how to …
Create an SAP HANA Graph Workspace
Get an overview of what SAP HANA Graph is, load some sample data, and create your first graph workspace based on that data.
Complex Algorithms Using GraphScript
Learn what is GraphScript, and then build complex algorithms in SAP HANA Graph using GraphScript.
Pattern Matching Using OpenCypher in SQL
Execute pattern matching queries in SAP HANA Graph using OpenCypher.
Understand Strings in SAP HANA Spatial
A string ('a curve' in more general) is a spatial data type that connects points
Understand Points in SAP HANA Spatial
A point is a spatial data type for a 0-dimensional geometry representing a single location
Understand Polygons in SAP HANA Spatial
A polygon is a spatial data type that defines a region of space
Understand Spatial Columns in SAP HANA Spatial
Using columns to store and process spatial data in tables
Understand Z and M coordinates in SAP HANA Spatial
Geometries can optionally have Z (3rd dimension) and M (measure) values associated with each point in addition to X and Y coordinates
Understand Spatial Reference Systems in SAP HANA Spatial
In the context of spatial databases, the defined space in which geometries are described is called a spatial reference system (SRS).
Access methods
Spatial access methods help you to retrieve properties of geometries
Computation methods
Computation methods help you calculating characteristics of geometries
Transformation methods
Transformation methods transform a geometry into some other geometry
Create Stored Procedures
Leveraging SQLScript in Stored Procedures, User Defined Functions, and User Defined Libraries
Importing Required Calculation Views
Conversion and importation of calculation views for Dynamic Tiering
Setup Node.js to connect to SAP HANA
Use Node.js to connect and read data from your SAP HANA, express edition or SAP HANA Cloud
Convert Oracle-to-SAP HANA with Advanced SQL Migration Tool
Convert an Oracle schema used by a custom application to SAP HANA using SAP Advanced SQL Migration tool