DFo_6_1_ORACLE APPLICATION EXPRESS (APEX)-1.pdf

Database Foundations 6-1 Introduction to Oracle Application Express Copyright © 2019, Oracle and/or its affiliates. All rights reserved. Roadmap You are here Structured...

Database Foundations 6-1 Introduction to Oracle Application Express Copyright © 2019, Oracle and/or its affiliates. All rights reserved. Roadmap You are here Structured Data Introduction to Data Definition Transaction Query Manipulation Oracle Language Control Language Language Application (DDL) Language (TCL) (SQL) (DML) Express (APEX) Retrieving Restricting Sorting Data Joining Tables Data Using Data Using Using ORDER Using JOIN SELECT WHERE BY DFo 6-1 Copyright © 2019, Oracle and/or its affiliates. All rights reserved. 3 Introduction to Oracle Application Express Objectives This lesson covers the following objectives: – Distinguish between application software and system software and give an example of each – Log-in to the Oracle Application Express practice environment – Execute a simple query to retrieve information from the Database – Apply the rules of SQL to display all columns and a subset of columns specified by criteria DFo 6-1 Copyright © 2019, Oracle and/or its affiliates. All rights reserved. 4 Introduction to Oracle Application Express Purpose Every day, in one way or another, we come in contact with computer applications. – If you checked your email today, it was probably done using an application. – If you bought an item at a grocery store, the clerk scanned the item using an application that calculated your bill and updated the store inventory. In this course, you will learn the syntax of SQL using the application called Oracle Application Express. DFo 6-1 Copyright © 2019, Oracle and/or its affiliates. All rights reserved. 5 Introduction to Oracle Application Express  Application Programs Although computers have been around for a very long time (possibly before you were born), their use for business and personal computing didn't take place until application software programs were developed. Application programs allowed the end user—people like you and me—to be able to buy fully developed, ready- to-use programs. It was no longer necessary to know how the program worked, just that it did work and accomplished what we wanted it to do. DFo 6-1 Copyright © 2019, Oracle and/or its affiliates. All rights reserved. 6 Introduction to Oracle Application Express  Application Programs Yahoo.com uses the Oracle database to store data. Rather than having everyone who wants to search the database or retrieve email learn SQL, an application has all of the SQL (and other coding languages) pre- programmed into it. With a few mouse clicks, users have access to all of the information they need. DFo 6-1 Copyright © 2019, Oracle and/or its affiliates. All rights reserved. 7 Introduction to Oracle Application Express  Using Applications An application is like a car. – To drive a car, you need to know enough to make it work. – It has a friendly “shell” to hide all the things that you don’t need to know, such as how the transmission works or how fuel like petrol or diesel is used to power the engine. Could you ever get your driver's license if you had to demonstrate an understanding of every system— electrical, powertrain, hydraulic, fuel, etc.—used to make the car run? DFo 6-1 Copyright © 2019, Oracle and/or its affiliates. All rights reserved. 8 Introduction to Oracle Application Express Oracle Application Express Oracle Application Express is a web application development, deployment, and maintenance tool. Oracle APEX DFo 6-1 Copyright © 2019, Oracle and/or its affiliates. All rights reserved. 9 Introduction to Oracle Application Express Oracle Application Express Components Oracle Application Express has these components: – SQL Workshop – Application Builder – Object Browser To learn SQL, you will use the SQL Workshop component. To design an application, you use Application Builder. For instruction on using APEX please refer to the APEX Student Guides Section 0. DFo 6-1 Copyright © 2019, Oracle and/or its affiliates. All rights reserved. 10 Introduction to Oracle Application Express Project Exercise DFo_6_1_Project – Oracle Baseball League Store Database – Upload and run a script in APEX DFo 6-1 11 Copyright © 2019, Oracle and/or its affiliates. All rights reserved. Introduction to Oracle Application Express Basic SELECT Statement The SELECT * command returns all the rows in a table. – The syntax is: SELECT * FROM ; For example: SELECT * FROM employees; DFo 6-1 Copyright © 2019, Oracle and/or its affiliates. All rights reserved. 12 Introduction to Oracle Application Express SELECT Statement with a Condition To return a subset of the data, modify the SELECT statement. – The syntax is: SELECT FROM WHERE ; For example: SELECT first_name, last_name, job_id FROM employees WHERE job_id = 'SA_REP'; DFo 6-1 Copyright © 2019, Oracle and/or its affiliates. All rights reserved. 13 Introduction to Oracle Application Express Correcting errors When entering SQL commands, it is important to use the correct spelling, otherwise you will get an error message. For example (SELECT: spelling incorrect): Would result in the error message: SEECT * FROM employees; To rectify, simply correct the spelling and run again. DFo 6-1 Copyright © 2019, Oracle and/or its affiliates. All rights reserved. 14 Introduction to Oracle Application Express Terminology Key terms used in this lesson included: Application software System software Oracle Application Express Syntax Subset Comparison Operator DFo 6-1 Copyright © 2019, Oracle and/or its affiliates. All rights reserved. 15 Introduction to Oracle Application Express Summary In this lesson, you should have learned how to: – Distinguish between application software and system software and give an example of each – Log-in to the Oracle Application Express practice environment – Execute a simple query to retrieve information from the Database – Apply the rules of SQL to display all columns and a subset of columns specified by criteria DFo 6-1 Copyright © 2019, Oracle and/or its affiliates. All rights reserved. 16 Introduction to Oracle Application Express