ORACLE Lecture 1 Oracle 10 g Introduction Installation

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

Overview Introduction Installation Using SQL to Query Your Database Oracle SQL Developer

Oracle 10 g One vendor Scalability Reliability Single development model Unified management Common skill sets

Oracle 10 g

Oracle Database 10 g Object relational data Documents Multimedia Messages

Oracle Application Server 10 g Portals Transactional applications Business intelligence Integration Application development framework Application server

Oracle Enterprise Manager 10 g 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 mail client FTP client Internet applications Business logic Presentation 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

1 st step

2 nd step

3 rd step

4 th step

5 th step

6 th step

7 th step

8 th step

9 th step

10 th step

11 th step

12 th step

13 step

14 th step

15 th step

th 16 step

17 th step

18 th step

finally

ORACLE Enterprise Manager 10 g

Oracle SQL*Plus

Overview Introduction Installation Using SQL to Query Your Database Oracle SQL Developer

Communicating with an RDBMS Using SQL statement is entered. SELECT department_name FROM departments; Statement is sent to 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 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_jdk 5. jsp

PL/SQL Developer