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

Thread: SQL

  1. #1
    Starter
    Points: 14,795, Level: 36
    Level completed: 94%, Points required for next Level: 55
    Overall activity: 2.0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    826
    Points
    14,795
    Level
    36
    Thumbs Up
    Received: 20
    Given: 12

    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: 72,291, Level: 83
    Level completed: 50%, Points required for next Level: 859
    Overall activity: 13.0%
    Achievements:
    Social50000 Experience PointsRecommendation Second ClassVeteran
    NATEizKING's Avatar
    Join Date
    Feb 2011
    Location
    Hilton
    Posts
    6,588
    Points
    72,291
    Level
    83
    Thumbs Up
    Received: 161
    Given: 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: 14,795, Level: 36
    Level completed: 94%, Points required for next Level: 55
    Overall activity: 2.0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    826
    Points
    14,795
    Level
    36
    Thumbs Up
    Received: 20
    Given: 12

    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: 7,873, Level: 26
    Level completed: 54%, Points required for next Level: 277
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points
    cyko42's Avatar
    Join Date
    Feb 2007
    Location
    Decatur, IL
    Posts
    369
    Points
    7,873
    Level
    26
    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,294, Level: 88
    Level completed: 64%, Points required for next Level: 656
    Overall activity: 0%
    Achievements:
    Veteran50000 Experience Points
    terryleebr's Avatar
    Join Date
    Apr 2006
    Posts
    2,727
    Points
    81,294
    Level
    88
    Thumbs Up
    Received: 12
    Given: 18

    Re: SQL

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



  6. #6
    Rookie
    Points: 7,873, Level: 26
    Level completed: 54%, Points required for next Level: 277
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points
    cyko42's Avatar
    Join Date
    Feb 2007
    Location
    Decatur, IL
    Posts
    369
    Points
    7,873
    Level
    26
    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: 14,795, Level: 36
    Level completed: 94%, Points required for next Level: 55
    Overall activity: 2.0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    826
    Points
    14,795
    Level
    36
    Thumbs Up
    Received: 20
    Given: 12

    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,666, Level: 88
    Level completed: 29%, Points required for next Level: 1,284
    Overall activity: 12.0%
    Achievements:
    SocialVeteran50000 Experience Points
    RyCy04's Avatar
    Join Date
    Sep 2007
    Location
    Omaha, NE
    Posts
    2,318
    Points
    80,666
    Level
    88
    Thumbs Up
    Received: 91
    Given: 12

    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: 7,873, Level: 26
    Level completed: 54%, Points required for next Level: 277
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points
    cyko42's Avatar
    Join Date
    Feb 2007
    Location
    Decatur, IL
    Posts
    369
    Points
    7,873
    Level
    26
    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: 7,873, Level: 26
    Level completed: 54%, Points required for next Level: 277
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points
    cyko42's Avatar
    Join Date
    Feb 2007
    Location
    Decatur, IL
    Posts
    369
    Points
    7,873
    Level
    26
    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: 450,778, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 18.0%
    Achievements:
    SocialRecommendation Second ClassVeteran50000 Experience PointsOverdrive
    brianhos's Avatar
    Join Date
    Jun 2006
    Location
    Trenchtown
    Posts
    39,578
    Points
    450,778
    Level
    100
    Thumbs Up
    Received: 166
    Given: 27

    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: 493,881, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 26.0%
    Achievements:
    SocialYour first GroupVeteran50000 Experience PointsRecommendation Second Class
    Angie's Avatar
    Join Date
    Mar 2006
    Location
    IA
    Posts
    17,423
    Points
    493,881
    Level
    100
    Thumbs Up
    Received: 613
    Given: 2,465

    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: 14,795, Level: 36
    Level completed: 94%, Points required for next Level: 55
    Overall activity: 2.0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    826
    Points
    14,795
    Level
    36
    Thumbs Up
    Received: 20
    Given: 12

    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: 13,902, Level: 35
    Level completed: 79%, Points required for next Level: 148
    Overall activity: 0%
    Achievements:
    Veteran10000 Experience Points

    Join Date
    Jun 2008
    Location
    Minneapolis
    Posts
    610
    Points
    13,902
    Level
    35
    Thumbs Up
    Received: 20
    Given: 11

    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: 119,633, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 0%
    Achievements:
    Veteran50000 Experience Points
    simply1's Avatar
    Join Date
    Jun 2009
    Location
    Salt Lake City
    Posts
    5,282
    Points
    119,633
    Level
    100
    Thumbs Up
    Received: 28
    Given: 2

    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
  •  
  • Football
  • Iowa State vs. North Dakota State
  • August 30, 2014
  • 11:00 AM