Best way to learn SQL

Discussion in 'IT and Computer-Related Degrees' started by jssteele89, May 2, 2014.

Loading...
  1. jssteele89

    jssteele89 New Member

    Messages:
    3
    Likes Received:
    0
    What do you feel is the best way to learn SQL?

    This is a skill i would like to know. I don't exactly plan to be a master but would like to know my way around very well. I'm thinking about taking a class at my local community college. What are some other methods? Maybe downloading mysql on my computer and populating the database with information and querying it myself. What are the steps on doing this though??

    Thank you
     
  2. cbryant

    cbryant New Member

    Messages:
    81
    Likes Received:
    0
    Downloading MYSQL or Oracle XE would be a good way to start. SQL is very broad and each relational database will add their own bells and whistles to SQL. What are your long range goals?
     
  3. SteveFoerster

    SteveFoerster Resident Gadfly

    Messages:
    10,946
    Likes Received:
    6
    Occupation:
    This and that on the Internet
    Location:
    Northern Virginia & Dominica, West Indies
    This would be a great place to start. You could also try something like SQLCourse.com, which is not incredibly comprehensive, but might serve as a first pass through the topic. (It's too bad Codecademy doesn't have something specific to SQL yet, because their platform is awesome.) Or you could go old skool and read a book on it, like Learning SQL from O'Reilly. Good luck!
     
  4. msganti

    msganti Member

    Messages:
    315
    Likes Received:
    0
  5. jam937

    jam937 New Member

    Messages:
    407
    Likes Received:
    0
    If you have Microsoft Access that is a good way to start learning. Use the query designer to make the query, then switch to the SQL view to see the actual SQL the designer used
     
  6. jssteele89

    jssteele89 New Member

    Messages:
    3
    Likes Received:
    0
    My long term goal would to just know my way around in it. I'm not looking to be a master. More just having the skill and being proficient in it to a degree. So if i download MySQL would will there already be data in it i can start querying? Also i'm thinking about taking a class at the local community college. It's under 300 dollars for the 8 week class. I feel this could get me started with the basics and go from there on my own...
     
  7. Gau555

    Gau555 New Member

    Messages:
    31
    Likes Received:
    0
    I recommend this: SQLZOO
    We used this for one our DB classes. When I train the newbies at work on how to get the data they are looking for, I have them start with this site first for the basics. Make sure you change the Engine to SQL server. Good luck!
     
  8. Jonathan Kenigson

    Jonathan Kenigson New Member

    Messages:
    6
    Likes Received:
    0
    Occupation:
    Educator, Mathematician
    Location:
    Knoxville, TN
    Dear jssteele,

    I fully support msganti's suggestion. Reading about SQL is much less effective than diving in head-first and consulting courses and documentation when you get stuck (and like all humans this will happen....and happen...and happen...and never stop happening). Getting stuck in where genuine learning occurs. I would say get a pet project that you care about (say an ASP.Net web application - or a PHP\MySQL application) and just dive in. Of course, there are many different flavors of SQL, so which you learn first is perhaps a bit irrelevant. I'd suggest learning native MySQL first in the context of a PHP web app - but don't limit your experience there, or you'll pick up bad habits. After several months of tinkering around, I'd get acquainted with the Microsoft stack by similar tinkering - perhaps in the environment of the free Visual Studio. Please note that I'm neither a .Net nor PHP evangelist and this is merely my opinion as someone who has worked on both stacks.

    Also, make sure to set up a StackOverflow account and post there if you get stuck. True, many of the commentators there are devotees of various organized religions, but you'll get advice from some top devs if you know where to look.

    For SQL I would never suggest paying for a course. Pick something you love and learn as you go.
     

Share This Page