SQL Boot Camp

What is the best database language to learn?
I am a web designer, and recently I\'ve been faced with a need for databases.
I was able to get by with an MS Access database, but in the future I'd like to be more professional.
I've heard about Oracle, MySQL, and SQL databases. What are the differences between them?


Subscribe to SqlBootCamp Newsletter

Get our latest posts delivered to your inbox ...

We respect your email privacy

if you\'re developing with PHP you\'ll want to use MySQL.\n\nfor ASP you\'ll likely be using MS SQL server
mysql will be good as it is hugly used on net because its easy and free and you have large number of resources , source codes , and other developers to help you learn and deploy
The difference, from a developers point of view, between them is dialect extensions. Oracle uses PL/SQL, Microsoft and Sybase use T-SQL, and MySQL uses MySQL SQL. Another thing to keep in mind is that SQL Server from Microsoft only runs on the windows platform. The others are cross-platform. In addition, whether you decide to develop using ASP or PHP, you will be able to use any of the database systems for your web apps. ASP works very well with Microsoft SQL Server since they are developed and sold by the same company. PHP has built in functions for using the MySQL system. Also, ASP and PHP can be used in conjunction with an Oracle database. While you are making your decision, keep in mind that learning standardized SQL will allow you to write scripts/queries for any major database system.