#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    3
    Rep Power
    0

    Learning SQL for Beginners


    Could anyone please recommend the best book to learn SQL for beginners. I've got a few books but they don't seem to have that many practical exercises in them. They just seem to go on about SQL and to be honest i'm not learning as well as i think i could with practical exercises. Any help on finding the right book would be very much appreciated.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,781
    Rep Power
    348
    Check out http://sqlzoo.net
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
    http://forums.devshed.com/misc.php?do=bbcode#code

    Tips on how to ask better questions:
    http://tkyte.blogspot.de/2005/06/how-to-ask-questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    3
    Rep Power
    0

    Smile


    Many Thanks Shammat, That is just what i'm looking for.
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    3
    Rep Power
    0
    Hey Shammat,

    That site you reccomended is good however i've searched everywhere even that site for the command to create a table with columns of data both varchar and tinyint and i can't seem to find an answer. Do you know what the command is?
  8. #5
  9. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,118
    Rep Power
    4274
    Originally Posted by Kev_1976
    ... create a table with columns of data both varchar and tinyint
    Code:
    CREATE TABLE whoa
    ( humpty VARCHAR(9) 
    , dumpty TINYINT
    );
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo