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...
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.