This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Oracle database designing issues Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Oracle database designing issues" Watch "Oracle database designing issues" New topic

Oracle database designing issues

Brendon Woodford
Ranch Hand

Joined: Jan 22, 2010
Posts: 53
Dear all,
I am working as a java professional and sometimes I also double up as a Oracle8i database programmer which I enjoy doing. I have written code for creating tables, used referential integrity, and have taken part in normalization up to 3rd NF.

The question is What I should do more to qualify as a database designer?

Please advise.
Thank you all.
Charles Owen
Ranch Hand

Joined: Aug 31, 2009
Posts: 61
To really qualify as a database programmer in Oracle, you need to master PL/SQL and SQL. I suggest picking up a good book, such as Murach's Oracle SQL or an Oracle Press book on Oracle PL/SQL. You need to learn to create Oracle stored procedures and user-defined functions. You will also want to learn to use Oracle Packages as a way to modularize your PL/SQL application just as you would a Java application. If you are doing any programming, then learn the Oracle API for .NET with ADO.NET and/or Java with JDBC.

I'd also suggest subscribing to some of the PL/SQL forums on the Oracle website. It will also be a great resource if you get stuck with something or you just want to learn the best practices.

You mentioned you are working with Oracle 8i. That's a really old version. I suggest learning 10g at a bare minimum. You can download the a free version of Oracle, called Oracle Express, onto your own computer and play with it just as you would an Oracle server. Once again, you can find that on the Oracle web site. I really recommend the Murach's book as a good starting point. It provides a lot of exercises to practice what you learned.
It is sorta covered in the JavaRanch Style Guide.
subject: Oracle database designing issues
Similar Threads
jdbc odbc driver
formatting output columns
Writing databse scripts which inturn checks for the tables, columns and constraints
How do you implement Web Services security?
database value in backingBean