Both my friend and I are interested in learning SQL and know absolutely nothing about it or databasing. She has a degree in electrical engineering and I have done a lot of C++ programming.
I was hoping someone could answer some general questions that would point the way to start learning SQL.
Would I be correct in thinking that SQL is general language that can be used for deposting/retrieving information from a variety of differnt database software packages and that oracle, sequel server, access etc are examples of database sotware packages?
Is there a standard SQL? What is the latest version of this standard? Does Microsoft SQL Server 7 use standard SQL or do they pollute it like Java. If my friend and I learned SQL on MS SQL Server 7 would we be able to take the sql there and use it in other databases with a minimum of trouble?
Can you reccomend a good SQL book for my friend and I given our background? What about software to practice sql programming with? My friend and I have VB 6. Can we use that to practice what we learn from an sql book? If so, how? If not, can you recccomend software for practicing sql with that could be put on a pc?