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

Thread: SQL

  1. #1
    Starter
    Points: 15,300, Level: 37
    Level completed: 57%, Points required for next Level: 350
    Overall activity: 1.0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    860
    Points
    15,300
    Level
    37
    Thumbs Up
    Received: 36
    Given: 20

    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: 76,529, Level: 85
    Level completed: 99%, Points required for next Level: 21
    Overall activity: 3.0%
    Achievements:
    Social50000 Experience PointsRecommendation Second ClassVeteran
    NATEizKING's Avatar
    Join Date
    Feb 2011
    Location
    Hilton
    Posts
    7,239
    Points
    76,529
    Level
    85
    Thumbs Up
    Received: 438
    Given: 741

    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,300, Level: 37
    Level completed: 57%, Points required for next Level: 350
    Overall activity: 1.0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    860
    Points
    15,300
    Level
    37
    Thumbs Up
    Received: 36
    Given: 20

    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,317, Level: 27
    Level completed: 28%, Points required for next Level: 433
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points
    cyko42's Avatar
    Join Date
    Feb 2007
    Location
    Decatur, IL
    Posts
    369
    Points
    8,317
    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: 81,773, Level: 88
    Level completed: 91%, Points required for next Level: 177
    Overall activity: 3.0%
    Achievements:
    Veteran50000 Experience Points
    terryleebr's Avatar
    Join Date
    Apr 2006
    Posts
    2,782
    Points
    81,773
    Level
    88
    Thumbs Up
    Received: 43
    Given: 23

    Re: SQL

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



  6. #6
    Rookie
    Points: 8,317, Level: 27
    Level completed: 28%, Points required for next Level: 433
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points
    cyko42's Avatar
    Join Date
    Feb 2007
    Location
    Decatur, IL
    Posts
    369
    Points
    8,317
    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,300, Level: 37
    Level completed: 57%, Points required for next Level: 350
    Overall activity: 1.0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    860
    Points
    15,300
    Level
    37
    Thumbs Up
    Received: 36
    Given: 20

    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: 80,956, Level: 88
    Level completed: 45%, Points required for next Level: 994
    Overall activity: 5.0%
    Achievements:
    SocialVeteran50000 Experience Points
    RyCy04's Avatar
    Join Date
    Sep 2007
    Location
    Omaha, NE
    Posts
    2,377
    Points
    80,956
    Level
    88
    Thumbs Up
    Received: 160
    Given: 16

    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,317, Level: 27
    Level completed: 28%, Points required for next Level: 433
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points
    cyko42's Avatar
    Join Date
    Feb 2007
    Location
    Decatur, IL
    Posts
    369
    Points
    8,317
    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,317, Level: 27
    Level completed: 28%, Points required for next Level: 433
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points
    cyko42's Avatar
    Join Date
    Feb 2007
    Location
    Decatur, IL
    Posts
    369
    Points
    8,317
    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: 454,627, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 8.0%
    Achievements:
    SocialRecommendation Second ClassVeteran50000 Experience PointsOverdrive
    brianhos's Avatar
    Join Date
    Jun 2006
    Location
    Trenchtown
    Posts
    39,935
    Points
    454,627
    Level
    100
    Thumbs Up
    Received: 392
    Given: 49

    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: 505,895, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 15.0%
    Achievements:
    SocialYour first GroupVeteran50000 Experience PointsRecommendation Second Class
    Angie's Avatar
    Join Date
    Mar 2006
    Location
    IA
    Posts
    17,794
    Points
    505,895
    Level
    100
    Thumbs Up
    Received: 839
    Given: 3,503

    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

  13. #13
    Starter
    Points: 15,300, Level: 37
    Level completed: 57%, Points required for next Level: 350
    Overall activity: 1.0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    860
    Points
    15,300
    Level
    37
    Thumbs Up
    Received: 36
    Given: 20

    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: 14,918, Level: 37
    Level completed: 9%, Points required for next Level: 732
    Overall activity: 1.0%
    Achievements:
    Veteran10000 Experience Points

    Join Date
    Jun 2008
    Location
    Minneapolis
    Posts
    705
    Points
    14,918
    Level
    37
    Thumbs Up
    Received: 42
    Given: 64

    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: 59,836, Level: 75
    Level completed: 86%, Points required for next Level: 214
    Overall activity: 0%
    Achievements:
    Veteran50000 Experience Points
    simply1's Avatar
    Join Date
    Jun 2009
    Location
    Salt Lake City
    Posts
    5,612
    Points
    59,836
    Level
    75
    Thumbs Up
    Received: 71
    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: Cyclones.tv
  • HOOPS: Iowa State vs. Mississippi Valley State
  • December 31, 2014
  • 06:00 PM