+ Reply to Thread
Results 1 to 8 of 8
  1. #1
    jssteele89 is offline Registered User
    Join Date
    Mar 2014
    Posts
    3

    Best way to learn SQL

    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. #2
    cbryant is offline Registered User
    Join Date
    Dec 2003
    Posts
    81
    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?
    Bachelor of Science (Mathematics) Southwestern Oklahoma State University.
    Master of Arts in Religion Westminster Theological Seminary.

  3. #3
    SteveFoerster is offline Resident Gadfly
    Join Date
    Jan 2004
    Location
    Northern Virginia & Dominica, West Indies
    Posts
    10,858
    Quote Originally Posted by jssteele89 View Post
    I'm thinking about taking a class at my local community college.
    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!
    BS, Info Sys concentration, Charter Oak State College
    MA in Educational Tech, George Washington University
    PhD in Leadership, U. of the Cumberlands (in progress)
    More at http://stevefoerster.com

  4. #4
    msganti is offline Registered User
    Join Date
    Jun 2010
    Posts
    300
    You can download a free version of SQL Server Express and start playing:
    Download Microsoft SQL Server 2014 Express

  5. #5
    jam937 is offline Registered User
    Join Date
    Oct 2011
    Posts
    407
    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. #6
    jssteele89 is offline Registered User
    Join Date
    Mar 2014
    Posts
    3
    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. #7
    Gau555 is offline Registered User
    Join Date
    Apr 2010
    Posts
    31
    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. Advertisement

  9. #8
    Jonathan Kenigson is offline Registered User
    Join Date
    May 2014
    Location
    Knoxville, TN
    Posts
    6
    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.

Similar Threads

  1. How do I learn Flash?
    By MichaelOliver in forum General Distance Learning Discussions
    Replies: 5
    Last Post: 03-10-2010, 08:10 AM
  2. Help feed the hungry and learn something too....
    By -kevin- in forum Off-Topic Discussions
    Replies: 0
    Last Post: 01-13-2009, 01:54 PM
  3. Yes, but can you really learn that way?
    By SteveFoerster in forum General Distance Learning Discussions
    Replies: 3
    Last Post: 01-22-2008, 07:11 PM
  4. Some fools never learn...
    By mineralhh in forum Off-Topic Discussions
    Replies: 13
    Last Post: 09-06-2005, 10:40 AM
  5. Very first question - what to learn?
    By rytrom in forum General Distance Learning Discussions
    Replies: 3
    Last Post: 05-26-2004, 12:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts




1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197