SQL

[zetsway]

So you know those Learn books. Well, if I were to read learn SQL in 24hours do you think I can relearn everything in 24hours.


What's your take?

 

[programmer]

When you say "relearn", do you mean to say that you once learned and used SQL? If so, you can pick up the basics again pretty quickly. If you have never used SQL, then highly unlikely you can learn even the basics in 24 hours (without understanding how RDBMS work).

 

[programmer]

BTW, I had to restart using SQL after a few years of non-use. I found this book very good:
http://www.amazon.com/SQL-Quer...ls-Hands/dp/0201433362

 

[zetsway]

Thanks for your help. I used SQL last year. I made a few websites for a company and built their SQL server. I don't remember everything though.

BTW: I learned the basics in a week.

 

[Hyperblaze]

functionality you use quite often....

INSERT, SELECT, FROM, WHERE, INNER JOIN, LEFT JOIN, RIGHT JOIN, sub queries....

just to name a few
what I find as good formatting is the following.

SELECT u.username, u.password
FROM `user` as `u`
WHERE u.id = (whatever)

as a very simple example

 

[zetsway]

BOY I love google.

This site is just what I need: http://www.sql.org/sql-database/sql-tutorial/