Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

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

Name: Oracle APEX : SQL, PL/SQL to Web Application Development
Rating: 3.7 (98 reviews)

Learn with ease to build web application with Oracle sql, pl/sql, APEX through cloud without any installation.

Created byGuha Rajan M., B.Engg, MBA

Last updated 11/2024

English

What you'll learn

An overview about Oracle SQL statement and PL/SQL
Details about using Oracle APEX tool to create web application
How Oracle APEX, LiveSQL can be used to learn SQL and PLSQL without any installation.
How SQL, PL/SQL, Email alert and other features can be used in Page designer towards developing Oracle Apex based application
RESTful webservices communication between APEX and external world - like IOT device.

Course content

16 sections • 57 lectures • 5h 40m total length

Course Overview - Topics of coverage4:28
Explore Oracle APEX, SQL, and PL/SQL for web application development, including basics, database design with the entity relationship diagram, and building apps in a cloud environment.

What is RDBMS?7:50
Business flows, ER diagrams and RDBMS6:20
Structured Query Language - Introduction3:59
Environments to Practice SQL6:28
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.
Data Definition Language Overview5:18
DDL Demonstration : Part 17:21
DDL Demonstration: Part 24:35
DML Demonstration: Part 16:12
DML Demonstration: Part 26:00
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.
SQL Quiz

What is PL/SQL?6:32
PL/SQL code block7:34
PL/SQL program contruct8:21
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.
PL/SQL compute demonstration6:23
Subprogram - Procedure, Functions5:48
Database Stored Procedure : Demonstration6:10
Caution : Having the objects valid3:59
Importance of exception handling - An overview5:13
Quiz - PL/SQL

Creating Database objects using sample dataset4:29
Review of Database Objects3:08
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.
Building a report using Oracle Apex8:14
Build a report in Oracle APEX using a sample dataset, create a dashboard with three charts: bar, pie, and box, to visualize project data.
Validating the report5:41

What is a Page Designer in Oracle Apex?9:35
Navigation in Page Designer in Oracle Apex.6:53
Passing Parameter between two Interactive Reports.10:53
Modification of report using Page Designer6:46
Custom designing sample requirement using Page Rendering and Page Processing9:26
Customization Faceted Search Report with Page item3:28
Adding a page item and associated computation in page rendering process.5:52
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.
Page Item Validation Process with Oracle Apex5:32
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.
Triggering Email from Oracle APEX based on event2:26
Learn to set up a page processing email process in Oracle APEX, triggered by after insert events, configure recipients, and send emails automatically.
Quiz - Apex - 3

Requirements

Some programming experience would be beneficial but not mandatory

Description

This course provides you will necessary details to develop web application using Oracle APEX . This course uses cloud version of Oracle APEX , hence no install required. This course is also updated with Oracle Apex latest release 23, which has inbuilt functionality for image upload (BLOB - datatype) into database table column and then retrieve in a report.

Oracle APEX is 'plug and play' application development tool to create impressive application of forms and report based tool without use of any web programming. However, for a complex application, it would require to use SQL statement or PLSQL programming through Page designer. To make learning easier, this course also provides a brief overview about SQL and PLSQL too so that learner need not look at t other source towards learning SQL, PLSQL.

This course provide in depth details about some of the critical features available with Oracle APEX to build desired web application

There are also demonstration as how sql, plsql can be used in application development in Oracle APEX in Page processing, dynamic action and even email feature of event.

•Overview about RDBMS & SQL

•What’s RDBMS

•Entity relationship diagrams

•Environment for practice

•An overview of SQLs

•DDL, DMLs.

•Overview about PL/SQL

•Code block

•Different forms of code blocks

•Demonstration.

•Oracle Application Express

•Why Oracle Apex?

•Getting access to environment

•Navigation.

•Building application using Spreadsheet and from Database.

•Page Designer

• RESTful webservices communication between APEX and external world - like IOT device.

•Learning through Sample Application & demonstrations

Additionally there are built in Quiz section to test your understanding of Oracle APEX.

Good luck and happy learning

Who this course is for:

Anyone interested to learn building web application using Oracle APEX
Programmer and Developers

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

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 4min

Overview about RDBMS and SQL9 lectures • 54min

Overview about PL/SQL8 lectures • 50min

Oracle APEX: Introduction and access3 lectures • 19min

Oracle APEX: Building a simple spreadsheet application1 lecture • 7min

Oracle APEX : Building Application Dashboard using database objects4 lectures • 22min

Oracle APEX : Building Report and Form Based Application - 12 lectures • 13min

Oracle APEX : Building Report and Form Based Application - 24 lectures • 21min

Oracle APEX: Page Designer9 lectures • 1hr 1min

Oracle APEX 23 : new Image upload functionality & report to display BLOB image2 lectures • 12min

Requirements

Description

Who this course is for: