Resource for SQL

Question

Hi All,

I know this question might have asked severla times and i am asking it again.I am a java developers and when it comes to SQL i always make me nervous i do have idea about some basic SQL queries but above that i am mindless.. Can any one suggest me a good book or refrence material whcih can atleast give me a good solid foundation in SQL so that i can some how think in SQL way.

I also got a copy of Learning SQL and trying from this. Any suggestion or help will be much appriciated..

Thanks in advance Umesh http://travelling-rants.blogspot.com/

Answer 1

There are many sites out there, talking about SQL. You should google for "SQL basics" or something similar.

You should also consider the official documentation of database management system (DBMS), you are using, e.g. PostgreSQL. SQL ist standardized, but different vendors extended SQL or may vary in syntax details. So the official DBMS documentation should be most clear on those details.

There is also plenty of stuff available for JDBC. For example this trail from SUN / Oracle: link text

Answer 2

I think this one is good enough

http://www.w3schools.com/sql/

I work with SQL since about 18 years and let me give you some hints

• Most of the time you need the SELECT statement
• When it comes to UPDATE, INSERT, CREATE TABLE etc. it is not hard to understand but most people have to look up the syntax because they are not used that often
• The beginners challenge in SELECT statements is probably the different kind of JOINs
• The GROUP BY and HAVING BY is not complicated but needs to be understood
• The EXISTS might be confusing but once you got it you wonder what was complicated

Hope it helps