1. Check out our app, Forums for Android! Download and leave feedback here!

SQL Query 101 help

Discussion in 'Computers & IT' started by dan330, Oct 7, 2010.

  1. dan330

    dan330 Well-Known Member
    Thread Starter
    923

    Jan 22, 2010
    11,779
    3,388
    923
    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
    3,933

    Feb 19, 2010
    32,944
    25,330
    3,933
    Male
    Good luck to you, bro! Godspeed. :D
     
  3. dan330

    dan330 Well-Known Member
    Thread Starter
    923

    Jan 22, 2010
    11,779
    3,388
    923
    thanks dude!
     
  4. batgeek

    93

    Sep 4, 2010
    752
    175
    93
    Systems Engineer
    Suffolk, VA
    why use query strings when there is TOAD!
     
  5. dan330

    dan330 Well-Known Member
    Thread Starter
    923

    Jan 22, 2010
    11,779
    3,388
    923
    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
    78

    Aug 12, 2010
    594
    76
    78
    NJ
    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

    93

    Sep 4, 2010
    752
    175
    93
    Systems Engineer
    Suffolk, VA
  8. Pryomancer

    Pryomancer Well-Known Member
    98

    Mar 29, 2010
    673
    57
    98
    Student
    Southampton, England
    SELECT e.salary, m.mgrID
    FROM employees e, managers m
    WHERE salary <= 15000
    AND e.mgrID = m.mgrID;

    :)
     
  9. wiretap

    wiretap Well-Known Member
    43

    Apr 27, 2010
    304
    37
    43
    Nuclear Power
    Michigan
  10. jgreetham

    jgreetham Well-Known Member
    58

    May 3, 2010
    202
    19
    58
  11. GringoMonkee

    GringoMonkee Member
    36

    Sep 27, 2010
    19
    1
    36
    UK
    Bon chance bud
     
  12. dan330

    dan330 Well-Known Member
    Thread Starter
    923

    Jan 22, 2010
    11,779
    3,388
    923

    that was extremely helpful!!!
     
  13. wiretap

    wiretap Well-Known Member
    43

    Apr 27, 2010
    304
    37
    43
    Nuclear Power
    Michigan
    You're welcome. W3 has good tutorials and help guides because you can actually see real time examples.
     
  14. Mayhem

    Mayhem Well-Known Member
    123

    Sep 23, 2010
    888
    152
    123
    Male
    Senior Engineer - Software Quality Assurance
    Austin, Texas area
    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
    Thread Starter
    923

    Jan 22, 2010
    11,779
    3,388
    923
    thanks man.. i will take a look at it.
     

Share This Page

Loading...