Lino Schildenfeld 27th April 2017

Oracle APEX Intro part one

www.apexRnD.co.nzlschilde.blogspot.com@LinoSchildelschilde@apexRnD.co.nz

AUSOUG APEX webinar series

...in short

APEX R&D manager for NZ and AU

10+ years Oracle development experience

APEX Blogger and enthusiast

NZ APEX meetup organizer

Conference speaker

Specialize in training and consulting

Who am I?

Oracle Application Express Basics

apex.oracle.comapex.world

Safe harbor……….

What we know

RAD framework for Oracle Database

Database centric development tool

History overview

https://apex.oracle.com/pls/apex/f?p=84663:1

Architecture3 Tier Architecture

Browser Mid Tier Database Tier

Web Logic Server

WLS

ORDS

Apache

OHS

Oracle APEX

Oracle Database

Schemas

What do I need to know?

Database centric development tool

Meta Data driven components

Declarative programming

Application Builder

Workspace / Schema (Internal)

Application and page structure

APEX Engine

APEX URL

Universal theme

http://apex.oracle.com/architecture/

Simplified structure

WORKSPACE

Application

Page

Region

Why?

No cost feature of Oracle database (already in your Oracle database)

Ideal for PL/SQL or ex-Forms developers

Browser based development tool leveraging all DB features

Things like Session Management, Authentication, Authorization, and Debugging are managed all out of the box

Modern secure, extendable and scalable framework

Works in a Cloud

Growing framework with the future, supported by community (conferences, meetups, OTN)

Personal favourites: APEX integration capabilities and plugins

EASY TO LEARN, DEVELOP, MANAGE and DEPLOY

Tweets

I want to be APEX developer

apex.oracle.comapex.world

My Skills

HTML (DOM, how browser work, POST and GET)

JavaScript and JQuery

CSS

PL/SQL

Web service

JSON

How and where to start?

Ask your DBA for sandpit

apex.oracle.com

Download Developers VM

Download Docker image

Explore Packaged applications

Webinars / Conferences

Training (tutorials, YouTube videos and demos)

Blogs

https://apex.world/ords/f?p=100:211:::NO:::

Important – staying fit

Oracle OTN forum

apex.world

Twitter -> #orclapex

Slack

APEX meetups - apexmeetups.com

Local and international conferences (KSCOPE17 – Texas USA, APEX Connect – Germany, APEX World – Netherlands)

Webinars – ODTUG, AUSOUG, Insum, Skillbuilders…..

APEX on Air

…

Useful links and tips

apex.world

apex.oracle.com/otn and apex.oracle.com/ut

https://livesql.oracle.com/ and https://devgym.oracle.com/devgym/database-for-developers.html

White paper - http://www.oracle.com/technetwork/developer-tools/apex/learnmore/apex-50-overview-2526922.pdf

APEX requests - https://apex.oracle.com/pls/apex/f?p=55447:50:10793191848097:::::

VM - http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html

Docker - https://github.com/Dani3lSun/docker-db-apex-dev

ODTUG and AUSOUG websites

Xplug browser plugin

DEMO – Hello World

Summary

We encourage you to try APEX!

You will never look back

If you have a problem reach out to people at apex.world or OTN

Further sessions

APEX Intro part II – Roeland from APEX RnD, 24 May 2017

Please register for webinars and provide feedback. This is the best indicator for organizers and whole series to cater for what really matters.

http://www.ausoug.org.au/pages/calendar

www.apexofficeprint.com

Q&A www.apexRnD.co.nzlschilde.blogspot.com@LinoSchildelschilde@apexRnD.co.nz

Extra

Oracle Technology Network http://otn.oracle.com/apexAPEX Community http://apex.oracle.com/communityOracle Learning Library http://www.oracle.com/ollHosted evaluation site http://apex.oracle.com