Learn and Gain expertise : SQL, PL/SQL to Web with Oracle APEX

person icon GUHARAJANM

Learn and Gain expertise : SQL, PL/SQL to Web with Oracle APEX

Learn with ease to build web applications with Oracle sql, pl/sql, RESTful web service using Oracle DB & APEX through cloud without any installation.

updated on icon Updated on Oct, 2023

language icon Language - English

person icon GUHARAJANM

architecture icon PL/SQL,Development,Oracle,Databases,SQL

Lectures -48

Resources -4

Duration -4.5 hours


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course 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.

•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


•Oracle Application Express

    •Why Oracle Apex?

      •Getting access to environment


     •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


What will you learn in this course:

  • An overview about Oracle SQL statement  and programming using 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.


What are the prerequisites for this course?

  • Some programming experience would be beneficial but not mandatory

Learn and Gain expertise :  SQL, PL/SQL to Web with Oracle APEX


Check out the detailed breakdown of what’s inside the course

Course Introduction
1 Lectures
  • play icon Course Introduction 04:40 04:40
Overview about Relational Database Management and SQL
9 Lectures
An Overview about PL/SQL
8 Lectures
Oracle APEX - Introduction
3 Lectures
Building a simple spreadsheet report application
1 Lectures
Building Application Dashboard using database objects
4 Lectures
Building Report and Form Based Application - 1
2 Lectures
Building Report and Form Based Application - 2
3 Lectures
Page Designer in Oracle APEX
5 Lectures
Page Designer - Dynamic Action
2 Lectures
Page Designer - Shared Components
5 Lectures
RESTful Webservices - communicating with external devices
4 Lectures
Additional learning through Sample application install
1 Lectures

Instructor Details



CEO, Capstone Solutions, Trainer

 He is having over 25 + years of IT industry experience  (Product development, Consulting & Training).

Althrough his career he has worked on assignments with fortune 500 companies across the globe. His last engagement was with Oracle India (initially with Oracle 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.

Was also instrumental in design, development and roll-out of Graduate Hire program on Oracle Products & cloud 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 Internet of things and Machine learning, AI these days.

Due to his vast experience, he has crafted varied unique courses  related project management, Internet of things, database modeling and design. Has plans to create more, as his passion has been on knowledge acquisition and sharing which he has acquired over 2 decades.

He holds a Bachelor's degree in engineering (Computer science) with MBA and a certified PMP since 2007

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us