• Post Reply Bookmark Topic Watch Topic
  • New Topic

SQL  RSS feed

 
Tomer Gal
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Guys, I got almost no knowledge about SQL except the fact that its good to learn it for database queries.
Could someone give a good link or recommend a good ebook for learning SQL ?
Also... what is the difference between SQL and MYSQL...
 
Jeroen Wenting
Ranch Hand
Posts: 5093
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
don't know good books, learned it on the fly and from the documentation sets of the database engines I worked with

mySQL is not SQL, it's a database engine (which can be used with SQL, though it doesn't implement every command correctly).

If I were you I'd visit www.ibphoenix.com and download Firebird which is a very good (and what's vitally important fully ANSI compliant) database engine to play around with.
There's also a class 4 (true Java) JDBC driver available for it so you can access your database from Java programs easily.

There's a documentation set you can download through there as well for Interbase 6 which contains a complete SQL manual (though I think no tutorials) listing every command and all options with complete syntax.
 
Peter Rooke
Ranch Hand
Posts: 870
4
Java Linux Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I always liked: An Introduction to Database Systems [C.J Date]

It is academic and covers more than just SQL. Of course you may need something extra to get a understanding of MySQL.

PS - may have been better to ask this in the general computing forum.

---------
"No repeating, Everything depends on the key, The whole key, And nothing but the key. Thank you Codd..."
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!