• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Devaka Cooray
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Paul Clapham
  • Knute Snortum
  • Rob Spoor
Saloon Keepers:
  • Tim Moores
  • Ron McLeod
  • Piet Souris
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Frits Walraven
  • Ganesh Patekar

SQL

 
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...
 
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.
 
Bartender
Posts: 1031
18
Mac OS X IntelliJ IDE Oracle Spring VI Editor Tomcat Server Redhat Java Linux
  • 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..."
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!