SQL Querying Fundamentals (SELECT, WHERE, GROUP BY, ORDER BY)
Tutorials that teach this
Prerequisites
- ConceptSAP HANA Cloud fundamentals
- ConceptSAP HANA In-Memory Platform Fundamentals
- ConceptWell-Known Text (WKT) and ST_GeomFromText in SAP HANA
- ConceptOracle to SAP HANA SQL Migration
- ConceptSAP HANA In-Memory Relational Database
- ConceptSAP HANA Cloud Connection Management
- ConceptSAP HANA Database Explorer
- ConceptSAP HANA SQL API Usage
Concepts that build on this
- ConceptSQL CREATE VIEW Statement
- ConceptSAP HANA Dynamic Tiering Query Plan Analysis and Index Creation
- ConceptSAP HANA Monitoring Views (M_ prefix)
- ConceptSAP HANA Cloud Data Lake
- ConceptHDBTABLE Object Definition and Column Definitions
- ConceptSAP HANA Multi-Store Tables
- ConceptCREATE TABLE AS SELECT (CTAS) in SQL
- ConceptSAP HANA Cloud Spatial Engine
- ConceptHibernate Query Language (HQL/JPQL) and Native SQL Queries
- ConceptSAP HANA Spatial LineString and CircularString Types
- ConceptSAP HANA Spatial Type Hierarchy and SQL/MM Standard
- ConceptAuto Commit and Manual Transaction Control in SQL
- ConceptSchema and Configuration Management
- ConceptGraphScript Procedures in SAP HANA
- ConceptSAP HANA Predictive Analysis Library (PAL)
- ConceptSQL Console in SAP HANA Cloud Central
- ConceptSQLScript Scalar User-Defined Functions (UDFs)
- ConceptSPARQL Querying
- ConceptData Filtering and Sorting
- ConceptQuerying Points of Interest with SAP HANA Spatial
- ConceptImport and Export Management
- ConceptSAP HANA Cloud Instance Provisioning
- ConceptSQLScript Anonymous Blocks
- ConceptHANA Table Partitioning and Indexing
Show all 63 concepts
- ConceptSAP HANA Advanced Analytics
- ConceptForeign Key Constraints and Referential Integrity
- ConceptSAP HANA Security and User Management
- ConceptSQLScript HANA Database Procedure
- Concept.NET Driver for SAP HANA Cloud Data Lake Relational Engine
- ConceptPredictive Modeling and Model Training
- ConceptUser Provisioning
- ConceptSAP HANA Cloud Database Objects App
- ConceptSAP HANA SQL API Usage
- ConceptSQLScript Table User-Defined Functions
- ConceptSQL Nested Queries and Subqueries
- ConceptSAP HANA Calculation Views
- ConceptSAP HANA HDBSQL Command-Line Tool Basics
- ConceptGo database/sql Package for Relational Queries
- ConceptSAP HANA Database Explorer
- ConceptSAP HANA Graph Workspace Usage
- ConceptGenAI Tools in the SQL Console (Natural Language to SQL, Explain, Optimize)
- ConceptSQL Explain Plan for Query Execution Analysis
- ConceptRemote Sources and Virtual Tables in SAP HANA Cloud
- ConceptOpenCypher Pattern Matching Queries
- ConceptSAP HANA Spatial Transformation Methods (ST_Boundary, ST_Envelope, ST_ConvexHull, ST_Buffer)
- ConceptSAP HANA Stored Procedure Creation and Execution
- ConceptSQL DDL and DML Statements (CREATE, INSERT, DROP)
- ConceptSQL Aggregate Functions (COUNT, MAX)
- ConceptJava application development
- ConceptSAP HANA Dynamic Tiering (Extended Tables)
- ConceptSAP HANA In-Database Machine Learning
- ConceptSQL JOIN Operations (INNER JOIN)
- ConceptSAP HANA Cloud Data Lake Monitoring Views
- ConceptSAP HANA Anonymized Views
- ConceptSelective Data Migration Between In-Memory and Extended Storage
- ConceptCDS Table Functions
- ConceptSAP HANA Python Database Client (hdbcli)
- ConceptSAP HANA Database Explorer Data Import
- ConceptDENSE_RANK Window Function
- ConceptSQL Console Background Statement Execution
- ConceptSQL Console Statement Library
- ConceptSAP HANA Spatial Access Functions (ST_X, ST_Dimension)
- ConceptSQL UNION ALL for Combining Result Sets