Introduction to Oracle Database Administration
http://www.xoomtrainings.com/course/oracle-dba
3-tier Architecture DATABASE
Network
End-User
Network
Application Server Application Software's Application Logic Websites
DATA
http://www.xoomtrainings.com/course/oracle-dba
DATA Every organization has some information needs. • A library keeps a list of members, books, due dates, and fines. • A company needs to save information about its employees, departments, and salaries.
These pieces of information are called data.
http://www.xoomtrainings.com/course/oracle-dba
http://www.xoomtrainings.com/course/oracle-dba
Database • A database is an organized collection of data for one or more purposes, usually in digital form.
http://www.xoomtrainings.com/course/oracle-dba
Oracle Database DB2
ORACLE 50% of Market Share
INFORMIX
SYBASE
SQL SERVER
http://www.xoomtrainings.com/course/oracle-dba
Relational Database • A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E.F. Codd.
http://www.xoomtrainings.com/course/oracle-dba
http://www.xoomtrainings.com/course/oracle-dba
Relational Database
SQL
End-User
• Retrieve Data • Insert Data • Modify Data • Remove Data
DATABASE
DATA Tables
http://www.xoomtrainings.com/course/oracle-dba
http://www.xoomtrainings.com/course/oracle-dba
http://www.xoomtrainings.com/course/oracle-dba
History of Oracle Database
ORACLE
http://www.xoomtrainings.com/course/oracle-dba
History Oracle Database • In 1977, Larry Ellison, Bob Miner and Ed Oates founded Software Development Laboratories • After reading a paper by Codd in IBM Journal of Research & Development, they created Oracle. (written in Assembly language PDP) • Version 2.0 of Oracle was released in 1979 & The company changed its name to Relational Software Inc. (RSI) • In 1982, RSI was renamed to Oracle Corporation. • In 1983, Oracle released version 3.0, which was rewritten in C. • In 1984, Oracle 4.0 & In 1985 version Oracle 5.0 released.
http://www.xoomtrainings.com/course/oracle-dba
• In 1986, Oracle goes public on the NASDAQ exchange. • In 1988, Oracle version 6.0 was released. (It provided row-level locking, hot backup and PL/SQL) • In 1992, Oracle 7.0 released. It provided better performance, administrative utilities, application development tools, security features, stored procedures, triggers and declarative integrity. • In 1997, Oracle released Oracle 8.0. It started embracing Java. Partitioning, support for images, large text, external data etc.(lobs) are provided. *Started support for Object in database (Object-Relational DBMS) • By 1999, Oracle released Oracle 8i. Supported for XML, Java Virtual Machine (JVM) to run Java program in Database and also scalability, which was required for internet databases.
http://www.xoomtrainings.com/course/oracle-dba
History Oracle Database • In 2001, Oracle9i was released. Allows Oracle to run on RAC. • In 2003, Oracle10g was released, where g stands for Grid computing. • In 2007, Oracle has released Oracle11g.
Employing nearly 1,08,000 people worldwide as of 31 May 2011.
http://www.xoomtrainings.com/course/oracle-dba
Responsibilities of Administrator Enforcing Data INTEGRITY
RECOVERING DATA
ASSIST PROGRAMMERS
Providing AVAILABILITY
Maintaining SECURITY
DATABASE
PERFORMANCE
Questions?
http://www.xoomtrainings.com/course/oracle-dba
THANK YOU for attending Demo of Oracle DBA
Call : +1-610-686-8077 , Email : sales@xoomtrainings.com