Some job descriptions mention required knowledge of SQL standards. What do they mean by that?
I found something on wiki http://en.wikipedia.org/wiki/SQL#Standardization but I don't really know what to think of it.
closed as too broad by bluefeet, Phil, Kin, RolandoMySQLDBA, Mark Storey-Smith Feb 5 at 22:22
There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question.
There are some general ISO/ANSI standards that should act as guidelines for all RDBMS that use the SQL language. The standards define features of the language, such as data types. The current standard is SQL 2011, which added a standard for temporal support.
Ideally, all RBDMS vendors that use SQL should develop language functionality according to the standards, making porting databases and user skills between the various implementations much easier.
Unfortunately, this is not really the case. There are many features that RBMS vendors are slow to implement (e.g. SQL Server not having DATE until 2008, despite it being in the SQL:92 standards) and many things that the standards do not cover (e.g. indexing)
The full standards are not available freely online (I don't think), however you can read part one here SQL Part 1