1

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 Taryn, Philᵀᴹ, Kin Shah, RolandoMySQLDBA, Mark Storey-Smith Feb 5 '14 at 22:22

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

3

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.