Oracle APEX 19 : SQL, PL/SQL to Web Application Development
3.7 (25 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
113 students enrolled

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

Learn with ease to build web application with Oracle sql, pl/sql, APEX through cloud without any installation.
3.7 (25 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
113 students enrolled
Last updated 12/2019
English
English [Auto-generated]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Course content
Expand all 43 lectures 04:15:26
+ Overview about RDBMS and SQL
9 lectures 54:03
Business flows, ER diagrams and RDBMS
06:20
Environments to Practice SQL
06:28
Data Definition Language Overview
05:18
DDL Demonstration : Part 1
07:21
DDL Demonstration: Part 2
04:35
DML Demonstration: Part 1
06:12
DML Demonstration: Part 2
06:00
SQL Quiz
3 questions
+ Overview about PL/SQL
8 lectures 50:00
What is PL/SQL?
06:32
PL/SQL code block
07:34
PL/SQL program contruct
08:21
PL/SQL compute demonstration
06:23
Subprogram - Procedure, Functions
05:48
Database Stored Procedure : Demonstration
06:10
Caution : Having the objects valid
03:59
Importance of exception handling - An overview
05:13
Quiz - PL/SQL
3 questions
+ Oracle APEX 19 : Introduction and access
3 lectures 18:48
Why Oracle APEX?
07:04
Accessing the Online environment
03:51
Navigation in Oracle APEX
07:53
Quiz - Apex -1
2 questions
+ Oracle APEX 19: Building a simple spreadsheet application
1 lecture 07:11
Building a simple application from spreadsheet data
07:11
+ Oracle APEX 19: Building Application Dashboard using database objects
4 lectures 21:32
Creating Database objects using sample dataset
04:29
Review of Database Objects
03:08
Building a report using Oracle Apex
08:14
Validating the report
05:41
+ Oracle APEX 19: Building Report and Form Based Application - 1
2 lectures 13:02
Building Report and Form based application
04:30
Executing the Report and Form based Application
08:32
+ Oracle APEX 19: Building Report and Form Based Application - 2
3 lectures 17:41
Creation of Data object from Data set
02:52
Creating a Card Report based on DEPT
03:28
Creating Form and linking it to card report
11:21
Quiz - Apex - 2
2 questions
+ Oracle APEX 19: Page Designer
5 lectures 35:06
What is a Page Designer in Oracle Apex?
09:35
Navigation in Page Designer in Oracle Apex.
06:53
Modification of report using Page Designer
06:46
Custom designing sample requirement using Page Rendering and Page Processing
09:26
Triggering Email from Oracle APEX based on event
02:26
Quiz - Apex - 3
7 questions
+ Oracle Apex 19 : Page Designer - Dynamic action
2 lectures 09:59
What is Dynamic Action?
02:52
Sample Application for Dynamic Action
07:07
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 ver 19. This course uses cloud version of Oracle APEX version 19, hence no install required.


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.

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