Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 879
  • Last Modified:

RDBMS Concepts with Oracle Database

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?
0
systemsautomation
Asked:
systemsautomation
3 Solutions
 
Franck PachotCommented:
Hi,
I think the table of content of the Oracle® Database Concepts is a good start.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm
Regards,
Franck.
0
 
schwertnerCommented:
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:
- SELECT
- DML (Data manipulation language) - INSERT, UPDATE, DELETE
- DDL (CREATE TABLE, CREATE USER, ....)
-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
0
 
sdstuberCommented:
who is your audience?

developers?
dbas?  
architects?
business analysts?

All of the above suggestions seem good but you should tailor the course for the audience.
0
 
systemsautomationAuthor Commented:
Thaks to all of you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now