# SQL reference

Find ParticleDB SQL syntax, data types, queries, writes and transaction behavior.

Source: https://particledb.ai/sql/overview/

| Task | Reference |
|---|---|
| Learn SQL operations | [SQL basics](/sql/basics/) |
| Choose column types | [Data types](/sql/data-types/) and [conversions](/sql/casting/) |
| Create tables and indexes | [Schema commands](/sql/ddl/) |
| Read records | [SELECT](/sql/select/) and [joins](/sql/joins/) |
| Write records | [INSERT, UPDATE and DELETE](/sql/insert-update-delete/) |
| Group related changes | [Transactions](/sql/transactions/) and [locking](/sql/locking/) |
| Change a schema | [Schema transactions](/sql/transactional-ddl/) |
| Aggregate and rank | [Aggregations](/sql/aggregations/) and [windows](/sql/window-functions/) |
| Retrieve context | [Vectors](/sql/vector-search/) and [text search](/sql/full-text-search/) |
| Work with time | [Time series](/sql/timeseries/) and [historical reads](/sql/time-travel/) |
| Store query results | [Materialized views](/sql/materialized-views/) |
| Import external data | [Import and export](/guides/import-export/) |

Examples establish syntax and behavior for small datasets. They do not establish performance or complete compatibility with another database. Check [limits](/reference/limits/) and your client's error handling before a migration.

## Related

[Documentation home](/docs/) · [Troubleshooting](/guides/troubleshooting/)
