Learn with ease to build web application with Oracle sql, pl/sql, APEX through cloud without any installation.
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.
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.
- RESTful webservices communication between APEX and external world – like IOT device..
Course Content
- Introduction –> 1 lecture • 4min.
- Overview about RDBMS and SQL –> 9 lectures • 54min.
- Overview about PL/SQL –> 8 lectures • 50min.
- Oracle APEX 19 : Introduction and access –> 3 lectures • 19min.
- Oracle APEX 19: Building a simple spreadsheet application –> 1 lecture • 7min.
- Oracle APEX 19: Building Application Dashboard using database objects –> 4 lectures • 22min.
- Oracle APEX 19: Building Report and Form Based Application – 1 –> 2 lectures • 13min.
- Oracle APEX 19: Building Report and Form Based Application – 2 –> 3 lectures • 18min.
- Oracle APEX 19: Page Designer –> 5 lectures • 35min.
- Oracle Apex 19 : Page Designer – Dynamic action –> 2 lectures • 10min.
- Oracle Apex 19: Page Designer – Shared Components –> 5 lectures • 27min.
- Oracle APEX 19: RESTful Webservices – communicating with external devices –> 4 lectures • 19min.
- Oracle Apex 19: Additional learning through Sample application install –> 1 lecture • 8min.
- Next Step –> 1 lecture • 2min.
Requirements
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
•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