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

Thread: SQL

  1. #1
    Starter
    Points: 15,824, Level: 38
    Level completed: 22%, Points required for next Level: 626
    Overall activity: 0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    900
    Points
    15,824
    Level
    38
    Thumbs Up
    Received: 59
    Given: 29

    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: 83,867, Level: 90
    Level completed: 7%, Points required for next Level: 1,683
    Overall activity: 15.0%
    Achievements:
    Social50000 Experience PointsRecommendation Second ClassVeteran
    NATEizKING's Avatar
    Join Date
    Feb 2011
    Location
    Hilton
    Posts
    7,811
    Points
    83,867
    Level
    90
    Thumbs Up
    Received: 695
    Given: 1,150

    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: 15,824, Level: 38
    Level completed: 22%, Points required for next Level: 626
    Overall activity: 0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    900
    Points
    15,824
    Level
    38
    Thumbs Up
    Received: 59
    Given: 29

    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,132, Level: 89
    Level completed: 11%, Points required for next Level: 1,618
    Overall activity: 0%
    Achievements:
    Veteran50000 Experience Points
    terryleebr's Avatar
    Join Date
    Apr 2006
    Posts
    2,829
    Points
    82,132
    Level
    89
    Thumbs Up
    Received: 57
    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: 15,824, Level: 38
    Level completed: 22%, Points required for next Level: 626
    Overall activity: 0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    900
    Points
    15,824
    Level
    38
    Thumbs Up
    Received: 59
    Given: 29

    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: 81,977, Level: 89
    Level completed: 2%, Points required for next Level: 1,773
    Overall activity: 8.0%
    Achievements:
    SocialVeteran50000 Experience Points
    RyCy04's Avatar
    Join Date
    Sep 2007
    Location
    Omaha, NE
    Posts
    2,396
    Points
    81,977
    Level
    89
    Thumbs Up
    Received: 185
    Given: 22

    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: 459,512, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 11.0%
    Achievements:
    SocialRecommendation Second ClassVeteran50000 Experience PointsOverdrive
    brianhos's Avatar
    Join Date
    Jun 2006
    Location
    Trenchtown
    Posts
    40,252
    Points
    459,512
    Level
    100
    Thumbs Up
    Received: 589
    Given: 76

    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: 522,915, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 86.0%
    Achievements:
    SocialYour first GroupVeteran50000 Experience PointsRecommendation Second Class
    Angie's Avatar
    Join Date
    Mar 2006
    Location
    IA
    Posts
    18,555
    Points
    522,915
    Level
    100
    Thumbs Up
    Received: 1,300
    Given: 5,567

    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: 15,824, Level: 38
    Level completed: 22%, Points required for next Level: 626
    Overall activity: 0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    900
    Points
    15,824
    Level
    38
    Thumbs Up
    Received: 59
    Given: 29

    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,266, Level: 37
    Level completed: 52%, Points required for next Level: 384
    Overall activity: 0%
    Achievements:
    Veteran10000 Experience Points

    Join Date
    Jun 2008
    Location
    Minneapolis
    Posts
    716
    Points
    15,266
    Level
    37
    Thumbs Up
    Received: 44
    Given: 79

    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,444, Level: 76
    Level completed: 25%, Points required for next Level: 1,206
    Overall activity: 3.0%
    Achievements:
    Veteran50000 Experience Points
    simply1's Avatar
    Join Date
    Jun 2009
    Location
    Salt Lake City
    Posts
    5,631
    Points
    60,444
    Level
    76
    Thumbs Up
    Received: 81
    Given: 7

    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: TBD
  • FOOTBALL: Iowa State vs. UNI
  • August 29, 2015
  • 06:00 PM