SQL: Difference between revisions

From wikinotes
No edit summary
No edit summary
Line 1: Line 1:
{{ NOTE |
The SQL spec is standardized by ISO/ANSI and must be purchased.<br>
The SQL spec is standardized by ISO/ANSI and must be purchased }}
It's difficult to validate these notes without it.<br>
This attempts to document the more general SQL-ish features available across SQL databases.


= Documentation =
= Documentation =

Revision as of 17:18, 19 September 2021

The SQL spec is standardized by ISO/ANSI and must be purchased.
It's difficult to validate these notes without it.
This attempts to document the more general SQL-ish features available across SQL databases.

Documentation

SQL spec (unofficial) https://jakewheat.github.io/sql-overview/

Challenges

https://quip.com/2gwZArKuWk7W

Notes

sql: datatypes
sql: structures
sql: queries
sql: mutations
sql: comparison operators
sql: joins
sql: dates
sql: aggregate functions
sql: optimization