SQL Querying Fundamentals (SELECT, WHERE, GROUP BY, ORDER BY)
Tutorials that teach this
- Tutorial Browse Schema with the Database Browser in SAP HANA Database Explorer
- Tutorial Access methods
- Tutorial Create Users and Manage Roles and Privileges
- Tutorial Query the Database Using SQL Statements
- Tutorial View Data Across Both In-Memory and Dynamic Tiering Tables Using a SQL View
- Tutorial Query with the SQL Console in SAP HANA Database Explorer
- Tutorial View Data Across Both In-Memory and Dynamic Tiering Tables Using a SQL View
- Tutorial Display Database Content and Run SQL Queries
- Tutorial Dropping a Dbspace File
Prerequisites
- Concept SAP HANA In-Memory Platform Fundamentals
- Concept Well-Known Text (WKT) and ST_GeomFromText in SAP HANA
- Concept SAP HANA Cloud Central Administration
- Concept SAP HANA Fuzzy Search on Text Data
- Concept SAP HANA Database Explorer
- Concept SAP HANA Cloud fundamentals
- Concept SAP HANA Calculation Views
- Concept Extended Storage Dbspace Creation and Removal
- Concept SAP HANA In-Memory Relational Database
Concepts that build on this
- Concept SAP HANA Dynamic Tiering Query Plan Analysis and Index Creation
- Concept SAP HANA Cloud Data Lake
- Concept SAP HANA Spatial Hexagonal Clustering
- Concept HDBTABLE Object Definition and Column Definitions
- Concept .NET Driver for SAP HANA Cloud Data Lake Relational Engine
- Concept Hibernate Query Language (HQL/JPQL) and Native SQL Queries
- Concept SAP HANA Spatial Type Hierarchy and SQL/MM Standard
- Concept Auto Commit and Manual Transaction Control in SQL
- Concept Well-Known Text (WKT) and ST_GeomFromText in SAP HANA
- Concept Schema and Configuration Management
- Concept SQL Console in SAP HANA Cloud Central
- Concept GraphScript Procedures in SAP HANA
- Concept SAP HANA Predictive Analysis Library (PAL)
- Concept SAP HANA HDBSQL Command-Line Tool Basics
- Concept SQLScript Scalar User-Defined Functions (UDFs)
- Concept SPARQL Querying
- Concept Data Filtering and Sorting
- Concept Querying Points of Interest with SAP HANA Spatial
- Concept Import and Export Management
- Concept SAP HANA Stored Procedure Creation and Execution
- Concept SAP HANA Cloud Instance Provisioning
- Concept SAP HANA Advanced Analytics
- Concept OpenCypher Pattern Matching Queries
- Concept Foreign Key Constraints and Referential Integrity
- Concept SAP HANA Spatial Column Types (ST_GEOMETRY, ST_POINT)
- Concept SAP HANA Monitoring Views (M_ prefix)
- Concept SAP HANA Security and User Management
- Concept SAP HANA Graph Workspace Usage
- Concept SQL CREATE VIEW Statement
- Concept HANA Table Partitioning and Indexing
- Concept User Provisioning
- Concept SAP HANA Cloud Database Objects App
- Concept CDS Table Functions
- Concept dbisql Command-Line Tool for SAP HANA Cloud Data Lake
- Concept SQLScript Table User-Defined Functions
- Concept SQL Nested Queries and Subqueries
- Concept SAP HANA Calculation Views
- Concept Go database/sql Package for Relational Queries
- Concept SAP HANA Database Explorer
- Concept GenAI Tools in the SQL Console (Natural Language to SQL, Explain, Optimize)
- Concept Remote Sources and Virtual Tables in SAP HANA Cloud
- Concept SAP HANA Multi-Store Tables
- Concept SQL Aggregate Functions (COUNT, MAX)
- Concept Java application development
- Concept SQL UNION ALL for Combining Result Sets
- Concept SQL Explain Plan for Query Execution Analysis
- Concept SAP HANA Dynamic Tiering (Extended Tables)
- Concept SAP HANA Spatial LineString and CircularString Types
- Concept SAP HANA Database Explorer Data Import
- Concept SAP HANA Spatial Access Functions (ST_X, ST_Dimension)
- Concept SQL JOIN Operations (INNER JOIN)
- Concept SAP HANA Cloud Data Lake Monitoring Views
- Concept SAP HANA Anonymized Views
- Concept Selective Data Migration Between In-Memory and Extended Storage
- Concept SAP HANA In-Database Machine Learning
- Concept CREATE TABLE AS SELECT (CTAS) in SQL
- Concept SAP HANA Python Database Client (hdbcli)
- Concept SAP HANA Spatial Transformation Methods (ST_Boundary, ST_Envelope, ST_ConvexHull, ST_Buffer)
- Concept SQL Console Background Statement Execution