> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SQL

> The standard language for analytics

## Topics

<CardGroup cols={2}>
  <Card title="Naming" href="/content/sql/naming">
    * [Criteria](/content/sql/naming#sql-naming-criteria)
    * [Reserved Words](/content/sql/sql_reserved_words)
  </Card>

  <Card title="Queries (SQL)" href="/content/sql/query">
    * [Joins](/content/sql/query#sql-join)
    * [Aggregation](/content/sql/query#sql-aggregation)
    * [Grouping](/content/sql/query#sql-grouping)
    * [Sets](/content/sql/query#sql-set-ops)
    * [Constants](/content/sql/query#sql-constants)
    * [Functions](/content/sql/query#sql-functions)
    * [Hints](/content/sql/query#sql-hints)
    * [Explain Plan](/content/sql/query#sql-explain)
  </Card>

  <Card title="Data Manipulation (DML)" href="/content/sql/dml">
    * [Insert](/content/sql/dml#sql-dml-insert)
    * [Update](/content/sql/dml#sql-dml-update)
    * [Merge Into](/content/sql/dml#sql-dml-merge-into)
    * [Delete](/content/sql/dml#sql-dml-delete)
  </Card>

  <Card title="Data Definition (DDL)" href="/content/sql/ddl">
    * [Column Types](/content/sql/ddl#sql-column-types)
    * [Column Properties](/content/sql/ddl#sql-column-properties)
    * [Schemas](/content/sql/ddl#sql-create-schema)
    * [Tables](/content/sql/ddl#sql-create-table)
    * [Views](/content/sql/ddl#sql-create-view)
    * [Credentials](/content/sql/ddl#sql-create-credential)
    * [Data Sources](/content/sql/ddl#sql-create-data-source)
    * [Data Sinks](/content/sql/ddl#sql-create-data-sink)
    * [Streams](/content/sql/ddl#sql-create-stream)
  </Card>

  <Card title="Loading & Exporting Data">
    * [Loading Data](/content/sql/load)
    * [Exporting Data](/content/sql/export)
  </Card>

  <Card title="Files & Directories (KiFS)" href="/content/sql/kifs">
    * [Files](/content/sql/kifs#sql-kifs-upload-file)
    * [Directories](/content/sql/kifs#sql-kifs-create-dir)
    * [KiFS](/content/tools/kifs)
  </Card>

  <Card title="Reveal" href="/content/sql/reveal">
    * [Load Dashboard](/content/sql/reveal#sql-load-dashboard)
  </Card>

  <Card title="SQL Procedures" href="/content/sql/procedure">
    * [Manage](/content/sql/procedure#sql-procedures-create)
    * [Execute](/content/sql/procedure#sql-procedures-execute)
  </Card>

  <Card title="SQL-GPT" href="/content/sql/sqlgpt">
    * [CREATE CONTEXT](/content/sql/sqlgpt#sql-gpt-create-context)
    * [GENERATE SQL](/content/sql/sqlgpt#sql-gpt-generate-sql)
    * [EXECUTE\_AI\_QUERY](/content/sql/sqlgpt#sql-gpt-execute)
  </Card>

  <Card title="User Defined Functions (UDFs)" href="/content/sql/udf">
    * [Manage](/content/sql/udf#sql-create-function)
    * [Execute](/content/sql/udf#sql-execute-function)
    * [Function Environment](/content/sql/udf#sql-create-function-environment)
  </Card>

  <Card title="Graphs" href="/content/sql/graph">
    * [SQL/PGQ](/content/sql/graph#sql-pgq)
    * [Match](/content/sql/graph#sql-graph-match)
    * [Solve](/content/sql/graph#sql-graph-solve)
    * [Create](/content/sql/graph#sql-graph-create)
  </Card>

  <Card title="Machine Learning (ML)" href="/content/sql/ml">
    * [Models](/content/sql/ml#sql-ml-import-model)
    * [Inference](/content/sql/ml#sql-ml-evaluate-model)
    * [Container Registries](/content/sql/ml#sql-ml-create-cr)
    * [ML Functions](/content/sql/query#sql-ml-functions)
  </Card>

  <Card title="Security" href="/content/sql/security">
    * [Users](/content/sql/security#sql-security-user-mgmt)
    * [Roles](/content/sql/security#sql-security-role-mgmt)
    * [Privileges](/content/sql/security#sql-security-priv-mgmt)
    * [Impersonation](/content/sql/security#sql-security-impersonation)
  </Card>

  <Card title="Resource Management" href="/content/sql/resource_group">
    * [Create Resource Group](/content/sql/resource_group#sql-rg-create)
    * [Alter Resource Group](/content/sql/resource_group#sql-rg-alter)
    * [Drop Resource Group](/content/sql/resource_group#sql-rg-drop)
    * [Show Resource Group](/content/sql/resource_group#sql-rg-show)
    * [Tiers](/content/sql/resource_group#sql-tier-alter)
  </Card>

  <Card title="System Properties" href="/content/sql/system_properties">
    * [Alter System Set Properties](/content/sql/system_properties#alter-system-set-properties)
    * [Show System Properties](/content/sql/system_properties#show-system-properties)
  </Card>

  <Card title="Virtual Catalogs" href="/content/catalogs">
    * [Kinetica Virtual Catalog](/content/catalogs/kinetica)
    * [ANSI Virtual Catalog](/content/catalogs/ansi)
    * [PostgreSQL Virtual Catalog](/content/catalogs/postgresql)
    * [Useful Catalog Queries](/content/snippets/virtual-catalog-queries)
  </Card>

  <Card title="Database Backup/Restore" href="/content/sql/backup_restore">
    * [CREATE BACKUP](/content/sql/backup_restore#sql-backup-create)
    * [RESTORE BACKUP](/content/sql/backup_restore#sql-backup-restore)
  </Card>
</CardGroup>

## SQL Interfaces

<a id="sql-label" />

A variety of SQL interfaces are available, including:

<CardGroup cols={2}>
  <Card title="KiSQL CLI Tool" href="/content/tools/kisql">
    A Java-based command line tool for running SQL from a client.
  </Card>

  <Card title="JDBC/ODBC Drivers" href="/content/connectors/sql_guide">
    Connect popular tools to Kinetica.
  </Card>

  <Card title="PostgreSQL Wire Protocol" href="/content/connectors/psql_wire_protocol">
    Connect to Kinetica over PostgreSQL Wire Protocol.
  </Card>

  <Card title="Execute SQL Endpoint" href="/content/api/concepts">
    Run SQL from every native API Kinetica offers.
  </Card>

  <Card title="GAdmin SQL Tool" href="/content/admin/gadmin/query#gadmin-sql">
    Run SQL from the GAdmin web app.
  </Card>
</CardGroup>

## Product Highlights

<CardGroup cols={3}>
  <Card title="One Interface for All Analytics">
    SQL-92, SQL-99, & SQL:2003 compatible, with expanded syntax to run graph analytics and machine learning
  </Card>

  <Card title="Analytics with Performance">
    Vectorized database functions that deliver large performance gains over traditional databases
  </Card>

  <Card title="Ingest with SQL">
    High-speed, native ingestion from many providers using SQL commands
  </Card>
</CardGroup>

## How-To Guides

<CardGroup cols={2}>
  <Card title="Quick Start Guide" icon="book" href="/content/guides/quickstart-guide/index">
    Get started with Kinetica Workbench

    Length: 15 MIN
  </Card>

  <Card title="SQL Developer Guide" icon="book" href="/content/guides/sql_guide">
    Step-by-step instructions to interact with Kinetica via SQL

    Length: 30 MIN
  </Card>
</CardGroup>

## Next Steps

Now that you are familiar with Kinetica's SQL capabilities, here are a few resources to check out next:

* [GAdmin](/content/admin/gadmin/index)
* [Location Intelligence](/content/location_intelligence/index)
* [Security](/content/security/index)