I don't mean "Basic SQL", but strongly the specs and the difference between the specs and the implementations between great databases (like SQL Server, Oracle, etc).
+2
A:
The number one way of learning the differences is to work in the various databases.
SQL Server, Oracle, and MySql all offer free (express) editions. Also, if you want to step up a bit you can get the developer version of SQL Server for about $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/
Simple things to do:
- create a database
- create a table
- do simple insert/update/delete (CRUD) operations
- do inner / outer joins.
Chris Lively
2009-01-21 02:29:13
+1
A:
PostgreSQL the world's more advanced opensource and more ANSI SQL-compliant database
Various RDBMS ANSI SQL-conformance: http://troels.arvin.dk/db/rdbms/
Michael Buen
2009-01-21 03:49:38
Love that book! Really helpful if you are moving from Oracle to SQL Server or vice versa. I only wish it had Access Jet SQL as well as many people have trouble with the changes to syntax when they move away from Access.
HLGEM
2009-01-21 19:18:12
This is the de facto answer.
Robert S.
2009-01-21 19:24:12
This book has saved my rear-end more times than I care to count. Well worth the cost.
George Stocker
2009-01-21 19:29:12
It's a great book, but it *is* only a 'nutshell' book and leaves a lot of the standard uncovered. Any suggestions for more detail, short of buying the standard itself (yikes!)?
bobince
2009-01-21 21:38:21
@bobince: Have you read this book? It pours through every conceivable function and compares it across all 5 standards. There's very little it leaves out.
George Stocker
2009-01-21 21:47:25