Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!sn-xit-03!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Daniel Morgan Newsgroups: comp.databases.oracle.server Subject: Re: NewBie type Oracle question Date: Fri, 10 Oct 2003 08:49:42 -0700 Organization: ATS Message-ID: <1065800993.669362@yasure> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <3c38d571.0310100136.3c478ee2@posting.google.com> In-Reply-To: <3c38d571.0310100136.3c478ee2@posting.google.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@pond178.drizzle.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 42 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:245039 Unbreakable wrote: >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) >C. Eclipse (Java Code) >D. Microsoft Visio (Develop a schema) > > >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? > > I'd suggest making the only tool for direct database access SQL*Plus. We all use tools. But they are not a good way to learn syntax. Stay away from TOAD, SQL Navigator, etc. for at least a year. I'd suggest Designer and ERwin are far superior to Visio. In fact Visio is near worthless unless your understanding of Oracle is going to start and stop with columns and rows. -- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)