Computing.Net > Forums > Programming > best way to learn sql?

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.

best way to learn sql?

Reply to Message Icon

Name: alec eiffel
Date: June 2, 2005 at 10:47:45 Pacific
OS: linux or win 2003
CPU/Ram: 1g athalon
Comment:

I'm looking to learn about databases and it seems like sql is the way to go. I'm wondering what are the most common sql servers used in businesses today? (ms sql server 2000, mysql ...?) which should i learn? I also here there are different versions of the sql language based on what server you use. which is the most useful version?

thanks



Sponsored Link
Ads by Google

Response Number 1
Name: Acyf
Date: June 3, 2005 at 06:10:53 Pacific
Reply:

MSSQL Server, and Oracle seem to be the predominent engines in most business, although for freelance web development Mysql seems to on the top of the list, possibly because of it's licensing.

There is only one version of the sql language, it's a standard. However, Each database engine provides it's own additional features and support some or all of the sql language.

Picture it kind of like Learning C, for Lynix, and then trying to write a program for Windows. Most of your code will still be correct, but you will most likely have bits and peices that are Lynix specific and don't work on Windows.

Syntax does sometimes change from database to database, but when it does, it's usually easily recognizeable and a quick flip through the online manual will have you back on track.

Personally, I found Microsoft SQL Server the easiest to learn, followed closely by MySQL (Which may have been easier, but I was learning PHP at the time along with it). The only other database engines I've used are Interbase, Adaptive Server Anywher, and Microsoft Access.

My personal Preference simply from what I use most, is Microsoft SQL Server. I'm a Network Admin/DBA and MSSQL Server works well for me in that position.


0
Reply to Message Icon

Related Posts

See More


Which language to start? Game Programming Language...



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links

Ads by Google


Results for: best way to learn sql?

The BEST way to learn programming www.computing.net/answers/programming/the-best-way-to-learn-programming/379.html

Free n best way to learn www.computing.net/answers/programming/free-n-best-way-to-learn/4218.html

Would like to learn programming. www.computing.net/answers/programming/would-like-to-learn-programming/7060.html