Recommend a book for SQL

[FearoftheNight]

I'd like to improve my sql abilities. Anyone here work w/ dbs and can recommend a book or guide?

 

[her209]

Best way to learn it is just to install MySQL and run the commands.

 

[SandEagle]

have you asked that dry cleaner girl out yet?

if not,

select *
from atot_users
where balls = '0'
----------------------------
1 row returned

FearOftheNight

 

[Possessed Freak]

have you asked that dry cleaner girl out yet?

if not,

select *
from atot_users
where balls = '0'
----------------------------
1 row returned

FearOftheNight

Rubycon and the other women on ATOT have balls?

 

[her209]

Rubycon and the other women on ATOT have balls?

razkum too?

 

[rasczak]

Rubycon and the other women on ATOT have balls?

Yes. They have your balls in a vise grip.

 

[dwell]

Books are so 90's.

http://www.w3schools.com/web/web_sql.asp

http://www.sqlcourse.com/index.html

 

[SandEagle]

Rubycon and the other women on ATOT have balls?

apparently. this query shows that they must all be dudes posing as wimmin. SQL never lies.

 

[FearoftheNight]

lolll quit stalking my threads. but seriously whats a good way to practice sql? i'm in front of dbs all day...mostly ms sql server and oracle

 

[her209]

but seriously whats a good way to practice sql? i'm in front of dbs all day...mostly ms sql server and oracle

Make up scenarios and figure out the SQL command that will get you the information you need. Make it complicated enough where you have to query multiple tables and use INNER JOINS, OUTER JOINS, etc.

 

[FearoftheNight]

Make up scenarios and figure out the SQL command that will get you the information you need. Make it complicated enough where you have to query multiple tables and use INNER JOINS, OUTER JOINS, etc.

hi thanks...i'm really new to sql so i'm not sure what kind of scenarios would be good...in fact i dont even know what inner and outer joins are...hence the need to learn

 

[her209]

hi thanks...i'm really new to sql so i'm not sure what kind of scenarios would be good...in fact i dont even know what inner and outer joins are...hence the need to learn

Start here then
http://dev.mysql.com/doc/refman/5.0/en/tutorial.html

 

[Saint Nick]

you don't need no book....go online and learn.

 

[FearoftheNight]

Start here then
http://dev.mysql.com/doc/refman/5.0/en/tutorial.html

hi thanks..are there major differences between the different sql clients? i usually use oracle or ms sql server

 

[yllus]

hi thanks..are there major differences between the different sql clients? i usually use oracle or ms sql server

There is actually a standardized core set of SQL commands that have been dictated by ANSI (a standards institute). On top of that, each SQL server has its own extra layer of commands (PL/SQL for Oracle, T-SQL for MS SQL, and so on) that aren't a bad idea to learn but is definitely not common knowledge.

My book on SQL is over a decade old, and for the most part as dwell indicates you don't need one. Where a book might be handy is in teaching abstract concepts such as database normalization.

 

[richardycc]

Rubycon and the other women on ATOT have balls?

they would show up in the 'where balls is null' query.

 

[Leros]

You don't need a book. SQL is pretty easy. Find a decent online tutorial and start messing around.

 

[HardcoreRobot]

try the programming forum

 

[xalos]

I'd recommend the SQL queries and the database design book in the for mere mortals series. Realistically the SQL is the easy part, knowing how to correctly design a database from the ground up is a really good skill and takes some thought.

I really liked the interview portion of the database design book, it really helped me speed up the design process up by allowing me to make better use of the initial meeting with the client.

 

[consolibyte]

If you're already good at SQL, and want to get better... check out the "SQL for Smarties" books by Joel Celko. Very high-level, clever SQL books.

 

[DaveSimmons]

XAMPP - download-and-go packages with Apache, MySQL and PHP for Windows, Linux, Macs.

http://www.apachefriends.org/en/xampp.html

 

[Cienja]

I just purchased SQL in a Nutshell. I plan to use online resources too...W3schools has been a good resource.