Skip to content
UdemySQLPaid courseBeginner levelCertificate

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

icon
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

icon
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


icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

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.

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

icon
Reviews

3.7

98 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

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.

Showing all 10 reviews on CourseDuck

Read all 98 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 74 / 100