What to do with an oracle database?

[LuckyTaxi]

Say I wanna learn oracle 9i. What should I be doing in order to learn the database inside and out? I know it may sound like
a dumb question, but I'm coming from an environment consisting of mySQL and PHP, so I've been programming on the web.
What can connect to oracle if I were to program things via the web?

More importantly, trying to get certify as an oracle dba is what I'm looking for

 

[Mitzi]

Learning how to administer the Oracle 9i database is an absolutely huge task and to know it inside out is something which would take many years.

All I can suggest is download Oracle 9i (its free to download and use for educational/non commercial use), install it on your home machine and start playing. The download site is here. You will not be able to get very far with Oracle without afew good books - O'reillys reference books are amongst the best.

BTW - I'm not an Oracle DBA - I'm a Oracle Apps/PL/SQL programmer.

 

[tigerwannabe]

the oracle cd install pack has some cds dedicated to web stuff(internet file system, email server, applications interconnect). i suggest getting hold of some books, buying a copy of it, then diving right in 🙂 that's basically what i did, although i'm far from being an oracle expert. oracle is very powerful but a complicated piece of work. oracle's website at www.oracle.com can give you info on getting certified as a dba.

 

[LuckyTaxi]

<< BTW - I'm not an Oracle DBA - I'm a Oracle Apps/PL/SQL programmer. >>



That's something else I may look into. I was referring to mySQL and PHP cuz that's something I would like
to do with eithr DB2 or Oracle. Does Oracle have its own server-side scripting lanaguage that can
connect to its database?

 

[FUBAR]

php can do oracle, just gotta change your connection lines, and of course make sure you have the support for oracle compiled into php