Free Sample
+ Collection

Oracle APEX Techniques [Video]

Scott Wesley

Go beyond the basics and explore how to make the most of the Oracle Application Express environment
RRP $84.99

Want this title & more?

$12.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Video Details

ISBN 139781849689342
Course Length120 mins

About This Video

  • Make the most of the extensibility of Oracle APEX 4.2
  • Deploy dynamic actions to make your application more interactive without needing to learn JavaScript
  • Provided with practical examples and solutions to problems you will encounter as you start to push the product to fit your requirements

Who This Video Is For

No presumption is made of skill using Oracle Application Express, but it's helpful to have a general understanding of writing Oracle SQL, PL/SQL, and how a web page is constructed. Experience with JavaScript is not required. This course is aimed at beginner to intermediate developers, providing the foundation for exploring the advanced.

Table of Contents

Getting started with Oracle Application
Creating your Workspace
Creating your First Application
Creating your First Pages
Creating your First Item on a Page
Finding your Way around APEX
Managing your Themes and Templates
Creating your Own Theme
Creating a Custom Template
Including Images in your Application
Referencing CSS
Controlling Layout
Extending APEX
Adding JavaScript to your Application
Adding Visual Effects to your Application
Loading Delimited Data
Inserting Multimedia to your Application
Consume an Item Plug-in
Deploying Dynamic Actions
Getting Data from the DB without Submitting a Page
Updating the Database without Submitting a Page
Disabling Fields based on Item Selection
Refreshing a Report like Google Search
Adding Browser Level Item Validation
Reporting from APEX
Creating a Hidden Report and Linking CSV Downloads to a Button
Creating an Interactive Report
Configuring an Interactive Report
Understanding an Interactive Report Detail View
Reporting using BI Publisher
Using Supplied APEX APIs
Processing Custom Tabular Forms
Reading a Checkbox Programmatically
Counting Clicks with APEX_util.count_click
Managing your Workspace with Supplied APIs
Looking closer at the APEX Environment
Setting up Application Subscriptions
Debugging an APEX Application
Debugging using the Browser
Deploying and Managing APEX with SQL Developer
Expanding the Development Environment
Configuring APEX Security
Securing your Application with Custom Authentication
Protecting your Pages with Authorization Schemes
Configuring Session State Protection
Cross-site Scripting
Mitigating SQL Injection

What You Will Learn

  • Create your workspace, application, and first page - then find your way around the development environment
  • Enhance the look and feel of your application using themes and templates
  • Add value to your application by extending APEX with JavaScript, visual effects, and multi-media
  • Explore some of the customisable reporting options APEX provides
  • Learn how to build pages with Interactive Reports that don't look like reports
  • Learn some useful supplied APIs to save re-inventing the wheel
  • Discover debugging techniques and instrumentation techniques to assist your problem solving
  • Discover some instrumentation methods to help debug any problems that may arise
  • Configure your application security from log-ins, to roles, to browser security

In Detail

Oracle Application Express 4.2 is a diverse web application development tool  that helps you build and deploy applications with the latest techniques in JavaScript. A great way to learn these techniques is by watching how Oracle APEX can be used as a tool to create a feature-rich application that comes together before your eyes in small, concise sections, which gives you a chance to repeat the process yourself.

APEX provides you with the ability to extend what's provided out of the box. This video series shows you how to do this - from using Dynamic Actions, to adding JavaScript declaratively, to using multiple reporting options, and the supplied API, down to securing your application from attacks.

Starting by creating a workspace, you will construct a basic application, learn techniques to go beyond the basics, and conclude with the knowledge on how to apply this to your own development environment.

You will learn how to create and enhance your own theme template, add JavaScript and visual effects to your application, deploy Dynamic Actions, create and configure an Interactive report, process custom tabular forms, debug an APEX application, and finally expand and secure the development environment, allowing you to enhance your application to a new level in APEX.

Oracle APEX Techniques is a course that doesn't just teach you how to build a simple application, it will provide you with the skills necessary to expand your applications beyond the basics.



Read More