SQL Querying Fundamentals (SELECT, WHERE, GROUP BY, ORDER BY)
Tutorials that teach this
- Tutorial Display Database Content and Run SQL Queries
- Tutorial Access methods
- Tutorial Connect Using the SAP HANA .NET Interface
- Tutorial Import Data into SAP HANA Cloud, SAP HANA Database
- Tutorial SAP HANA Cloud, Data Lake Client Interfaces Overview
- Tutorial Browse Schema with the Database Browser in SAP HANA Database Explorer
- Tutorial Export and Import Data and Schema with SAP HANA Database Explorer
- Tutorial Creating Table User Defined Functions
- Tutorial Parallel Processing and Parameters
- Tutorial Index and Search Text In a SAP HANA Cloud, data lake
- Tutorial Understand Points in SAP HANA Spatial
- Tutorial Seeing Calculation View Results
- Tutorial Access and Query a Data Product in SAP HANA Cloud
- Tutorial Create Users and Manage Roles and Privileges
- Tutorial Create a User, Tables and Import Data Using SAP HANA HDBSQL
- Tutorial Use a Cost Function to Calculate Shortest Path
- Tutorial Query Databases Using the SQL Console in SAP HANA Cloud Central
- Tutorial Query the Database Using SQL Statements
- Tutorial Create an SAP HANA Graph Workspace
- Tutorial Create Database Objects with SAP HANA Database Explorer
- Tutorial Create Anonymized Views Using Differential Privacy
- Tutorial Selectively Move Data Between In-Memory and Extended Tables
- Tutorial Browse and Explore Catalog Objects with the Database Objects App
- Tutorial Convert Between an In-Memory Table and an Extended Table
- Tutorial Execute SQL Commands and Create Custom Notifications with SAP Automation Pilot and SAP Alert Notification Service
- Tutorial Explore SAP HANA Cloud, SAP HANA Database SQL on Files
- Tutorial Accessing SAP HANA Data lake Relational Engine using Apache Spark
- Tutorial View Data Across Both In-Memory and Dynamic Tiering Tables Using a SQL View
- Tutorial View Data Across Both In-Memory and Dynamic Tiering Tables Using a SQL View
Prerequisites
- Concept SAP HANA In-Memory Platform Fundamentals
- Concept Remote Sources and Virtual Tables in SAP HANA Cloud
- Concept SAP HANA Fuzzy Search on Text Data
- Concept Well-Known Text (WKT) and ST_GeomFromText in SAP HANA
- Concept SAP HANA Database Explorer
- Concept SQL JOIN Operations (INNER JOIN)
- Concept SAP HANA Calculation Views
- Concept SAP HANA In-Memory Relational Database
- Concept SAP HANA Stored Procedure Creation and Execution
- Concept Data Lake Fundamentals
- Concept SAP HANA Cloud fundamentals
- Concept SAP HANA Graph Algorithms (Neighbors, Shortest Path)
- Concept Extended Storage Dbspace Creation and Removal
- Concept CREATE TABLE AS SELECT (CTAS) in SQL
Concepts that build on this
- Concept SAP HANA Dynamic Tiering Query Plan Analysis and Index Creation
- Concept SAP HANA Monitoring Views (M_ prefix)
- Concept SQL Aggregate Functions (COUNT, MAX)
- Concept SAP HANA Cloud Data Lake Monitoring Views
- Concept SAP HANA Graph Workspace Usage
- Concept SQL UNION ALL for Combining Result Sets
- Concept SAP HANA Spatial Type Hierarchy and SQL/MM Standard
- Concept SAP HANA Spatial Column Types (ST_GEOMETRY, ST_POINT)
- Concept Hibernate Query Language (HQL/JPQL) and Native SQL Queries
- Concept GraphScript Procedures in SAP HANA
- Concept SAP HANA Predictive Analysis Library (PAL)
- Concept SQL JOIN Operations (INNER JOIN)
- Concept SQLScript Scalar User-Defined Functions (UDFs)
- Concept SPARQL Querying
- Concept Data Filtering and Sorting
- Concept Import and Export Management
- Concept SAP HANA Cloud Instance Provisioning
- Concept Foreign Key Constraints and Referential Integrity
- Concept SAP HANA Security and User Management
- Concept SAP HANA Cloud Database Objects App
- Concept SAP HANA Stored Procedure Creation and Execution
- Concept Schema and Configuration Management
- Concept CREATE TABLE AS SELECT (CTAS) in SQL
- Concept SAP HANA HDBSQL Command-Line Tool Basics
- Concept SAP HANA Database Administration
- Concept .NET Driver for SAP HANA Cloud Data Lake Relational Engine
- Concept SQLScript HANA Database Procedure
- Concept CDS Table Functions
- Concept Well-Known Text (WKT) and ST_GeomFromText in SAP HANA
- Concept SAP HANA Database Explorer
- Concept SAP HANA Spatial Access Functions (ST_X, ST_Dimension)
- Concept SQLScript Table User-Defined Functions
- Concept SQL Nested Queries and Subqueries
- Concept SAP HANA Calculation Views
- Concept SQLScript Anonymous Blocks
- Concept Java application development
- Concept SQL Explain Plan for Query Execution Analysis
- Concept SAP HANA Dynamic Tiering (Extended Tables)
- Concept SAP HANA Database Explorer Data Import
- Concept SQLScript Table Variables and Intermediate Tables
- Concept Querying Points of Interest with SAP HANA Spatial
- Concept SAP HANA In-Database Machine Learning
- Concept Auto Commit and Manual Transaction Control in SQL
- Concept SAP HANA Cloud Data Lake
- Concept SAP HANA Anonymized Views
- Concept HDBTABLE Object Definition and Column Definitions
- Concept SAP HANA Spatial Reference Systems (SRS)
- Concept Selective Data Migration Between In-Memory and Extended Storage
- Concept Extended Storage Dbspace Creation and Removal
- Concept SAP HANA Python Database Client (hdbcli)
- Concept SAP HANA Spatial LineString and CircularString Types
- Concept SAP HANA Multi-Store Tables
- Concept Predictive Modeling and Model Training
- Concept Remote Sources and Virtual Tables in SAP HANA Cloud
- Concept SAP HANA Spatial Transformation Methods (ST_Boundary, ST_Envelope, ST_ConvexHull, ST_Buffer)
- Concept SAP HANA Smart Data Streaming Project Creation