ORACLE Oracle 10g Introduction & Installation
Presented By
Overview Introduction Installation Using SQL to Query Your Database Oracle SQL Developer
www.orienit.com
Oracle10g One vendor
Scalability
Reliability
Single development model
www.orienit.com
Unified management
Common skill sets
Oracle10g
www.orienit.com
Oracle Database 10g Object relational data
Documents
Multimedia
Messages
www.orienit.com
Oracle Application Server 10g Portals
Transactional applications
Business intelligence
Integration
Application development framework
www.orienit.com
Application server
Oracle Enterprise Manager 10g Grid Control ď‚— Software provisioning ď‚— Application service level monitoring
www.orienit.com
Relational and Object Relational Database Management Systems ◦ Relational model and object relational model ◦ User-defined data types and objects ◦ Fully compatible with relational database ◦ Support of multimedia and large objects ◦ High-quality database server features
www.orienit.com
Oracle Internet Platform Clients Any Any mail client FTP client
Internet applications Business logic Presentation and and data business logic Databases
Application servers
Network services
www.orienit.com
Development tools
System management
Any browser
SQL PL/SQL Java
System Development Life Cycle Strategy and analysis Design Build and document Transition Production
www.orienit.com
Data Storage on Different Media
Electronic spreadsheet
Database Filing cabinet
www.orienit.com
Relational Database Concept ◦ Dr. E. F. Codd proposed the relational model for database systems
in 1970. ◦ It is the basis for the relational database management system (RDBMS). ◦ The relational model consists of the following: ◦ Collection of objects or relations
◦ Set of operators to act on the relations ◦ Data integrity for accuracy and consistency
www.orienit.com
Definition of a Relational Database A relational database is a collection of relations or two-dimensional tables.
Oracle server
Table name: EMPLOYEES
… www.orienit.com
Table name: DEPARTMENTS
…
Data Models
Model of system in client’s mind
Entity model of client’s model Table model of entity model
www.orienit.com
Oracle server
Tables on disk
Relational Database Properties A relational database: ◦ Can be accessed and modified by executing structured
query language (SQL) statements ◦ Contains a collection of tables with no physical pointers ◦ Uses a set of operators
www.orienit.com
Overview Introduction Installation Using SQL to Query Your Database Oracle SQL Developer
www.orienit.com
1st step
www.orienit.com
2nd step
www.orienit.com
3rd step
www.orienit.com
4th step
www.orienit.com
5th step
www.orienit.com
6th step
www.orienit.com
7th step
www.orienit.com
8th step
www.orienit.com
9th step
www.orienit.com
10th step
www.orienit.com
11th step
www.orienit.com
12th step
www.orienit.com
13 step
www.orienit.com
14th step
www.orienit.com
15th step
www.orienit.com
16th step
www.orienit.com
17th step
www.orienit.com
18th step
www.orienit.com
finally
www.orienit.com
ORACLE Enterprise Manager 10g
www.orienit.com
Oracle SQL*Plus
www.orienit.com
Overview Introduction Installation Using SQL to Query Your Database Oracle SQL Developer
www.orienit.com
Communicating with an RDBMS Using SQL SQL statement is entered.
Statement is sent to Oracle server.
SELECT department_name FROM departments;
Oracle server
www.orienit.com
Oracle’s Relational Database Management System Oracle server
User tables
www.orienit.com
Data dictionary
SQL Statements
SELECT INSERT UPDATE DELETE MERGE
Data manipulation language (DML)
CREATE ALTER DROP RENAME TRUNCATE COMMENT
Data definition language (DDL)
COMMIT ROLLBACK SAVEPOINT GRANT REVOKE
www.orienit.com
Transaction control
Data control language (DCL)
Tables Used in the Course EMPLOYEES
DEPARTMENTS
www.orienit.com
JOB_GRADES
Overview Introduction Installation Using SQL to Query Your Database Oracle SQL Developer
www.orienit.com
What Is Oracle SQL Developer? ď‚— Oracle SQL Developer is a graphical tool that enhances
productivity and simplifies database development tasks. ď‚— You can connect to any target Oracle database schema by
using the standard Oracle database authentication.
www.orienit.com
SQL Developer
Specifications of Oracle SQL Developer ◦ Developed in Java ◦ Supports Windows, Linux, and Mac OS X platforms ◦ Default connectivity by using the JDBC Thin driver ◦ Does not require an installer ◦ Unzip the downloaded Oracle SQL Developer kit and double-click sqldeveloper.exe to start Oracle SQL Developer. ◦ Connects to any Oracle Database, version 9.2.0.1 and later ◦ Freely downloadable . ◦ Needs JDK 1.5 installed on your system, which can be
downloaded from the following link:
◦ http://java.sun.com/javase/downloads/index_jdk5.jsp
www.orienit.com
PL/SQL Developer
www.orienit.com
For more information Visit us at www.orienit.com
www.orienit.com