Transcript Lecture 1
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