Oracle APEX - Basic Level

Oracle APEX - Basic Level

Oracle APEX elementary knowledge of Web Application Development, SQL, PL/SQL, building professional applications with Oracle APEX, and developing solutions by utilizing various features of Oracle APEX.

Course Outline

Getting Started with Oracle APEX on the Oracle Autonomous Database

• Creating and Managing a Workspace
• Getting Started with Oracle APEX Service
• Creating and Managing APEX Service

Using SQL Workshop

• Create and modify database objects
• Run SQL Commands and Scripts
• Load and Unload data using the Data Workshop Utility
• Generate SQL using Quick SQL

Creating a Database Application

• Create a database application based on existing tables
• Create a database application from a file
• Create applications for mobile devices

Working with Pages and Regions

• Create different page types and regions
• Manage pages in Page Designer
• Manage page attributes
• Add Page Components

Developing Reports

• Create an interactive report
• Create an interactive grid
• Create a classic report
• Create a report with form
• Create a faceted search page
• Use and customize interactive report as an end user
• Manage interactive report attributes
• Configure the display of interactive report controls as a developer
• Manage interactive grid attributes
• Customize the Interactive Grid Toolbar
• Customize interactive grid as an end user
• Customize faceted search region and facet behaviour

Creating and Using Forms

• Create an editable interactive grid
• Create a simple form and link a report to this form
• Create different types of master detail forms
• Modify a form

• Create and use page-level items and buttons