Oracle APEX : SQL, PL/SQL to Web Application Development

Explore relational databases by examining tables, columns, rows, and records, and see how relations, entity-relationship diagrams, attributes, and normalization define data models and business flows.

Turn a business flow diagram into an entity relationship diagram. Define attributes and primary and foreign keys to build tables for customers, orders, employees, and departments in a relational database.

Explore structured query language basics, including data definition language, data manipulation language, and data control language, to create objects like tables and views, grant privileges, and manage transactions.

Explore Oracle sql practice options, from local sql plus environments to cloud options, and learn to set up a workspace on Oracle cloud or Apex for running queries and inserts.

Explores data definition language and core database objects—tables, views, sequences, indexes, and synonyms—and explains constraints such as primary keys, foreign keys, unique, and check.

Launch into ddl basics with part 1, creating tables, primary keys, foreign keys, and constraints using life sequel or Oracle Cloud. Learn to run inserts, selects, and view schemas.

Explore creating a customer table in Oracle APEX via SQL and the UI, generate correct SQL statements, and define a primary key with an address field that can be null.

Demonstrates creating department and employee tables with primary keys, then uses triggers to auto-populate the department and employee numbers on insert, and validates results with select queries.

Explore two-table joins of employees and departments to fetch department names and locations, understand normalization and keys, and apply aggregate functions like total salary and mean commission.

Explore how PL/SQL serves as the procedural language extension to SQL, using declare, begin, end blocks to retrieve, compute, and store data, and distinguish between anonymous blocks, procedures, and functions.

Demonstrate how PL/SQL code blocks manage local and global variable scope, showing how inner assignments affect outer values with a step-by-step printout and real-time execution.

Explore PL/SQL program constructs, including if-then-else, loops, and explicit cursors, to process department 30 employees by fetching records, computing salary and commissions, and printing results.

Watch a PL/SQL compute demonstration that fetches employees by department, computes salary and commission, and prints results using a cursor loop while exploring table creation and data.

Explore the differences between anonymous blocks, subprograms, procedures, and functions, including compilation, validity, return values, and parameter usage.

Demonstrates creating and replacing a stored procedure in Oracle, replicating a table, and executing the procedure to insert department data into the department table.

See how objects become invalid when referenced objects change, such as changing the department table column data type, and recompile the procedure with a compile statement to restore validity.

Learn how runtime exceptions arise during execution and how proper exception handling ensures graceful termination instead of abrupt failures, including addressing too many rows with a cursor.

Access the Oracle APEX online environment by registering for a free cloud workspace, activating your link, and signing in to build web apps with the object browser and app builder.

Log into the Oracle APEX workspace, use the top menu and icons to explore the skill workshop, object browser, and sample data for building apps with the app builder.

Learn to build a simple web application in Oracle APEX by uploading a spreadsheet as a CSV, creating an application, loading data into tables, and generating charts and reports.

Install and use Oracle APEX sample data to create database tables from a provided dataset, then build an application from that data, exploring forms, reports, and charts.

Explore the installed sample data set, including tables and views, and see how views join data from multiple tables with indexes to support reporting in the app.

Build a report in Oracle APEX using a sample dataset, create a dashboard with three charts: bar, pie, and box, to visualize project data.

Validate the report by querying backend database with select and count to verify project statuses such as sign and completed, illustrating dashboard creation with Oracle packs from views and tables.

create a report and a form inside an oracle apex app by loading a blueprint, adding a task page, and configuring project data and milestone lookups.

Execute a report and form based application in Oracle APEX, run the latest app, manage versions, and create records within the app builder.

Install the sample data set, including the employee and department tables and the view, and review primary keys on department number and employee number for drill-down form development.

Learn to create a card report from the department table in Oracle APEX, explore department details, and add employees via a form with save functionality.

Create a form in Oracle APEX and link it to a department card report, passing department numbers to prepopulate the employee form and enable adding employees via navigation between pages.

Explore the built-in faceted search feature in Oracle APEX (introduced in version 19), enabling dynamic project filtering by name, status, and budget.

Discover how Oracle APEX page designer helps maintain and enhance pages by rendering data from the database, applying page processing, and conditional branching, using SQL and PL/SQL.

Explore how to navigate the page designer in Oracle APEX to create and customize pages, render reports, set validation and processing, and manage branches in interactive reports.

Pass parameters between oracle apex interactive reports to drill down from a department page to its related employees using a page item and filtered sql.

Learn to modify an interactive report in Oracle APEX using Page Designer, pulling data from the demo customer table, and applying filters with a sequence to retrieve specific records.

Design and processing with Oracle APEX page designer to fetch data from a customer table and insert it into another table via a button, using sql and pl/sql blocks.

Create a custom faceted budget filter in Oracle APEX by adding a page item, configuring a 'budget less than' facet, saving, running, and applying filters to refine the report.

Learn to add a page item and a pre-rendering computation in Oracle APEX to display a grand total (salary plus commission) in a report via the page designer.

Create a page item validation in Oracle APEX to enforce that commission does not exceed 50% of salary, using a SQL expression (or PL/SQL block) and a custom error message.

Learn to set up a page processing email process in Oracle APEX, triggered by after insert events, configure recipients, and send emails automatically.

Explore how Oracle APEX stores images as blob in the database and builds an interactive form and report to upload and display employee pictures.

In Oracle APEX, build a classic report from the employee table to display a blob image by using sql-based queries and a dbms_lob function to determine image size before rendering.