1 / 47

Oracle Apps Finance Training in Hyderabad

: orienit is the best Oracle Apps Finance Training institutes in Hyderabad.We Providing Oracle Apps Finance Training by realtime faculty in hyderabad.

orienit
Download Presentation

Oracle Apps Finance Training in Hyderabad

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 Oracle 10g Introduction & Installation Presented By

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

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

  4. Oracle10g www.orienit.com

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

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

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

  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 www.orienit.com

  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 www.orienit.com

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

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

  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 www.orienit.com

  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. www.orienit.com

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

  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 www.orienit.com

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

  17. 1st step www.orienit.com

  18. 2nd step www.orienit.com

  19. 3rd step www.orienit.com

  20. 4th step www.orienit.com

  21. 5th step www.orienit.com

  22. 6th step www.orienit.com

  23. 7th step www.orienit.com

  24. 8th step www.orienit.com

  25. 9th step www.orienit.com

  26. 10th step www.orienit.com

  27. 11th step www.orienit.com

  28. 12th step www.orienit.com

  29. 13 step www.orienit.com

  30. 14th step www.orienit.com

  31. 15th step www.orienit.com

  32. 16th step www.orienit.com

  33. 17th step www.orienit.com

  34. 18th step www.orienit.com

  35. finally www.orienit.com

  36. ORACLE Enterprise Manager 10g www.orienit.com

  37. Oracle SQL*Plus www.orienit.com

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

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

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

  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) www.orienit.com

  42. Tables Used in the Course EMPLOYEES JOB_GRADES DEPARTMENTS www.orienit.com

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

  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 www.orienit.com

  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 www.orienit.com

  46. PL/SQL Developer www.orienit.com

  47. For more information Visit us at www.orienit.com www.orienit.com

More Related