Spread the love! TechSpot Tech Gift Shortlist 2017

Learning UNIX/SQL

By halo71
Jun 28, 2006
  1. Can anyone tell me if they know of any guides on the net for learning UNIX and SQL that are...say free? Or an easy way of learning short of going out and buying books. I know very little about SQL, mainly have just done queries and stuff. I need to learn the "basics" ASAP for a project at work.

    Thanks alot.....
  2. jobeard

    jobeard TS Ambassador Posts: 10,845   +897

    SQL:: Structured Query Language, but never a Standard Query Language as
    some believe.

    There are three psuedo-official 'grammars' of SQL,
    • pre ANSII
    • ANSII-1
    • ANSII-2

    In addition, various specific vendors have extensions and variations on the
    language (big suprise huh).

    Even thought, ANY SQL tutorial will give you the basic concepts and the
    ideas for the Data Manipulation Language(DML). The variations will be primarily
    in the use/misuse of ( ) for object names.

    Be aware, the SQL grammar is a means to get/insert RELATIONAL DATA
    into a set of Relational Tables. The concepts of Relations is another subject
    altogether. Authors to read include Ted Codd, and C.J. Date

    The primaries of Relational Data are the 'rules of normalization' of data.
  3. terra_nova

    terra_nova TS Rookie

    I did a Uni project with SQL, using Linux with mySQL, i found the mySQL manual pretty helpful. I dont know how much help it will be to you, but here is the link anyway


    Its pretty in depth, as it covers may installs for various OS' the SQL part starts at section 3.

    General SQL tutorial is here


    as for learning unix, there are a fair number of tutorials on the web try


    that gives a decent intro to the basics, though i found the best way to learn it was by dual booting my system with a Linux install. Mandriva or Ubuntu being a good place to start. Of course if you need it pretty quick then the tutorial is the way to go.

    Hope this helps

  4. halo71

    halo71 TS Rookie Topic Starter Posts: 1,090

    Thanks for the information. I will check it out......
Topic Status:
Not open for further replies.

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...