Versions Means

Oracle                      Microsoft      Sybase     IBM    Open Source

2.0                                    2.5            unix           DB2         MYSql
3.0                                    3.5           .                                  Postgre
4.0                                   4.5                                               Ingres
6.0                                    6.5                                              Informix
7.0 Application Base         7.0
8.0                                  2000
8i Web Base                   2005
9i                                     2008
10g Grid Computing
11i

Versions

  9.0.0.0.0  -------- Minor Patch
  9.0.0.1.0  -------- Major Patch
  9.0.2.1.0 --------- Minor Release
  9.4.2.1.0  ---------Major Release
10.0.0.0.0  -------   Version

Database Concept

What is data?
Row facts and Figure.

Collection of information  in organized manner is called database

DBMS:Database Management Syastem
is a program that stors,retrives and motifies data in the database on request.

Types of database:
1)Hierachical
2)Network
3)Relational
4)Object relational

E_R Diagram

Entity:A group of real thing

DBMS: examples Msexcel,MS Access

RDMS
1970- by Dr.E.F Codd
Some Rules
Oracle follows 11.2 Rules

Four Rules:-
1.Data must be accessible.
2.Data must be in Tabular Form.
3.There must be relationship between rows and coloumns.
4.There are some rules and operation to maintain there relationship.

Types of Relatioinships
1.One to One
2.One to many
3.Many to Many.

Types Of Joins

Cartesiion Product
When a join condition is invalid or omitted completely , the result is a Cartesian product first tables are joined to all rows in second table.




Numberof rows in Ist table * number of rows in IInd table = Cartesion Product


Oracle Proprietary Joins                                                     

1. EquiJoin
2. Non-Equijoin
3. Outer Join
4. Self Join

SQL:199

1. Cross Joins
2. Natural Joins
3. Using Clause
4. Full or two sided Outer Joins
5. Arbitrary Joins Conditions For Outer Joins .

To join n tables together we need a mininum of (N-1) join contions

Equi Join

Also known as simple Joins,Inner Joins This type of joins involved primary and foreign key complements.
Example:
SELECT e.last_name,d.department_name,l.city
FROM employees e,department d,location l
WHERE e.departmnt_id=d.department and d.location_id=l.location_id.

Oracle Certifications

Oracle University Provides various Certification as Fallows: