Transcript ORACLE Lecture 1: Oracle 10g Introduction & Installation Copyright © 2004, Oracle. All rights reserved.

ORACLE
Lecture 1:
Oracle 10g Introduction & Installation
Copyright © 2004, Oracle. All rights reserved.
Overview
Introduction
 Installation
 Using SQL to Query Your Database
 Oracle SQL Developer

Oracle10g
One
vendor
Scalability
Reliability
Single
development
model
Unified
management
Common
skill sets
Oracle10g
Oracle Database 10g
Object relational data
Documents
Multimedia
Messages
Oracle Application Server 10g
Portals
Transactional applications
Business intelligence
Integration
Application
development
framework
Application
server
Oracle Enterprise Manager 10g
Grid Control
◦ Software provisioning
◦ Application service level monitoring
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
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
Development tools
System management
Any
browser
SQL
PL/SQL
Java
System Development Life Cycle
Strategy
and
analysis
Design
Build
and
document
Transition
Production
Data Storage on Different Media
Electronic
spreadsheet
Database
Filing cabinet
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
Definition of a Relational Database

A relational database is a collection of relations or twodimensional tables.
Oracle
server
Table name: EMPLOYEES
…
Table name: DEPARTMENTS
…
Data Models
Model of
system
in client’s
mind
Entity model of
client’s model
Table model
of entity model
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
Overview
Introduction
 Installation
 Using SQL to Query Your Database
 Oracle SQL Developer

1st step
2nd step
3rd step
4th step
5th step
6th step
7th step
8th step
9th step
10th step
11th step
12th step
13 step
14th step
15th step
th
16
step
17th step
18th step
finally
ORACLE Enterprise Manager 10g
Oracle SQL*Plus
Overview
Introduction
 Installation
 Using SQL to Query Your Database
 Oracle SQL Developer

Communicating with an RDBMS
Using SQL
SQL statement is entered.
SELECT department_name
FROM
departments;
Statement is sent to
Oracle server.
Oracle
server
Oracle’s Relational Database
Management System
Oracle
server
User tables
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 Transaction control
SAVEPOINT


GRANT
REVOKE
Data control language (DCL)
Tables Used in the Course
EMPLOYEES
DEPARTMENTS
JOB_GRADES
Overview
Introduction
 Installation
 Using SQL to Query Your Database
 Oracle SQL Developer

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.
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 doubleclick 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
PL/SQL Developer