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
A friend uses Microsoft SQL Server 2005 to write code in ASP.NET, C#, and SQL. It's my understanding that SQL Server 2005 can be dowloaded for free, in a "starter" version, from microsoft.com. I would learn SQL, XML and JavaScript in that order. SQL and MySQL are different. MySQL works exclusively with PHP, another server languge. .NET is also a server language. The query syntax for SQL and MySQL are virtually the same, however. A server cannot run both PHP/MySQL and .NET, it's one or the other.
SQL and MySQL are different, but not because MySQL only works exclusively with php (which isn't true), but because SQL is not a server, but a language. SQL stands for Structurized Query Language. MySQL is a server that uses SQL to comunicate with other scripts. MySQL works with everything, as long as the language has support for it. I think it works with almost any language: ASP, PHP, Python, Java,... don't you mean can't. Javascript hasn't got the capabilities to connect to a database. Whenever you need access to a database for a javascript script, you need to use AJAX to comunicate with a serversided language that will grab the content from the database