- History Of Oracle:
Oracle is most widely used Database Management System in most of the Companies.Oracle uses SQL pronounced as ‘Sequel’ language to data manipulation and operations on data.I am explaining History of Oracle in this article. ‘SEQUEL’ stands for ‘Structured English Query Language’ which is developed by IBM Corporation limited to use codd’s model in 1979.In 1979 Oracle introduced first commercially available implementation of SQL.Now SQL is called as Standard RDBMS language.Oracle Corporation was started by two computer programmers, Larry Ellison and Bob Miner in 1977. Both Larry and Bob had prior experience in building database programs for different companies. Their first project was building a special database program for the CIA (Central Intelligence Agency).
Larry Erison is the father of Oracle who has started the company named Software Development Laboratory in 1977.Now This Company is known as ‘Oracle Corporation’
- Different Versions Of Oracle:
- In 1977, SEL (Software Development Laboratory) … V1
- In 1979, RSI (Relational S/W Incorporation) …. V2
- In 1983, Oracle Corporation à Oracle 3 [Developed Using ‘C’, which supports simple queries but does not support transactions]
- In 1984, Oracle 4 à Supports Transactions [Commit/Rollback]
- In 1985, Oracle 5 à Client-Server Architecture [Only install DB in Server, so that ‘N’ no of Clients can connect is known as Client-Server Architecture].
- In 1989, Oracle 6 à PL/SQL
- In 1992, Oracle 7 à Supports DWH [OLAP-Online Analytical Processing]
- In 1997, Oracle 8 à ORDMBS
- In 1999, Oracle 8i à ‘I’ means Internet & it has inbuilt JVM (JAVA Virtual Machine)
- In 2001, Oracle 9i à with 400 New features, e.g. XML (Xtended Markup Language), RAC (Real Application Clusters) etc which provided high availability & performance.
- In 2003, Oracle 10g à ‘g’ means grid (group of DB Servers)
- In 2006, Oracle 11g àwe can add columns with values etc.
Oracle SQL lanuagage is very easy to understand and user friendly language.If you understands english you will easily understand SQL Language.You will do anything with a data using oracle SQL language.
“So now dont Waste your time and let us start learning Oracle SQL..”
SQL Tutorials and Topics:
- SQL Create Table
- SQL Select Statement Execution
- Views in SQL
- Materialized View in SQL
- Joins in SQL
- Inner Join / Outer Join
- Full Outer Join / Cartesian Join
- Union and Union ALL
- Intersect and Minus
- Indexing in SQL
- Rank and Dense Rank
- SubQueries and Correlated Subqueries
- Parser and Optimizer
- Oracle 11 G new Features