Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question

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.

    
WHat is your question here? You ask what they are - a standard and you already link to a complete answer. So the question is answered. What to make of them os basically opinion based - not a good topic on a site that does not like such questions. Besides that every product expands the standard anyway and I Think hardly any major db implements the complete one, so you can not even seriously try to be standards compliant outside smaller projects anyway. –  TomTom Feb 5 at 11:51

1 Answer 1

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

share|improve this answer

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