Ansi sql

Hey guys,

I am a student of IT and the university of Windesheim in the Netherlands.

At my uni we are learing a version of sql called ANSI sql.

i treid using the sql course to practice but the conventions are so vastly diffrent.

can anyone tell me why that is or if ansi if better or worse?

Hello @codename_dutch,

ANSI SQL is an established set of standards for the SQL language. In order to be ANSI compliant, the basic SQL commands for SELECT, INSERT, UPDATE, DELETE and WHERE are used the same way as defined by these standards.

It’s not a matter of being worse or better, it means that you’ll have a baseline and be able to learn other SQL databases easily such as MySQL, SQL Server, MS Access, Oracle, Sybase, Informix or Postgres.

1 Like