SQL Query 101 help

[dan330]

hi..

I am currently looking for work.

I have a degree in Information Systems.. but that was 10 yrs ago. Most of my work have been in Sales of all type.. Tech services to Auto Collision Center.

I am now looking at an interview for a Business Analyst in Database Company. The require that I have simple SQL query knowledge. I did know it a long time ago...and need a little refresher.

Are there any good websites that help someone like me.. and newbies get simple query understanding?

Thanks in advance for all your help.
Dan

 

[Steven58]

Good luck to you, bro! Godspeed.

 

[dan330]

Good luck to you, bro! Godspeed.

thanks dude!

 

[batgeek]

why use query strings when there is TOAD!

 

[dan330]

why use query strings when there is TOAD!

what is TOAD??

cant answer your question.. but that is what the want as a job requirement!

 

[Super_Six_Two]

The best learning tool for me is google. I have had to work with some existing queries and change them but never had to do anything from scratch. Google was able to find me everything I needed.

 

[batgeek]

SQL Server Application Development Software Tools by Quest Software

i'm not an database guy, but have to manipulate our database on occasion.

 

[Pryomancer]

SELECT e.salary, m.mgrID
FROM employees e, managers m
WHERE salary <= 15000
AND e.mgrID = m.mgrID;

 

[wiretap]

SQL Tutorial

 

[jgreetham]

You could also check Oracle's web site Oracle | Hardware and Software, Engineered to Work Together. Using google may get you what you're looking for faster.

Good luck,
Jim

 

[GringoMonkee]

Bon chance bud

 

[dan330]

SQL Tutorial

that was extremely helpful!!!

 

[wiretap]

You're welcome. W3 has good tutorials and help guides because you can actually see real time examples.

 

[Mayhem]

I pulled down SQL for Dummies off of a free EBooks site.

I saved you the trouble of having to deal with MediaFire.

Rapidshare link

It's a .rar file. If you don't have anything that will open it, go get 7Zip

Good luck!

 

[dan330]

I pulled down SQL for Dummies off of a free EBooks site.

I saved you the trouble of having to deal with MediaFire.

Rapidshare link

It's a .rar file. If you don't have anything that will open it, go get 7Zip

Good luck!

thanks man.. i will take a look at it.