1 / 24

Objectives

Objectives. PL/SQL And Application Programming Application Models Documentation SQL and PL/SQL tools BrewBeans & MoreMovies Databases SQL SELECT Statement Syntax. Procedural Languages. Programming languages allow actions of the end user to be converted to computer instructions

paytah
Download Presentation

Objectives

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. Objectives PL/SQL And Application Programming Application Models Documentation SQL and PL/SQL tools BrewBeans & MoreMovies Databases SQL SELECT Statement Syntax

  2. Procedural Languages Programming languages allow actions of the end user to be converted to computer instructions Procedural languages allow the inclusion of logic processes PL/SQL is a procedural language, SQL is not a procedural language

  3. Application Programming Example application screen

  4. Brewbean’s Application Processing needed to support the shopping cart check out button Verify quantities are > 0 Calculate shipping cost Calculate taxes Check/update product inventory Check shopper profile for credit card information

  5. The PL/SQL Language Proprietary Oracle language Tightly integrated with SQL Can increase performance by grouping statements into blocks of code Portable to any Oracle platform Used within many Oracle tools Stored program units can increase security

  6. Application Models Three main components User interface or screens Program logic (brains behind the screens) Database Most models are based on a two- or three-tier structure

  7. Two-tier Model Commonly referred to as client/server Parts of the processing occur both on the user’s computer and the database server Named or stored program units are blocks of PL/SQL code saved in the Oracle database to provide server-side processing

  8. Two-tier Diagram

  9. Three-tier Model Thin client with no code loaded on the user machine (browser access) Middle tier is the application server – Forms server for Oracle Last tier is the database server Processing load is on the middle and last tier Maintenance is simplified

  10. Three-tier Diagram

  11. Oracle Documentation Oracle Technology Network (OTN): otn.oracle.com Doc directory on CDs distributed by Oracle

  12. Software Used SQL*Plus – Oracle10g Other software introduced in appendices Oracle SQL Developer TOAD

  13. SQL*Plus Client Interface

  14. SQL*Plus Internet Interface Named iSQL*Plus

  15. Third-party Tools TOAD Rapid SQL PL/SQL Developer SQL-Programmer PLEdit FROG

  16. The Brewbean’s Company Retails coffee and brewing equipment via the Internet, phone, and stores Used in chapter explanations, examples, and exercises Databases create script provided for each chapter

  17. ERD for Brewbean’s DB

  18. More Movies ERD Movie rental company used in an ongoing case study

  19. SQL Query Syntax SELECT <columns> FROM <tables, views> WHERE <conditions> GROUP BY <columns> HAVING <aggregation conditions> ORDER BY <columns>;

  20. Traditional Join

  21. ANSI Join

  22. Using Aggregate and WHERE

  23. Creating Tables

  24. DML Statements

More Related