Re: NewBie type Oracle question

waichoi_at_yahoo.com (Unbreakable) wrote in message news:<3c38d571.0310100136.3c478ee2_at_posting.google.com>...
> I am getting my OCP and understand that the cert is just a beginning
> and I do need a working expereience.
>
> Therefore, I wish to develop a simple project for skill demostration
> purpose.
>
> I would like to know the set of tools as the experience people use in
> the market.
>
> My freind, who work as Junior DBA, is using the following tools.
>
> A. Oracle 9i (Of course)
> B. Tord (Sql statement)

its Toad. Not Tord. Anyone can learn to use this. dont mess with GUIs until you get the command line stuff. Stick with sqlplus. Any company that requires 'toad experience' is a company of knuckleheads anyway.

> C. Eclipse (Java Code)

Oracle's jdeveloper is better for working with oracle. it will right most of your jdbc code for you. Its gui driven. Its drag and drop gui development tool is weak... , but the rest is pretty decent. If you dont know java, dont touch it yet. You cant learn everything at once.
> D. Microsoft Visio (Develop a schema)
never used it. Ive seen it used for flowcharting,uml, etc... Most oracle people use Oracle Designer(complex. dont mess with this yet either) or Erwin. Easy to use, but no free versions out there.
>
>
> 1. Any more addtional tools or something that I am missing here?
> 2. any sample code/project that can be recommend? I find out the pet
> store in java.sun.com is too complicated for beginner.
>
> Any better site?

9i oracle has a pretty good set of sample database schemas to play with. previous versions did not. Feurstein has a book with PL/sql workbook type questions. The prentice hall workbooks(which are out of print, but there amy be some used ones) have decent sql,pl/sql, and dba workbooks with sample schema and exercises.

nothing else out there really with exercises. Its the biggest weakness in the literature.

Just stick with installing 9i oracle which you can get from otn.oracle.com and creating the sample schema(you can select to this when you install the database from a GUI). Then use sqlplus. Its the command like sql editor. Best way to learn.

BTW, your not actually paying for one of those worthless OCP courses are you? They are a scam. Dont waste your money. Received on Fri Oct 10 2003 - 12:15:33 CDT