How to Install and Configure Oracle APEX On-Premises Easily

Setup Guide to install & configure Oracle APEX env on-premises. Ft. Oracle DB, APEX, ORDS & App Server on Win or Mac.

“How to Install & Configure Oracle APEX Environment On-Premises Easily”, is a course created for you to learn how to setup complete Oracle APEX environment on-premises easily and at no cost, with a step-by-step approach, starting from the basics through to the intermediate and to the advance. Besides that all the software used in this course are all absolutely free, the course is fashioned in a kind of best-practices way/technique to make sure you are not guided off course – the procedures are sequential in approach, and stretching through leveraging the following free required installation components:

What you’ll learn

  • Know some best techniques to Install Oracle Database and leverage Pluggable Databases to have multiple Databases on a single computer.
  • Learn how to have different versions of APEX installed on a single computer machine without VM ware or Virtual Box..
  • Learn how to install and configure Oracle Rest Data Services (ORDS) to work with Oracle APEX with ease ..
  • Learn how to use Application Server (Apache Tomcat) for deployment..
  • Learn to understand the three available Apex Environments: Development, Testing and Production environment..
  • Learn how to create Pluggable Database and understand how to manage multiple of them (Pluggable Databases)..

Course Content

  • Introduction –> 3 lectures • 28min.
  • Oracle Database –> 3 lectures • 14min.
  • Oracle Application Express (APEX) –> 7 lectures • 37min.
  • Pluggable Database –> 7 lectures • 48min.
  • Oracle Rest Data Services (ORDS) –> 3 lectures • 15min.
  • Application Server –> 5 lectures • 19min.
  • Conclusion –> 1 lecture • 1min.

Auto Draft

Requirements

“How to Install & Configure Oracle APEX Environment On-Premises Easily”, is a course created for you to learn how to setup complete Oracle APEX environment on-premises easily and at no cost, with a step-by-step approach, starting from the basics through to the intermediate and to the advance. Besides that all the software used in this course are all absolutely free, the course is fashioned in a kind of best-practices way/technique to make sure you are not guided off course – the procedures are sequential in approach, and stretching through leveraging the following free required installation components:

*Oracle Database Installation – in which we took advantage Oracle Database XE 18c (as it is a free version for developers) as our Database to store and manipulate data.

*Oracle APEX (we used three different versions) as our Application development tools, as it is the most preferred Low-Code Web Application development platform by Oracle itself.

*Oracle Rest Data Services (ORDS) – to give our applications access to interact with data of other applications (even when created on another platform or language) using JSON as language to achieve that.

*Application Server comes in, and here we leverage Apache Tomcat, since it is one of the best, secure, lightweight, fast and free Application Server out there today.

And we can not forget to mention how we delved into the world of Pluggable Databases (PDBs) – where we learnt: how to create a PDB, how to switch into it; as it is a container, how to Install Oracle APEX on it (multiple APEX even), how to Install and configure RESFul Services in a PBD and so on.
The course is focused basically on the approach/technique to have a complete Oracle APEX environment setup on your PC easily and at no cost, which I believe would add more value to you in this field.
Good luck and see you in the main course.
Thank you.

Get Tutorial