SQL Query 101 help


Last Updated:

  1. dan330

    dan330 Well-Known Member This Topic's Starter

    Joined:
    Jan 22, 2010
    Messages:
    11,602
    Likes Received:
    3,221
    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
     

    Advertisement
  2. Steven58

    Steven58 Reformed PH VIP Member

    Joined:
    Feb 19, 2010
    Messages:
    32,920
    Likes Received:
    25,271
    Good luck to you, bro! Godspeed. :D
     
  3. dan330

    dan330 Well-Known Member This Topic's Starter

    Joined:
    Jan 22, 2010
    Messages:
    11,602
    Likes Received:
    3,221
  4. batgeek

    batgeek Banned

    Joined:
    Sep 4, 2010
    Messages:
    752
    Likes Received:
    175
    why use query strings when there is TOAD!
     
  5. dan330

    dan330 Well-Known Member This Topic's Starter

    Joined:
    Jan 22, 2010
    Messages:
    11,602
    Likes Received:
    3,221
    what is TOAD??

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

    Super_Six_Two Well-Known Member

    Joined:
    Aug 12, 2010
    Messages:
    594
    Likes Received:
    76
    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.
     
  7. batgeek

    batgeek Banned

    Joined:
    Sep 4, 2010
    Messages:
    752
    Likes Received:
    175
  8. Pryomancer

    Pryomancer Well-Known Member

    Joined:
    Mar 29, 2010
    Messages:
    673
    Likes Received:
    57
    SELECT e.salary, m.mgrID
    FROM employees e, managers m
    WHERE salary <= 15000
    AND e.mgrID = m.mgrID;

    :)
     
  9. wiretap

    wiretap Well-Known Member

    Joined:
    Apr 27, 2010
    Messages:
    304
    Likes Received:
    37
  10. jgreetham

    jgreetham Well-Known Member

    Joined:
    May 3, 2010
    Messages:
    203
    Likes Received:
    19
  11. GringoMonkee

    GringoMonkee Member

    Joined:
    Sep 27, 2010
    Messages:
    19
    Likes Received:
    1
    Bon chance bud
     
  12. dan330

    dan330 Well-Known Member This Topic's Starter

    Joined:
    Jan 22, 2010
    Messages:
    11,602
    Likes Received:
    3,221
  13. wiretap

    wiretap Well-Known Member

    Joined:
    Apr 27, 2010
    Messages:
    304
    Likes Received:
    37
    You're welcome. W3 has good tutorials and help guides because you can actually see real time examples.
     
  14. Mayhem

    Mayhem Well-Known Member Contributor

    Joined:
    Sep 23, 2010
    Messages:
    888
    Likes Received:
    151
    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!
     
  15. dan330

    dan330 Well-Known Member This Topic's Starter

    Joined:
    Jan 22, 2010
    Messages:
    11,602
    Likes Received:
    3,221
    thanks man.. i will take a look at it.
     

Share This Page

Loading...