1 / 46

ORACLE

ORACLE. Lecture 1: Oracle 10g Introduction & Installation. Overview. Introduction Installation Using SQL to Query Your Database Oracle SQL Developer. Scalability. One vendor. Reliability. Unified management. Single development model. Common skill sets. Oracle10 g. Oracle10 g.

lyle-holman
Download Presentation

ORACLE

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ORACLE Lecture 1: Oracle 10g Introduction & Installation

  2. Overview • Introduction • Installation • Using SQL to Query Your Database • Oracle SQL Developer

  3. Scalability Onevendor Reliability Unified management Single developmentmodel Commonskill sets Oracle10g

  4. Oracle10g

  5. Oracle Database 10g Object relational data Documents Multimedia Messages

  6. OracleApplication Server 10g Portals Transactional applications Business intelligence Integration Application development framework Application server

  7. Oracle Enterprise Manager 10g Grid Control • Software provisioning • Application service level monitoring

  8. Relational and Object RelationalDatabase 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

  9. Oracle Internet Platform Clients Anybrowser Anymail client AnyFTP client Internet applications SQL Business logic and data Presentation and business logic Development tools System management PL/SQL Application servers Databases Java Network services

  10. Strategy and analysis Design Build and document Transition Production System Development Life Cycle

  11. Data Storage on Different Media Database Electronic spreadsheet Filing cabinet

  12. 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

  13. Oracle server Table name: DEPARTMENTS Table name: EMPLOYEES … … Definition of a Relational Database • A relational database is a collection of relations or two-dimensional tables.

  14. Model ofsystemin client’smind Entity model ofclient’s model Table modelof entity model Oracle server Tables on disk Data Models

  15. 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

  16. Overview • Introduction • Installation • Using SQL to Query Your Database • Oracle SQL Developer

  17. 1st step

  18. 2nd step

  19. 3rd step

  20. 4th step

  21. 5th step

  22. 6th step

  23. 7th step

  24. 8th step

  25. 9th step

  26. 10th step

  27. 11th step

  28. 12th step

  29. 13 step

  30. 14th step

  31. 15th step

  32. 16th step

  33. 17th step

  34. 18th step

  35. finally

  36. ORACLE Enterprise Manager 10g

  37. Oracle SQL*Plus

  38. Overview • Introduction • Installation • Using SQL to Query Your Database • Oracle SQL Developer

  39. Communicating with an RDBMSUsing SQL SQL statement is entered. Statement is sent to Oracle server. SELECT department_name FROM departments; Oracle server

  40. Oracle’s Relational Database Management System Oracle server User tables Data dictionary

  41. SELECT INSERT UPDATE DELETE MERGE CREATE ALTER DROP RENAME TRUNCATE COMMENT COMMIT ROLLBACK SAVEPOINT GRANT REVOKE SQL Statements Data manipulation language (DML) Data definition language (DDL) Transaction control Data control language (DCL)

  42. Tables Used in the Course EMPLOYEES JOB_GRADES DEPARTMENTS

  43. Overview • Introduction • Installation • Using SQL to Query Your Database • Oracle SQL Developer

  44. 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

  45. 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

  46. PL/SQL Developer

More Related