Learning UNIX/SQL

By halo71
Jun 28, 2006
Topic Status:
Not open for further replies.
  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: 13,030   +222

    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 Newcomer, in training

    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

    http://dev.mysql.com/doc/refman/5.0/en/index.html

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

    General SQL tutorial is here

    http://www.w3schools.com/sql/sql_intro.asp

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

    http://www.ee.surrey.ac.uk/Teaching/Unix/

    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

    Terra
  4. halo71

    halo71 Newcomer, in training Topic Starter Posts: 1,289

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


Add New Comment

TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...


Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.