Oracle APEX : SQL, PL/SQL to Web Application Development (Udemy.com)
Learn with ease to build web application with Oracle sql, pl/sql, APEX through cloud without any installation.
Created by: Guha Rajan M.
Last updated November 2024
What you will 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.
How it compares
Against the other 388 rated Udemy courses in SQL on CourseDuck:
- Rating3.7 out of 5higher than 1% of them
- Reviews98#350 of 389 by number of reviews
- Length5.7 hoursshorter than 54% of them
- Last updatedNovember 2024more recently than 60% of them
Course 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
Instructor Details
- 3.7 Rating
98 Reviews
Guha Rajan M.
Having over 25 + years of IT industry experience (Product development, Consulting & Training).
His last engagement was with Oracle India (initially with consulting and then with Oracle university) , which was for more than 12 years. Prior to this, had worked with Cap Gemini (formerly iGate Global Solution), GE to name a few.
Had managed projects and programs in Enterprise Resource Planning and Business Intelligence implementations in the range of 3000 man days with revenue about 6mil US$ per year. These projects are on industry domains, such as Oil and Gas, Process Manufacturing, Hi-Tech Retail & Telecom across the globe.
Was awarded with "pace setter" , "best managed " project awards in recognition of efforts in project management.
He was also instrumental in design, development and roll-out of Graduate Hire program on Oracle Products stack for partner IT services companies in recent times.
Right from college was fascinated about devices and sensor interaction with computer, which made him focus on micro-controller in early 90's and that eventually attracted him towards field of ERP, BI , Cloud technologies - Saas, Iaas, Paas, Internet of things, Machine learning, AI and open source software tools these days.
More SQL courses
SQL - The Complete Developer's Guide (MySQL, PostgreSQL) (2025)
4.8 (2,153 Reviews)
Provider: Udemy
Time: 19.7h
$94.99
SQL Server High Availability and Disaster Recovery (HA/DR) (2026)
4.8 (1,810 Reviews)
Provider: Udemy
Time: 88.3h
$16.99
70-461 Session 3: Querying Microsoft SQL Server (T-SQL code) (2025)
4.8 (1,094 Reviews)
Provider: Udemy
Time: 3.6h
$12.99
Modern Event-Driven Spring Boot: Kafka & Spring Cloud Stream (2026)
4.8 (494 Reviews)
Provider: Udemy
Time: 13.4h
$10.99
Oracle Database 12c Backup and Recovery using RMAN (2024)
4.8 (428 Reviews)
Provider: Udemy
Time: 20.1h
$34.99
Reviews
By Izzy Bennett on 11/16/2021
This was a good, comprehensive course for Modern (Late 2021) APEX development. However, the lack of captions and a handwritten transcript made this incredibly hard to parse and understand as a hearing challenged person.
By Jaka Sugi on 8/6/2021
Need more than example from oracle
By Darren Donnelly on 7/15/2021
It was a good course for especially learning about RESTful services that can help me linked between apes and mobile apps.
By Jenni Jones on 1/7/2021
It's been thorough and easy to understand
By Chaitanya Papisetty on 9/25/2020
Features like RESTful services will be nice if shown how to consume it from Oracle Apex applications. felt like there were skimmed very vaguely.
By Kishore Hejmady on 9/6/2020
Course is good for overview, it would have been better if Rajan actually created all the items instead of pre-creating and just telling I created this and this is how it looks
By Sandeep Tanjore on 7/8/2020
This course was really good in that, it gives an overview of Oracle APEX concepts. Currently I was going through Riaz Ahmed's book on APEX but mid-way found it boring and also was unable to understand a lot of concepts. Realised that I needed a drill down or understanding of basic concepts on Oracle APEX. This course does that. Now that I am done with this, will be going to read ' Beginning APEX 5' and then Riaz Ahmed's book of 'APEX 19'.
By Schon Crouse on 4/24/2020
The screens need to be updated. I'm doing the same steps along with the video and they do not match. It would also be nice to have little exercises to apply what is been gone over. As the series went forward the mouse movement was rough to watch. he was wiggling the mouse all over and wasn't sure where he was going.
By Venkata Sunkara on 4/15/2020
Several missing parts, not flowing well. I was expecting a single application to be developed with all features explained that used in that application. how ever, he went on explaining each feature with a different application, so much disconnect for a beginner to catch up and understand.
By Paulo Künzel on 11/22/2019
The course is good and the instructor knows what he is talking about. I've learned some interesting things. I've graded as 3.5 because literally 50% of the course is overview and showing the tools. The other 50% has some nice information but almost no explanation on how to use dozens of the components to build the screens. Again, the classes are good, but as it is, I feel more comfortable saying I know the basics of PL/SQL than APEX. If more videos about adding and how to edit stuff on-screen gets added, I'll gladly change it to 5 stars.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 74 / 100






