I've done about 4 weeks of SQL at around 2 hours per day which means I already know my way around the language a bit. On my 5th week I'm starting SQL Server 7 but while I was browsing the fora here, somebody suggested that I explore the Oracle path.
I visited the Oracle site, and they have the new 10g as well as the previous 9i, however the number of products and paths just overwhelmed me, plus the fact that I have to learn PL/SQL. The move to Oracle is a good suggestion (which I will do in week 8 after I know my way around SQL Server 7) but I have a few prep questions:
1. What advantage do I get from learning 10g at home (deciding whether to d/l 10g or 9i & Dev Suite)?
2. Right now, the paths are not clear yet, and a thread here suggested the Oracle Database Concepts Guide. Is this a white paper? I did a web search (Google) for that particular string and didn't find any "Guide" except for the one for App Server. The Oracle site also got me lost (I visited the OTN section). Can anyone point me to the right direction?
3. (Depending on #1 above) Which particular components of Dev Suite should I get (or do I just get all)?
4. There is a copy of Oracle RDB8 somewhere in the archived cds here, what is this and can I use this instead of 9i or 10g? - I actually installed it but didn't know enough to even create a database from the SQL screen (which means I have to read more).