free web maker
tecnica24.es

go into #orclapex
fast development highway

A full course to get skills to build your own
Oracle APEX development environment.

You will learn to install and manage Oracle Linux, Docker & Podman, Mongo DB, Oracle DB, Oracle APEX, Oracle ORDS REST Services, and others.

Have a look to âp'box to know what's included.

learn’box - "let's build âp'box"

We want you get skills to install and run your own infraestructure
to develop with #orclapex on top our âp'box
Attend using Google Meeting and our learn tool based on #orclapex app

Mobirise

learn to build your base software & hardware

learn'box

OS

Install Oracle Linux 8.2

Install Oracle Linux 8.2 with 4.18 kernel.
Install and manage OS using Cockpit web interface.
Configure security using SELINUX and firewall.

DB

Install Oracle 18c XE & 19c SE2

Install two flavours of Oracle Database:
* free version 18c Express Edition.
* last version 19c Standard Edition 2.
Both deployed in container infraestructure.

APEX & ORDS

Install APEX 20.1 &
Rest Data Services 19.4

Install Oracle APEX 20.1 with multilanguage support.
Install Oracle ORDS REST Services and connect to Oracle Database.
Configure your database & schema to export REST Services.

HW

Select and build your custom boxAll inside a box

Using AMD Ryzen family of processors or even Intel Core processors.
* Starting with AMD Ryzen 3 3200g or Intel Core i3.
* from 16GB of RAM to 128GB.
* from 240GB WDC M2 SATA disks.
* Select your custom case.

learn to deploy a containerized infraestructure

learn'box

OSS

Select your Open Source Software

All software we will use is open source(*) or free (**).
As developer we want you fall in love with #orclapex reducing your licensing costs to zero.
(*) exception of Oracle Database licensed versions as SE2 or EE.
(**) Oracle Database Express Edition is free to use as âp’box is.

RUN

Install Docker & Podman

Install and configure Docker.
Install and configure Podman.

WEB

Install and run Portainer

Install Portainer as a manager of all your containers with a web interface.

+

Install a set of ready to run servers

Learn to install a set of servers:
* NGinx web server: put your web inside a folder and redirect a port in your router. That's all you need to publish your web.
* ftp server: using vsftpd you can share any content with your customers.
* MongoDB: we integrate #orclapex apps data to be storaged inside Mongodb.
* JSON Server: publish web services using #orclapex connected to json files published by jsonserver.
* Nodejs: extend #orclapex apps capabilities using nodejs to publish web services.

learn to write your own advanced bash scripts

learn'box

+

customize defaults âp'box scripts

You will learn how to extend and customize defaults âp'box scripts.
Build menus, configuration files, translations and custom colorization.

+

extend âp'box

You will learn to add new features to âp'box to run new services.

learn to develop with #orclapex

We propose you to maintain your focus in #orclapex development 
and manage infraestructure using your custom version of âp’box
we will build in this course

standard pack

forms

Use wizards to develop your firsts forms.
Build forms from scratch and do actions on load.
Master & detail forms. 

reports 

Use wizards to build classic and interactive reports.
Extend reports using actions on demand.
Connect reports.
Filter reports.
Make pivots.

grids

Use wizards to build grids.
Build editable grids from scratch.
Use custom actions in your update process.

graphs

Build graphs in your existing reports.
Create graphs from scratch.
Dynamic graphs.

maps

Build interactive Google Maps to present your data.

drag&drop

Use drag & drop techniques to upload documents.

blobs

Manage binary objects inside columns of your tables.
Upload files.
Storage files externally.

rest

Publish your data as rest services.
Consume external rest services.

menus

Create menus using wizards.
Create dynamic menus based on lists from sql views.

lists

Manage lists of items to create UI controls.

lovs

Select your data using dynamic and static lovs.
Create functions that returns sql as list of values.

json

Generate JSON data and consume it from external web services.

advanced pack

authentication

Control who logins into your applications with different methods.

authorization

Control who interacts with any page or component of your applications.

templates

Customize appearance of your application using custom templates and CSS.

plugins

Extend your applications using components of third party installed like plugins.

concepts & dictionary

Advanced concepts and use of dictionary.

database jobs

Run database jobs instead standard procedures from browser.

dynamic sql

Generate dynamic SQL that can be executed inside database jobs.

external tools

Use Quick SQL and other tools like Apex Office Print to extend your applications capabilities.

apps you will learn to build

these selected apps we coded at tecnica24.es

documents

share documents
using just a link

Your customers would appreciate if they can share information without sending a mail from outside applications they use.

projects

manage projects
using a kanban

A dashboard of your projects status can improve performance of your support team.

portal

publish to web

Extend your web capabilities integrating data published directly from your apps following templates guidelines.

source control

be confident of changes in your code

Coding with PL/SQL is better if you have trace of any change made.
âp’box comes with PL/SQL you put inside your schema to have source control of your code.

advanced tasks you will learn to solve

these advanced tasks is a must to learn in your #orclapex path

load documents
into database

One of most important tasks is to load documents from user interact in any column of your database.

project
gantt

Generate project gantt graphs to visualize performance of your development team.

use ftp to
publish data

How to publish blob binary files into system files then published by ftp server.

manage source code
with ddl triggers

Define ddl triggers that storage externally out of your schema PL/SQL code.

Pricing

There is a price for everyone

Start anytime from anywhere
.

Easy to use learning tool

âp'box

Over 40+ learning items.

We want all alumni satisfaction.
Try our 5 free items course anytime.

Select your learn'box price

You get access to learn'box at any time.

* 20 tickets + 5 free
* 50% once published in your social networks

for only €27,5 euros (50% social network discount applied)

* 40 tickets + 5 free
* 50% once published in your social networks

for only €49,5 euros (50% social network discount applied)

* 80 tickets + 5 free
* 50% once published in your social networks

for only €74,5 euros (50% social network discount applied)

* select number of tickets what you are interested in

âp'box

buy learning tickets

We have options to your needs of learning
with packs of prebuyed tickets

1

Select your items to learn

With learn'box you can select those items you are needed to learn. You can buy pack of tickets for different people.

2

Pay per pack

You have a price for the first 10 tickets. Till then you must apply a price depending on your volume. For example, if you buy 35 tickets you will pay 30 euros (first 10 tickets) + 50 euros (next 20 tickets) + 9,5 euros (last 5 tickets) = 89,50 euros. You will get 35 hours of learning and in each module a fully functional mini app.

3

Support included or 25 euros/each

We solve upto 2 issues regarding your development environment free or charge once you buy +50 tickets (118 euros+).
You can buy support tickets for only 25 euros/each.

first 10
tickets

€  3 euros/each
    * All learning items.

from 11 to 30
tickets

€  2,50 euros/each
    * All learning standard items.

from 30 to 50
tickets

€  1,90 euros/each
    * All learning standard items.

from 50 to 100 tickets

$ 1,25 euros/each
    * All learning standard items.

discounts

we would appreciate if you bring us new friends

social networks

  50% discount
    If you publish a post in your social network we make a 50% discount once 20+ tickets are buyed.

bring your friends

  10% discount
    Your friend will receive a 10% discount immediately.
    For each friend you will receive 5 tickets free.

second pack

  20% discount
    Once you purchased your second pack of 20+ tickets you will receive a 20% discount.

first 5 tickets free

  free first 5 tickets
    Select upto 5 items free of charge not in advanced pack.

learn’box

"# let's build âp'box"

We are launching now.
Reserve your sitting if you are interested.
Share with us what you would improve.

© Copyright 2020 - tecnica24.es - All Rights Reserved - Developed with love in Cádiz, SPAIN - built using #orclapex