Packt Publishing – Oracle APEX Techniques

Packt Publishing – Oracle APEX Techniques

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

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

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

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.

Get Packt Publishing – Oracle APEX Techniques At tenco.pro

Course Curriculum

Getting Started with Oracle Application Express

• Creating Your Workspace (4:23)
• Creating Your First Application (2:27)
• Creating Your First Pages (3:31)
• Creating Your First Item on a Page (2:26)
• Finding Your Way around APEX (3:58)

Managing Your Themes and Templates

• Creating Your Own Theme (3:53)
• Creating a Custom Template (3:01)
• Including Images in your Application (3:03)
• Referencing CSS (2:28)
• Controlling Layout (3:24)

Extending APEX

• Adding JavaScript to Your Application (2:39)
• Adding Visual Effects to Your Application (3:15)
• Loading Delimited Data (3:50)
• Inserting Multimedia to Your Application (3:45)
• Consume an Item Plug-in (3:58)

Deploying Dynamic Actions

• Getting Data from the DB without Submitting a Page (3:49)
• Updating the Database without Submitting a Page (2:52)
• Disabling Fields Based on Item Selection (4:01)
• Refreshing a Report Like Google Search Does (2:36)
• Adding Browser-level Item Validation (2:35)

Reporting from APEX

• Creating a Hidden Report and Linking CSV Downloads to a Button (3:42)
• Creating an Interactive Report (3:48)
• Configuring an Interactive Report (3:56)
• Understanding an Interactive Report – Detail View (2:53)
• Reporting using BI Publisher (2:51)

Using Supplied APEX APIs

• Processing Custom Tabular Forms (4:35)
• Reading a Checkbox Programmatically (2:59)
• Using APEX_application.help (2:26)
• Counting Clicks with APEX_util.count_click (2:19)
• Managing your Workspace with Supplied APIs (2:11)

Looking closer at the APEX Environment

• Setting up Application Subscriptions (3:13)
• Debugging an APEX Application (2:12)
• Debugging using the Browser (2:07)
• Deploying and Managing APEX with SQL Developer (2:07)
• Expanding the Development Environment (1:47)

Configuring APEX Security

• Securing your Application with Custom Authentication (3:45)
• Protecting your Pages with Authorization Schemes (2:50)t
• Configuring Session State Protection (2:40)
• Cross-site Scripting (2:33)
• Mitigating SQL Injection (2:57)

Get Packt Publishing – Oracle APEX Techniques At tenco.pro