Oracle Consulting and Training
For Better, Faster, Smarter
Oracle Training To Help Make Your Systems Better, Faster
For more valuable Oracle tips and tricks just subscribe to our ezine and every month we'll send you tips
and tricks to help you make your Oracle systems better, faster and smarter.
OCP resource recommendation
What is normalisation?
From: Walter Rieppi - In this year i would like to try the Oracle exam to pass the OCP
certification. I have a subscription to oracle magazine. I heard about another magazine which
name is Oracle internal. What do you think about this
magazine. Is the article easy for a newbie in Oracle
or are so complicated and i can't understand it?
We haven't come across that magazine, so we can't
comment on it. However we can say that the best way to
learn enough about Oracle to be able to pass the Oracle
certification exams is to download the software from the
Oracle Technology Network, (see the resources page for
the link). Once you've installed the software, test backup
and recovery, sql, changing database parameters etc.
You also need to know the theory and the best way to do
this is to buy a few decent Oracle books including the
certification guide (see the resources page for
recommendations) or for a short cut consider taking of our scheduled Oracle training courses. We would
also recommend you consult our condensed version of the certification process.
From: shiva shankar - What is the exact definition of normalisation? How many types are there?
please explain them in detail.
Normalization is the process of decomposing objects into their constituent parts, removing repeating
groups and any items not functionally dependent on the key. The process was defined by Dr. E.F. Codd in
1970 when he defined the relational (database) model.
There are 6 levels of normalization called normal forms (abbreviated NF): 1st normal form (1NF); 2nd
normal form 2NF; 3rd normal form (3NF); Boyce-Codd normal form (BCNF); 4th normal form (4NF); and
5th normal form (5NF). Each is a refinement of the previous normal form, although it is very rare to
progress beyond 3NF.
It should be stressed that normalization is an analysis tool, not a programming tool, so in practice most
databases will be denormalized to a certain extent to improve performance. The trade off is redundant
storage of information.
Use the contact form to send us your questions and feedback and to subscribe just click here.
For more Oracle help, see the many free articles and tutorials we have on our site. We also offer Oracle
training for developers and dbas both on and off site. The resources page has recommendations for further
reading to enhance your knowledge of Oracle and contains links to information on OTN and other places.
Looking to sky-rocket productivity, save time and reduce costs?Training is a highly cost-effective and
proven method of boosting productivity. Smartsoft offers instructor-led training in Oracle and related
technologies on or off site in cities across the UK as well as self-study online training. See our scheduled
Oracle training courses, or let us know your requirements.
Oracle tips and tricks Subscribe to our newsletter, jam-packed full of tips and tricks to help you slash costs, sky-
rocket productivity and make your systems better, faster and smarter.
© Smartsoft Computing Ltd, Bristol, England
Need help? Contact Us
This site uses woopra.com to gather statistical information about our visitors. This data is aggregated to show industry
trends (such as browser share). However, this data shall be the average of many thousands of visits and is in no way
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their