Learning SQL

[stingman1]

Hello I was curious if there was a good way to learn SQL I see that there are several SQL servers out ther and saw some kind of mentions of a ANSI for SQL so is there a way to learn it and have it pretty much work on any server.
I know that the MySQL server doesnt support stored procedures like the MSSQL server and I know that there are probly some other little differences but I just wanted to find a way to shoot down the middle and cut the confusions. Steve Hagerman
Admin@Advancedisp.com

http://www.advancedisp.com

High Speed Internet access & services!

 

[pipk]

To be perfectly honest, you can learn SQL from most books, whether it is ansi sql or not, and be able to take this to any type of server or dbms. You will find that most dbms's support it, despite having afew implementations of their own as well. But the bulk of it is fairly generic and applicable everywhere. It is just a question of adapting from one platform to another as you go on.

 

[link9]

If you stick with ANSI standard SQL, you can port your statements to just about any RDBMS --

Like pipk said, there are a few statements that are system specific, but you won't find any of those in ANSI standard SQL.

There's sort of a debate going on about whether you should even use things such as stored procedures and other system specific functions and features because the more you use them, the more your system is locked into whatever RDBMS you happen to be using... but the special functions do yield performace gains over strict ANSI SQL solutions many times.

So the question is... how sure are you that the system you develop will stay on the same database platform? 100% sure? Then make use of every possible shortcut and trick that you can... and vice versa.


Paul Prewett