Page 1 of 2 12 LastLast
Results 1 to 15 of 17

Thread: SQL

  1. #1
    Starter
    Points: 16,175, Level: 38
    Level completed: 66%, Points required for next Level: 275
    Overall activity: 0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    912
    Points
    16,175
    Level
    38
    Thumbs Up
    Received: 68
    Given: 30

    SQL

    I am interested in learning SQL to further my career/ possibly open more doors. What is a good way to do this. I would like something other than just reading a book. Maybe actually applying it to something. I know there are some open source databases I could download. Any one have experience learning basic sql as a non programmer.



  2. #2
    Addict
    Points: 90,946, Level: 93
    Level completed: 84%, Points required for next Level: 304
    Overall activity: 11.0%
    Achievements:
    Social50000 Experience PointsRecommendation Second ClassVeteran
    NATEizKING's Avatar
    Join Date
    Feb 2011
    Location
    Hilton
    Posts
    7,994
    Points
    90,946
    Level
    93
    Thumbs Up
    Received: 774
    Given: 1,334

    Re: SQL

    If you find something good let me know I'm teaching myself Java right now but am interested in SQL. Learning Java from a book though.



  3. #3
    Starter
    Points: 16,175, Level: 38
    Level completed: 66%, Points required for next Level: 275
    Overall activity: 0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    912
    Points
    16,175
    Level
    38
    Thumbs Up
    Received: 68
    Given: 30

    Re: SQL

    Quote Originally Posted by NATEizKING View Post
    If you find something good let me know I'm teaching myself Java right now but am interested in SQL. Learning Java from a book though.
    OK, I am not opposed to learning from a book. I would just like some way to apply it so it helps me learn, remember it.



  4. #4
    Rookie
    Points: 8,550, Level: 27
    Level completed: 67%, Points required for next Level: 200
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points
    cyko42's Avatar
    Join Date
    Feb 2007
    Location
    Decatur, IL
    Posts
    370
    Points
    8,550
    Level
    27
    Thumbs Up
    Received: 0
    Given: 0

    Re: SQL

    don't know about as a non programmer but the only way to truly learn sql is by doing, grabbing a class or a book helps, but as with any language ( programming or other) repetition and usage make the rules stick. If you want to do some simple stuff to try out grab mysql (its open source) and do a google for mysql tutorials they should come with a sample and some simple queries.

    Really basic sql is pretty easy because the terms make sense.

    so any tutorials will get you started.



  5. #5
    Pro
    Points: 82,309, Level: 89
    Level completed: 20%, Points required for next Level: 1,441
    Overall activity: 0%
    Achievements:
    Veteran50000 Experience Points
    terryleebr's Avatar
    Join Date
    Apr 2006
    Posts
    2,832
    Points
    82,309
    Level
    89
    Thumbs Up
    Received: 58
    Given: 24

    Re: SQL

    You can download Microsoft SQL server express for free. Provides a pretty nice interface.



  6. #6
    Rookie
    Points: 8,550, Level: 27
    Level completed: 67%, Points required for next Level: 200
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points
    cyko42's Avatar
    Join Date
    Feb 2007
    Location
    Decatur, IL
    Posts
    370
    Points
    8,550
    Level
    27
    Thumbs Up
    Received: 0
    Given: 0

    Re: SQL

    Quote Originally Posted by cyko42 View Post
    don't know about as a non programmer but the only way to truly learn sql is by doing, grabbing a class or a book helps, but as with any language ( programming or other) repetition and usage make the rules stick. If you want to do some simple stuff to try out grab mysql (its open source) and do a google for mysql tutorials they should come with a sample and some simple queries.Really basic sql is pretty easy because the terms make sense.so any tutorials will get you started.
    Oh i misread not a book, same principle applies. Best thing to do is install mysql, or ms sql express, tutorial then try a project. statistics are good places to build examples so maybe try a db for a sport you enjoy.

    like lets say tracking cyclone commitments or something thats interesting to you but has different data that you can write queries for.



  7. #7
    Starter
    Points: 16,175, Level: 38
    Level completed: 66%, Points required for next Level: 275
    Overall activity: 0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    912
    Points
    16,175
    Level
    38
    Thumbs Up
    Received: 68
    Given: 30

    Re: SQL

    Quote Originally Posted by cyko42 View Post
    Oh i misread not a book, same principle applies. Best thing to do is install mysql, or ms sql express, tutorial then try a project. statistics are good places to build examples so maybe try a db for a sport you enjoy.

    like lets say tracking cyclone commitments or something thats interesting to you but has different data that you can write queries for.
    Thanks. Was thinking about setting up a database of baseball stats. Any thoughts on setting it up? Do programs like MySQL have built in web queries? or is it easier to use excel web queries and then copy/paste?



  8. #8
    Pro
    Points: 82,289, Level: 89
    Level completed: 19%, Points required for next Level: 1,461
    Overall activity: 5.0%
    Achievements:
    SocialVeteran50000 Experience Points
    RyCy04's Avatar
    Join Date
    Sep 2007
    Location
    Omaha, NE
    Posts
    2,412
    Points
    82,289
    Level
    89
    Thumbs Up
    Received: 196
    Given: 24

    Re: SQL

    When trying to get promoted at a previous employer I lied and said I knew SQL. Fairly simple to learn. Repetition is the most important thing. Also, diversify. Oracle, WinSQL, SQL Server, Access, etc. all have their slight tweeks.



  9. #9
    Rookie
    Points: 8,550, Level: 27
    Level completed: 67%, Points required for next Level: 200
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points
    cyko42's Avatar
    Join Date
    Feb 2007
    Location
    Decatur, IL
    Posts
    370
    Points
    8,550
    Level
    27
    Thumbs Up
    Received: 0
    Given: 0

    Re: SQL

    Quote Originally Posted by dabears32 View Post
    Quote Originally Posted by cyko42 View Post
    Oh i misread not a book, same principle applies. Best thing to do is install mysql, or ms sql express, tutorial then try a project. statistics are good places to build examples so maybe try a db for a sport you enjoy.like lets say tracking cyclone commitments or something thats interesting to you but has different data that you can write queries for.
    Thanks. Was thinking about setting up a database of baseball stats. Any thoughts on setting it up? Do programs like MySQL have built in web queries? or is it easier to use excel web
    queries and then copy/paste?
    Never done anything with web queries (i despise excel, once you learn sql you might use it less) so not sure what options exist out there for doing that but alot of stats sites will provide data in different formats to import into a sql database. Lots of good sites on writing queries to bring in data into a table, from different file formats.



  10. #10
    Rookie
    Points: 8,550, Level: 27
    Level completed: 67%, Points required for next Level: 200
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points
    cyko42's Avatar
    Join Date
    Feb 2007
    Location
    Decatur, IL
    Posts
    370
    Points
    8,550
    Level
    27
    Thumbs Up
    Received: 0
    Given: 0

    Re: SQL

    Quote Originally Posted by cyko42 View Post
    Quote Originally Posted by dabears32 View Post
    Quote Originally Posted by cyko42 View Post
    Oh i misread not a book, same principle applies. Best thing to do is install mysql, or ms sql express, tutorial then try a project. statistics are good places to build examples so maybe try a db for a sport you enjoy.like lets say tracking cyclone commitments or something thats interesting to you but has different data that you can write queries for.
    Thanks. Was thinking about setting up a database of baseball stats. Any thoughts on setting it up? Do programs like MySQL have built in web queries? or is it easier to use excel web queries and then copy/paste?
    Never done anything with web queries (i despise excel, once you learn sql you might use it less) so not sure what options exist out there for doing that but alot of stats sites will provide data in different formats to import into a sql database. Lots of good sites on writing queries to bring in data into a table, from different file formats.
    try this

    Download Lahman’s Baseball Database « Sean Lahman *http://www.seanlahman.com/baseball-archive/statistics/



  11. #11
    Speechless
    Points: 460,103, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 3.0%
    Achievements:
    SocialRecommendation Second ClassVeteran50000 Experience PointsOverdrive
    brianhos's Avatar
    Join Date
    Jun 2006
    Location
    Trenchtown
    Posts
    40,311
    Points
    460,103
    Level
    100
    Thumbs Up
    Received: 638
    Given: 79

    Re: SQL

    Get a linux box running on any old machine you have, and grab mysql. Then use phpmyadmin to learn how to admin mysql, and start doing a project in it where you need to write lots of sql.


    They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety. - Benjamin Franklin 1775

  12. #12
    square root(31) = 5.56776436
    Points: 528,388, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 11.0%
    Achievements:
    SocialYour first GroupVeteran50000 Experience PointsRecommendation Second Class
    Angie's Avatar
    Join Date
    Mar 2006
    Location
    IA
    Posts
    18,812
    Points
    528,388
    Level
    100
    Thumbs Up
    Received: 1,539
    Given: 6,551

    Re: SQL

    I mostly taught myself SQL, but I know a book helped a few buddies - something like Sam's SQL in Ten Days or something? I can't remember the name, but Amazon had it if you searh "learn SQL."


    M 7/09

    Quote Originally Posted by Firefighter4Cy View Post
    I got 99 problems but angie isn't one.

  13. #13
    Starter
    Points: 16,175, Level: 38
    Level completed: 66%, Points required for next Level: 275
    Overall activity: 0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    912
    Points
    16,175
    Level
    38
    Thumbs Up
    Received: 68
    Given: 30

    Re: SQL

    Quote Originally Posted by cyko42 View Post
    try this

    Download Lahman’s Baseball Database « Sean Lahman *Sean Lahman | Database Journalist

    Thanks. This is probably a dumb question but what format do I need if I plan on using MySQL(or some other opensource DB). Is the SQL fromat acceptable or will I have to download the CSV format and then import it?



  14. #14
    Starter
    Points: 15,410, Level: 37
    Level completed: 70%, Points required for next Level: 240
    Overall activity: 0%
    Achievements:
    Veteran10000 Experience Points

    Join Date
    Jun 2008
    Location
    Minneapolis
    Posts
    730
    Points
    15,410
    Level
    37
    Thumbs Up
    Received: 53
    Given: 80

    Re: SQL

    Quote Originally Posted by brianhos View Post
    Get a linux box running on any old machine you have, and grab mysql. Then use phpmyadmin to learn how to admin mysql, and start doing a project in it where you need to write lots of sql.
    This is probably more to bite off than the OP can chew since he identified himself as a non-programmer, but I have to second this recommendation. It will force you to learn and use SQL in the context of a larger project which is more valuable than trying to learn it by itself since SQL is always used in the context of a larger project.



  15. #15
    Addict
    Points: 60,721, Level: 76
    Level completed: 42%, Points required for next Level: 929
    Overall activity: 0%
    Achievements:
    Veteran50000 Experience Points
    simply1's Avatar
    Join Date
    Jun 2009
    Location
    Salt Lake City
    Posts
    5,647
    Points
    60,721
    Level
    76
    Thumbs Up
    Received: 93
    Given: 8

    Re: SQL

    You might follow something like this, not sure if you want to actually figure out how the tables should be created, etc, or just want a downloadable database to practice queries on. MySQL Sample Database


    I don't do signatures. Blondes, brunettes, and red heads are a different story.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
  • TV: Cyclones.TV
  • FOOTBALL: Iowa State vs. UNI
  • September 5, 2015
  • 07:00 PM