Objectives and competences
1. The student understands the difference between low-code an no-code tools for application development
2. The student is able to apply fundamental principles od data modelling in the context
3. The student is able to apply core functionalities of low-code tool (APEX) with the exception of PL/SQL and Javascript programming.
4. The student is able to create data structures in the context
5. The student is able to import or create data in different forms into database in the context
6. The student is able to design and create database driven web applications in the context
7. The student has an overview of important low-code tools on the market and recognises the strengths, weaknesses and benefits of these low-code tools
Content (Syllabus outline)
1) Introduction to low-code application development and availability of Apex
2) Fundamentals in data modelling
3) Core functionalities of APEX
4) Modes of importing existing data structures and data
5) Generation of first draft application
6) Managing reports
7) Managing forms
8) Converting reports from text to graphs
9) Managing application menus
10) Team collaboration support
11) Sample/starter applications and plugins
12) Managing packaged applications and multiple languages
13) Business cases: Intranet news for employees, Catalog of local plants, GreenDi social platform/forum, Small innovation system, Document management system, Web shop, Course scheduling system, Bill-of-material and cost calculation, Nutrition and diet management, Team appointment system, Telco case, Car rental
Learning and teaching methods
The following methods and forms of teaching will be used in the program:
• lectures,
• demonstration
• computer lab tutorial
• hand-on exercises in different contexts
Forms:
• frontal learning,
• individual learning,
• group learning,
Intended learning outcomes - knowledge and understanding
• The student explains and distinguishes the no-code and low-code programming tools,
• The student is able to read and undestand data models
• The student is able to analyse and create less complicated logical, relational and physical data models in the context,
• The student is capable to import existing data from spreadsheets, SQL scripts and REST as well as to create sample data by using Quick SQL
• The student is self-confident in creating different forms and reports. Student is capable to customize forms and reports and create graphs from textual reports
• The student is able to create and maintain the application menus
• The student is able to use sample and starter applications as pattern to develop new applications
• The student is: a) aware of plugins for APEX, b) is able to search & find the appropriate one in the context, c) is able to install plugin in the application and d) is able to apply plugin in created application.
• The student is able to collaborate in team and is able to create new authentication and authorization scheme as well as to apply it in the application.
• The student is able to: a) install packaged applications, b) to create and export own packaged application and c) design and implement applications which require multilanguage support
Readings
1. Edward Sciore. Understanding Oracle APEX 20 application development. 3nd ed. Apress, 2020
2. Beeapex project members. Exploring Low-code application development with Oracle Application Express. 1St ed. (work in progress). 2023
