RDBMS Concepts with Oracle Database

Posted on 2009-07-15
Last Modified: 2012-05-07
I have been asked to arrange a training session on "RDBMS Concepts with Oracle Database"
and prepare a course outline.

Can anyone provide me a course outline on this?
Question by:systemsautomation
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 15

Accepted Solution

Franck Pachot earned 200 total points
ID: 24857099
I think the table of content of the Oracle® Database Concepts is a good start.
LVL 48

Assisted Solution

schwertner earned 150 total points
ID: 24857156
You have to begin with Dr. Codd rules and explain them.
After that:
1. Explain the table concepts in Oracle - this is the notion 'relation' in the theory, but also means that tables could be joined rowwise (related).
2. Explain the Dictionary of Oracle (metadata about the tables, indexes, sequences, etc.).
This is one of the rules of Dr. Codd - all data about the DB should be inside the DB
3. Explain the logical and physical tiers of the DB and the independence - logical structures are not dependent by the physical structure.
Example: A tablespace comprises tables and indexes (tablespace is logical unit). But a tablespace comprises OS files. You can add new files to the tablespace, move files to different disk drives. This physical changes do not reflect the logical unit. They belong to different layers of abstractions.

After that (depending on the time) explain:
- DML (Data manipulation language) - INSERT, UPDATE, DELETE
-DCL ( Data Control Language)

Pay attention to the notion "Transaction".
Explain what is a transaction - set of DML statements that are atomic.
Explain COMMIT and ROLLBACK statements
LVL 14

Assisted Solution

shru_0409 earned 150 total points
ID: 24857400
LVL 74

Expert Comment

ID: 24860713
who is your audience?

business analysts?

All of the above suggestions seem good but you should tailor the course for the audience.

Author Closing Comment

ID: 31603618
Thaks to all of you

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Error in creating a view. 8 52
populate value based on what is selected in lov 2 68
Read CLOB data from Oracle using JAVA 3 45
Oracle statistik 3 18
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question