I just read a post asking which language should someone learn and I started to type and realized that it was so long it deserved its own thread for everyone to find and ponder upon so here it is.
First off I know most people here will jump up and say learn PHP right away its the best well in my own option PHP is useless I tell you USELESS, well ok I'm wrong on that part. PHP is good for finding scripts, everyone and their dog has learned PHP (Except for me), PHP is and can be a powerful language but what is the best web development language for you because PHP is simply not for everyone. Lets Begin.
In my mind PHP is a harder language to learn because it deals with C++ as a base code which means you've got to put a little ; at the end of every fucking line and use <% PHP %> strange ass syntax. You see I've never learned PHP but I can understand it. I can also build some kick ass interactive websites, e-commerce, personal, whatever...I can build it without PHP.
I personally recommened ASP.NET 2.0 and VBScript or C++, now you should also be learning about XHTML because HTML is now an expired language, and you should learn about Web 2.0 (Which is not hard), after that get to know your CSS.
So the basics are XHTML, Web 2.0 Design, & CSS.
From their you can go more advanced and add some interactivity, you can use Microsoft Visual Studio Web Developer (Its free), and learn some ASP.NET 2.0.... their are shit loads of resources and its easy to learn, now the real toss up.
Should you learn VBScript or C++, well I find VBScript super easy to learn and with everything else I'm mentioning here there are tons of resources on that subject but their has always been a debate between VBScript developers and C++ developers because once you get SUPER advanced in web development and coding. VBScript starts to loose power (there are less resources to look upon and learn from) this could be because its a newer language then C++.
Now C++ on the other hand is harder to learn, they do some fucked up shit that VBScript doesn't do, the upside to the downfall learning curve is the power of C++, if you learn C++ then you can easily learn PHP right after learning ASP.NET 2.0, there will virtually be no learning curve.
So which one should someone use is the real question?, well any real web developer will simply tell you to learn both. Why? Its simple learning VBScript when your new to programming is super easy to do and its powerful for doing little things here and their, it gets you familiar with programming practice in general but then once you get the hang of things you can advance over to C++ learning how to do some super powerful things.
Lets do a summery here shall we....
ASP.NET 2.0 can be used with VBScript & C++.
ASP.NET 2.0 can use both mySQL or SQL.
PHP is built upon a C++ language.
PHP deals with mySQL (We will get to that in a moment).
Now you should be able to make a choice, as I stated previously I can create some kick ass super interactive websites and I use ASP.NET 2.0 with VBScript, notice how I never got around to learning C++ or PHP?, I can still understand most of C++ and PHP but I'll have a hard time coding it from scratch......So the choice is up to you but you've got lots of options.
Now onto SQL and mySQL, whats the difference, well mySQL was originally supposed to be a free version of SQL but since SQL 2005 came out as a free version mySQL is kind of pointless, unless you'll be dealing with Wordpress a fuck of a lot.
This now brings us into a smaller language which you'll learn a bit about by doing PHP or ASP and that language is known as ADO or ADO.NET now ADO is a programming language for the SQL database, ADO will simply teach you how to access the information inside the database, which data types you should be using, how to use certain controls and how to access all of those things programmically. (Sorry for the spelling).
Now the choice of what to use with your web development SQL 2005 or mySQL?, this is the same question as VBScript or C++ because in my eyes SQL 2005 is much much easier to learn then mySQL because the data access is much easier to get at in SQL 2005 and its just as secure. So again a bit of research into both of these should lead you in the direction you want to take.
The easiest way to determine which to learn first is to read over an introduction on both VBScript & C++, then read over introductions for mySQL and SQL 2005, you should then be able to pick which direction you'll take, but for some additional advice if you choose to go with VBScript then stick with SQL 2005 but if you choose to go with C++ then go with mySQL, you'll know this reason later on in your programming life.
Now you'll still have to learn ADO for both mySQL and SQL because they are both somewhat the same language they just access the information in a seperate way and just so you all know SQL stands for Structured Query Language.
hmm What else?....Oh thats right here are some more sweet things to ponder the mind on they are known as LINQ and BLINQ (pronounced Blink and Link). these are two newer languages that are being pretty much built by Polita Paulus (BLINQ) and Anders Hejlsberg (LINQ), what these two languages do is simply cut down on the amount of work you have to do in order to retrieve data out of the database, and it shows you better ways to work with and store that data, pretty much how to better optimize your database for speed, rather then relying on Caching or some other tricks.
Anyway I'm going to stop there because that should give you a bit of my personal insight into which language a person should learn, sorry if its unorganized or jumbled but have fun learning I sure have for the past 5 years or more.
Additionally Feel free to shoot some questions my way if you've got any and I'll do my best to answer then for you.
First off I know most people here will jump up and say learn PHP right away its the best well in my own option PHP is useless I tell you USELESS, well ok I'm wrong on that part. PHP is good for finding scripts, everyone and their dog has learned PHP (Except for me), PHP is and can be a powerful language but what is the best web development language for you because PHP is simply not for everyone. Lets Begin.
In my mind PHP is a harder language to learn because it deals with C++ as a base code which means you've got to put a little ; at the end of every fucking line and use <% PHP %> strange ass syntax. You see I've never learned PHP but I can understand it. I can also build some kick ass interactive websites, e-commerce, personal, whatever...I can build it without PHP.
I personally recommened ASP.NET 2.0 and VBScript or C++, now you should also be learning about XHTML because HTML is now an expired language, and you should learn about Web 2.0 (Which is not hard), after that get to know your CSS.
So the basics are XHTML, Web 2.0 Design, & CSS.
From their you can go more advanced and add some interactivity, you can use Microsoft Visual Studio Web Developer (Its free), and learn some ASP.NET 2.0.... their are shit loads of resources and its easy to learn, now the real toss up.
Should you learn VBScript or C++, well I find VBScript super easy to learn and with everything else I'm mentioning here there are tons of resources on that subject but their has always been a debate between VBScript developers and C++ developers because once you get SUPER advanced in web development and coding. VBScript starts to loose power (there are less resources to look upon and learn from) this could be because its a newer language then C++.
Now C++ on the other hand is harder to learn, they do some fucked up shit that VBScript doesn't do, the upside to the downfall learning curve is the power of C++, if you learn C++ then you can easily learn PHP right after learning ASP.NET 2.0, there will virtually be no learning curve.
So which one should someone use is the real question?, well any real web developer will simply tell you to learn both. Why? Its simple learning VBScript when your new to programming is super easy to do and its powerful for doing little things here and their, it gets you familiar with programming practice in general but then once you get the hang of things you can advance over to C++ learning how to do some super powerful things.
Lets do a summery here shall we....
ASP.NET 2.0 can be used with VBScript & C++.
ASP.NET 2.0 can use both mySQL or SQL.
PHP is built upon a C++ language.
PHP deals with mySQL (We will get to that in a moment).
Now you should be able to make a choice, as I stated previously I can create some kick ass super interactive websites and I use ASP.NET 2.0 with VBScript, notice how I never got around to learning C++ or PHP?, I can still understand most of C++ and PHP but I'll have a hard time coding it from scratch......So the choice is up to you but you've got lots of options.
Now onto SQL and mySQL, whats the difference, well mySQL was originally supposed to be a free version of SQL but since SQL 2005 came out as a free version mySQL is kind of pointless, unless you'll be dealing with Wordpress a fuck of a lot.
This now brings us into a smaller language which you'll learn a bit about by doing PHP or ASP and that language is known as ADO or ADO.NET now ADO is a programming language for the SQL database, ADO will simply teach you how to access the information inside the database, which data types you should be using, how to use certain controls and how to access all of those things programmically. (Sorry for the spelling).
Now the choice of what to use with your web development SQL 2005 or mySQL?, this is the same question as VBScript or C++ because in my eyes SQL 2005 is much much easier to learn then mySQL because the data access is much easier to get at in SQL 2005 and its just as secure. So again a bit of research into both of these should lead you in the direction you want to take.
The easiest way to determine which to learn first is to read over an introduction on both VBScript & C++, then read over introductions for mySQL and SQL 2005, you should then be able to pick which direction you'll take, but for some additional advice if you choose to go with VBScript then stick with SQL 2005 but if you choose to go with C++ then go with mySQL, you'll know this reason later on in your programming life.
Now you'll still have to learn ADO for both mySQL and SQL because they are both somewhat the same language they just access the information in a seperate way and just so you all know SQL stands for Structured Query Language.
hmm What else?....Oh thats right here are some more sweet things to ponder the mind on they are known as LINQ and BLINQ (pronounced Blink and Link). these are two newer languages that are being pretty much built by Polita Paulus (BLINQ) and Anders Hejlsberg (LINQ), what these two languages do is simply cut down on the amount of work you have to do in order to retrieve data out of the database, and it shows you better ways to work with and store that data, pretty much how to better optimize your database for speed, rather then relying on Caching or some other tricks.
Anyway I'm going to stop there because that should give you a bit of my personal insight into which language a person should learn, sorry if its unorganized or jumbled but have fun learning I sure have for the past 5 years or more.
Additionally Feel free to shoot some questions my way if you've got any and I'll do my best to answer then for you.