Intermediate Oracle Application Express (APEX) Training

Duration: 5 Half Days (~20 hours)

Teacher

What You Will Learn

Sustainable Enhancements to APEX applications
Extending declarative functionality with custom code
Interactive Grids
Custom Dynamic Action
The correct way of using HTML / CSS / JS in APEX

Description

Take the next step in your APEX development skills. In the second course in our APEX curriculum you will learn about controlling behavior between the many different APEX components such as charts, reports, and forms. This course is intended for developers who have built a few applications already or have attended our introduction class.

Need help deciding if this class is right for you? Call us at 1-401-783-6172.

Attend this class and get 20% off our Advanced APEX class.

“[the instructor] was especially enthusiastic, and took time to answer any questions thoroughly!”

Prerequisites

Introduction To APEX class
Basic APEX knowledge
Basic Structured Query Language (SQL) knowledge
Webdev technology is a plus

Course Features

Lectures 0
Quizzes 0
Duration 5 Half Days (~20 hours)
Skill level All levels
Language English
Students 211
Certificate Yes
Assessments Yes

APEX Best Practices

Customizing the install for easier backups
Managing developers and user accounts
Securing applications
Preventing URL tampering
Managing External Files
Techniques to Make Development Easier
Developing a Standard Application to Copy

Navigation

How to use Navigation Entries, Lists, and Breadcrumbs to connect pages
Using components on the global page(page zero)
Resolve missing Navigation Entries and Breadcrumbs

Region and Item Layout

How to leverage Grid Layout for Regions and Items
How to change region positions
Understand how page templates works

Reports

Customize report templates
Discuss column templates vs row templates
Understand generic column vs named column reports

Charts

How to create and manage pie and bar charts
JET Chart basics

Interactive Grids

Create Interactive Grid
Declarative row level validations
Adding custom processing
Review the importance of record locking

Themes and Templates

Creating Custom Templates
Using Subscriptions

Build a plugin

A overview of the plugin interface and the different functions that exist: render, ajax, validate, and meta
Understand how a plugin renders
Create an AJAX call and process to update the plugin
Bind to the native API so it works with native dynamic actions

Data Loading

Create data upload form for users
Process CSV and other delimited data
Transform the data upon upload
Validate and reject rows

Dynamic Actions

Refresh items and regions
Invoke PL/SQL processes from browser events
Retrieve data from the DB and set items values

Working with Files

User managed files in the database
Developer files on the webserver(JavaScrtipt, css, and images)
Upload shared component files
REST services for Media Resources

Understanding Session State

Understand the difference between persisted and in-memory session state
How row fetch and row processing actually works
Explore some of the features those processes provide

Security

Custom Authentication and Authorization
Implementing LDAP and SSO
Using Virtual Private Database(VPD)
Using Session State Protection
Preventing SQL Injection
Preventing Cross-Site Scripting
Managing Application Development

Greg Jarmiolowski

https://skillbuilders.com/our_team/greg-jarmiolowski/

5/5

What did you particularly like about the course?
This course picks up from Introduction to Oracle Application Express.

Please describe your suggestions for improvement of the course.
Even with the attending Introduction to Oracle Application Express, it would be helpful if there were a quick review.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?
The course exercises are very confusing. I believe it happened with the Intro class. There are typos like "Workshops" for exercise 1, then "Workshop" for exercise 2. It could lead the student to create a new application.

Erin Rankin

April 14, 2022

4.9/5

What did you particularly like about the course?
This class was very informative. It helped to fill in the blanks on how some things work within Apex. The instructor did a great job on answering individual questions and showing how an example works or might be applicable.

Please describe your suggestions for improvement of the course.
More active workshops or practice time. I learn better when I am following along and working on an example.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?

Krista Minton

February 25, 2022

5/5

What did you particularly like about the course?
The sections on Interactive Grids, Interactive Reports, Navigation/Linking will be especially useful to me. Templates will also be useful; I am trying to improve the efficiency and "look" of my app. Gary was enthusiastic and knowledgeable.

Please describe your suggestions for improvement of the course.
A few more workshops, more practice time. Written materials would also be helpful!

If this was an online course, do you have suggestions for improving the online software or delivery techniques?

Jill Stern

February 25, 2022

4.8/5

What did you particularly like about the course?
This was an excellent class that covered both theory and practical applications. I now understand more about how APEX works, have more tools in my toolkit, and have a library of examples that I can draw from. I also appreciate the recordings.

Please describe your suggestions for improvement of the course.
I learn best by doing, so I would have preferred that the course interleaved the hands-on exercises more frequently, instead of at the end of an hour or two of demos.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?
A few of the workshops' instructions were missing steps or context. Our instructor filled us in, so it wasn't a problem during the course, but could be when referring to them in the future. And since they're HTML files, I couldn't add my own notes.

Jessica Reed

February 25, 2022

4.9/5

What did you particularly like about the course?
Many insights gained with some "ah-ha" moments.

Please describe your suggestions for improvement of the course.
Fix the typo's in the workshop documents - like references to wrong pages and such.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?

Ann Evilsizer

February 25, 2022

4.9/5

What did you particularly like about the course?
Greg was prepared to present materials in the time established in the agenda, acknowledged questions, and reworked exercises quickly when needed. Apex workspace for practice and the notes are also appreciated.

Please describe your suggestions for improvement of the course.
Teaching 'intermediate' is a challenge because Apex developers bring a variety of strengths and weaknesses. I would appreciate it if Skillbuilders would post a self-graded quiz that would direct students to correct course.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?
Self-assessment as described above, then before/after sessions with instructors, I can see watching the videos and doing the exercises alone, but I would miss the other students. Also I would cave more to distractions without a class to be in.

Elizabeth Janes

February 25, 2022

4.8/5

What did you particularly like about the course?

Please describe your suggestions for improvement of the course.
Please provide the dropbox material for recordings and scratch pad application.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?

Ambika Vivekanandan

February 25, 2022

5/5

What did you particularly like about the course?
The instructor was very knowledgeable and patient. He knew how to handle the different questions from the students while not losing track of the course materials

Please describe your suggestions for improvement of the course.
Perfect as is

If this was an online course, do you have suggestions for improving the online software or delivery techniques?
Perfect as is

Joseph Kenny

February 25, 2022

4.9/5

What did you particularly like about the course?
We really like Tyson. He is very helpful, never rushes through an answer, always willing to listen and fully answer any question. He really knows his stuff and we learned a great deal.

Please describe your suggestions for improvement of the course.
Slides could use more detail and need to be up-to-date.More hands-on work, and more detail in workshop descriptions and slides.Follow through on requests made to cover specific material or at least communicate otherwise.Need time for lunch break.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?

Dan Goldman

October 11, 2021

5/5

What did you particularly like about the course?
Love the workshops (hands on) aspect. Really appreciated the instructor (Tyson) and the time he took to not only explain his answers to my questions but also make sure I understood by checking in. So thankful this is being recorded for us to go back to!

Please describe your suggestions for improvement of the course.
I think this class had more SQL demo's than i would have liked - however that is because i don't know SQL (yet). So i felt a little lost when going over this. Also, in the beginner (see email to gary@skillbuilders.com for full thought.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?
I am not sure what this means - everything worked well though so I guess i don't have any suggestions. :)

Amy Rohrbacker

October 8, 2021

Details Price Qty

06/13/22 - 06/17/22show details +hide details - $2,700.00 (USD) Quantity

Details

Price

Name	Description	Amount
06/13/22 - 06/17/22		$2,700.00 (USD)
Total		$2,700.00 (USD)

Sale Dates

- The dates when this option is available for purchase.
Goes On Sale: May 5, 2022 8:00 am
Sales End: June 13, 2022 8:00 am

Access

- This option allows access to the following dates and times.

Date	Time
06/13/22 - 06/17/22 June 13, 2022	1:00 pm to 5:00 pm

please do not enter anything in this input

Oracle APEX Training

Intermediate Oracle Application Express (APEX) Training

What You Will Learn

Description

Prerequisites

Course Features

Details

Price

Sale Dates

Access

Login with your site account

Register a new account

Email preferences

Select your interests

Modal title