Oracle APEX Techniques

Go beyond the basics and explore how to make the most of the Oracle Application Express environment
4.4 (5 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
125 students enrolled
$85
Take This Course
  • Lectures 40
  • Contents Video: 2 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2015 English

Course Description

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.

What are the requirements?

  • 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.

What am I going to get from this course?

  • 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

What is the target audience?

  • Experience with JavaScript is not required. This course is aimed at beginner to intermediate developers, providing the foundation for exploring the advanced.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started with Oracle Application Express
04:23

A workspace is required to commence development in APEX; learn how to create one. Create a workspace in your APEX environment.

02:27

Creating your first application can seem scary. See how easy it is with the development wizards. Create your first application using a wizard.

03:31

Some development tools require a lot of work to create something small. APEX is a RAD tool that allows you to quickly create pages. Create a feature-rich interactive report with an accompanying form.

02:26

We need to let the user find the data quickly. Let's add a search field to the report page. Create an item as the search criteria for your report.

03:58

To first timers, the APEX development environment can be daunting. Discover common tasks that will help you find your way. Learn your way around the APEX environment.

Section 2: Managing Your Themes and Templates
03:53

Protect your theme from APEX patches by making a copy of an existing theme in your workspace. Learn how to define your own workspace theme.

03:01

One size doesn't fit all. Customise templates to suit your needs. Create your own customised region template.

03:03

Websites without pictures are bland. Learn ways to include image content. Enhance your page layout by including images.

02:28

The libraries that are provided don't have all the styles. Find out how to add your own CSS. Enhance the look of your page by including your own CSS.

03:24

There is more than one position on the screen to deliver content. Learn how to use these locations wisely. Become familiar with page templates to control region positions on your page.

Section 3: Extending APEX
02:39

Improve data quality and expedite data entry by using browser-level JavaScript validation. Learn how to add JavaScript to your application.

03:15

Don't build boring applications that look the same. Step outside the square and add visual effects to your application using jQuery. Enhance your application's look by using jQuery to define clever UI components.

03:50

Loading CSV files into a table is a common request. APEX provides an easy, wizard-driven solution. Use APEX's own extensions to upload delimited content.

03:45

Purely textual content can be boring. Liven up your application by embedding multimedia. Find out how to embed multimedia content within your pages.

03:58

Select lists with a larger number of rows can look untidy. Group similar rows using this free item plug-in. Use a plug-in from the community to enhance select lists in your application.

Section 4: Deploying Dynamic Actions
02:52

To provide a more interactive experience, sometimes you need to update the data without submitting a page. Use a dynamic action that saves the input on the click of a button. Update the database without submitting the page.

03:49

Developers often want to emulate the Forms functionality. Learn how to retrieve information based on user input without submitting the page. Define a dynamic action that runs an Ajax request to populate other fields.

04:01

Data entry can be more effective if fields are conditionally displayed before submitting the page. Dynamic actions will allow you to show/hide fields without having to handcode JavaScript. Hide/Disable/Show fields based on item selections – no JavaScript required.

02:36

Some search screens could be made very user friendly by changing results displayed after each key press. Use a dynamic action to trigger this refresh event. Configure a report to show records based on the criteria as it's entered.

02:35

Data quality may be improved by validating the data before page submission. Dynamic actions simplify this process. Add browser-level validation using basic JavaScript.

Section 5: Reporting from APEX
03:42

It may be unfeasible to display many reports on one page with download links. Find out how to create a hidden report with a download link. Learn how to piece together an APEX URL that launches the CSV download on the click of a button.

03:48

Classic reports are the workhorse of the APEX environment, but are limited. Interactive reports offer many more options out of the box. Discover the feature-rich components that interactive reports (IR) provide.

03:56

A flat view of records sometimes isn't enough. Interactive reports allow the user to customize how the output is shown at runtime. See how to customize the view of an interactive report.

02:54

Traditional row/column view of classic reports can be boring. See how you can dress an IR to show information more creatively at design time. Configure your IR so it doesn't even look like a standard report.

02:51

For APEX to interface with BI Publisher, there needs to be development components. Oracle provides this and more with BI Publisher Desktop & APEX queries and layouts. Set up report query and report layout required for BI Publisher.

Section 6: Using Supplied APEX APIs
04:35

Data submitted via tabular forms generate PL/SQL arrays. Learn how to process these with PL/SQL. Discover how to process array data from a tabular form.

02:59

In tabular forms, checkboxes behave differently to other item types. Learn how to preprocess this array in PL/SQL. Learn how to use checkboxes effectively in tabular forms.

02:26

Encourage your users to read context-sensitive help by enhancing the help content. Enhance your application by customizing the Help page.

02:19

Metrics are important to help measure the success of the application. Learn how to count how often links are clicked. Measure the level of interest within your application by counting clicks.

02:11

Workspace management using the browser can be laborious. Create scripts using APIs to help automate the process. Manage your workspace and applications with scripts using supplied APIs.

Section 7: Looking closer at the APEX Environment
03:13

If you have multiple applications that need to look the same, repeating all the work can be an issue. Use subscriptions to push changes to multiple applications. Save rework amongst applications by using APEX subscriptions.

02:12

Got a bug in your application? Learn how to use debugging options effectively. See how to use the in-line debugging options in APEX.

02:07

Not all errors are PL/SQL related. Learn how to debug your HTML and JavaScript with browser debugging options. Use browser inspection tools to debug your application.

02:07

Using the browser to manage APEX isn't always an option. See how SQL Developer makes command-line requests with some basic mouse clicks. Use SQL Developer to remotely manage your applications.

01:48

Learn the correct way to define columns for your reports and help prevent users from using inserted data to run malicious code. Learn how to write SQL that is not susceptible to SQL injection attacks by defining a report with a searchable field.

Section 8: APEX Security
03:45

What if you want to configure the log in process to use your existing tables? Learn how to define custom authentication to do this. Define a custom authentication theme and use it to authenticate log ins to your application.

02:50

Certain pages in an application may only be accessible to privileged users. Discover how to effectively secure pages using authorization schemes. Create an authorization scheme and secure access to a page based on that theme.

02:40

It is easy for the savvy user to modify the URL to access information they shouldn't see. Secure from URL tampering by using session state protection. Stop users from maliciously or accidentally modifying secured items in your application.

02:33

Users can enter special data in your normal forms to run browser scripts. See how to display this data so it's shown as it was entered, not run as a script. Learn the correct way to define columns for your reports to prevent malicious code (entered as data) from being executed.

02:57

Poorly written queries are susceptible to SQL injection, potentially exposing secure data. See the correct way to write your queries using bind variables. Learn how to write queries that may not be modified by the end user.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Packt Publishing, Tech Knowledge in Motion

Over the past ten years Packt Publishing has developed an extensive catalogue of over 2000 books, e-books and video courses aimed at keeping IT professionals ahead of the technology curve. From new takes on established technologies through to the latest guides on emerging platforms, topics and trends – Packt's focus has always been on giving our customers the working knowledge they need to get the job done. Our Udemy courses continue this tradition, bringing you comprehensive yet concise video courses straight from the experts.

Ready to start learning?
Take This Course