Order of learning JavaScript, XML & SQL

Discussion in 'MySQL' started by electron, Jun 23, 2007.

  1. #1
    I am planning to learn the three languages JavaScript, XML & SQL.
    Please Suggest me in what order should i learn them.
    Also, what are the Software requirements for SQL ?
    I generally write my Code in Visual studio, do i need to get something else for SQL?
    Ans lastly, are SQL & MySql different?

    Thanks for taking time out :)
     
    electron, Jun 23, 2007 IP
  2. UnrealEd

    UnrealEd Peon

    Messages:
    148
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Well, to be honest: you can't do anything with those three languages when you use them together :D (except for displaying xml with javascript)

    XML (Extensible Markup Language), which is not a programming language, but a language to store data, just like HTML is one (no actually, HTML is a kind of XML). A lot of browsers don't fully support XML yet, so i think it's best if you learn XHTML instead. It uses the same rules as XML, but uses some standard nodes (no other are allowed), who are pretty much the same as the HTML nodes.

    Javascript is a client-sided programming language, and can't in any way connect to a mysql server (as far as i know). Javascript is great to add some nice options to your website, such as (dis)appearing div's, some minor form processing, alerting the user if something's wrong, etc.
    However: javascript does have one great function, which is called AJAX, and which allows you to comunicate with other pages on your server (read txt files, process data to a php/asp/cgi page, ...).

    The only thing you need for SQL is a SQL-type database system such as MySQL, MSSQL, Oracle, PostgreSQL, MSQL, .... (there are an awfull lot of sql servers available). So in answer to your last question: SQL stands for Structured Query Language, so it is a language, not a server, like MySQL. MySQL is a database server who uses the SQL language to comunicate with external scripts. If you create your scripts, and use SQL syntax to comunicate with the database server, you can use any SQL server (there are some minor differences in syntax between the SQL server. for instance: oracle doesn't support the "INT" type, it uses "number" instead)

    If you want to use the database functionalities on your website, you will have to use a serversided programming language such as PHP, ASP, JSP, ColdFusion, ...
     
    UnrealEd, Jun 23, 2007 IP
  3. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #3
    "I generally write my Code in Visual studio, do i need to get something else for SQL?"

    Yes, you need a database, mostly MSSQL (from microsoft).
     
    gibex, Jun 24, 2007 IP
  4. electron

    electron Well-Known Member

    Messages:
    249
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    101
    #4
    Thank you both for the providing the Information :)
     
    electron, Jun 24, 2007 IP