Geek Answers Handbook

What is the best resource for learning ANSI SQL?

I do not mean “Basic SQL”, but the specifications and the difference between specifications and implementations between large databases (for example, SQL Server, Oracle, etc.) are strong.

+5
source share
3 answers

http://images-eu.amazon.com/images/P/0596004818.01.jpg

SQL in a nutshell from O'Reilly and Associates. It covers all 5 basic dialects of SQL, the differences between them and does this for each function / function. (ANSI SQL99, Oracle, MySql, Postgres, and SQL Server).

+4
source

One way to study the differences is to work in various databases.

SQL Server, Oracle MySql () . , , SQL Server 50 .

Oracle: http://www.oracle.com/technology/products/database/xe/index.html

SQL Server http://www.microsoft.com/express/sql/default.aspx

MySQL http://dev.mysql.com/downloads/

:

  • // (CRUD).
  • / .
+2

More articles:


All Articles