|
To-do: E · H · W · RUpdated 2012-11-10
Want to help? Here are some suggestions for improvements that can be made to this article:
- Expand article
SQL doesn't have "commands". A discussion of "statements", "clauses", "predicates", "expressions", etc., might be in order.
Add explanation of SQL datatypes
- Overview of the (vast facilities) for custom datatypes in SQL:1999
- Add discussion of SQL standards-defined functions and operators (aggregate functions, windowing functions, math operators, etc.)
- CASE expressions. Some readers of other articles are surprised to find out that these even exist in SQL.
- Add discussion of subquery types, e.g. correlated subquery
- Add discussion of CTE's and recursive subqueries (partially done)
- Add discussion of why no Boolean data type
- Add intro to tables, rows, columns, and cursors
Add short introduction to NULL and SQL 3VL (thorough discussion provided at Null (SQL)
- Add historical discussion of "Embedded SQL"
- Add discussion of declarative versus procedural languages
Add discussion of SQL/XML
Add discussion of SQL/PSM
- Overview of the parts of the SQL Standard
- Discussion of vendor-specific and proprietary extensions (might be too detailed to discuss all the differences between the different vendors and the standards)
- What is a "standards-compliant" version of SQL?
- Source statements in article (in particular, the criticisms section, although others need it also)
Locate and add images if possible and where appropriate (screen shots of queries and results?) Maybe add one more screenshot of query results?
- Clean up, editing
- Simplify language and grammar.
Clean up intro
|