Intermediate Oracle Application Express (APEX) Training

User Avatar
Tyson Jouglet
 4.8/5 (72)
$2,700.00

“Learn

 

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

Requirements

  • Introduction To APEX
  • Basic APEX knowledge
  • Basic SQL knowledge
  • Webdev technology is a plus

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.

“Tyson was especially enthusiastic, and took time to answer any questions thoroughly!”

Course Features

  • Lectures 0
  • Quizzes 0
  • Duration 3 Days
  • Skill level All levels
  • Language English
  • Students 0
  • 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
author avatar
Tyson Jouglet

    https://skillbuilders.com/our_team/tyson-jouglet/

    Leave A Review

    Please provide as much detail as you can to justify your rating and to help others.




     5/5

    How well Tyson explains the material. He is always willing to answer questions on the course material.

    keep dropbox material a little longer to be able to download it.

    James Yataco
    January 8, 2021
     4.8/5



    Shruthi Shruthi
    January 8, 2021
     5/5



    Scott Cook
    January 8, 2021
     4.7/5



    Krupakar Konikanti
    January 8, 2021
     5/5

    Tailored to our questions

    Maybe pause for a second when demonstrating, before changing each page. I mostly kept up, but there were a couple of times I was looking for a field to change and missed the next step because I took too long to find it.

    Tyson does a good job!
    Erik Slazyk
    September 4, 2020
     4.8/5

    I liked the opportunity to bring questions to Tyson. I appreciated how he walked us through solutions to our quetions.

    I would have liked the opportunity to submit questions ahead of time for the instructor to review. I think this would have helped to structure the class a bit more.

    Not at this time.
    Ashley Raber
    September 4, 2020
     5/5

    I learned a lot of tips & tricks that I wasn\'t aware of and it was beneficial to use APEX 20.1 to see the new features that have been deployed. Tyson is extremely knowledgeable about the subject matter and Oracle in general.

    The only thing I would recommend is more time to do the exercises. I wish I had two monitors so I could follow the presentation and apply it to the APEX site I was using.

    The software works well. Only a couple of time did the voice break up and it was back momentarily.
    PHIL WARREN
    June 5, 2020
     5/5

    Tyson is a joy to listen too and work with. We immediately connected and I feel extremely comfortable interacting with him. He provides articulate instruction and is willing to stop and help out when you get stuck.

    Some optional workshops or examples that can be done on your own time would be a great addition.

    Sometimes the audio gets a little choppy, but overall things went well technically.
    Michael Hartman
    April 17, 2020
     4.8/5

    The subjects and information Tsyon gave us. The intermediate course is good to do afther the basis information course.

    Some modules went on for to long.

    kstaps@smart4solutions.nl
    March 6, 2020
     5/5

    Instructor was very knowledgable in many areas. Tied things together nicely

    Got off track a few times, sometimes this is good though....

    Mike Mutter
    March 6, 2020
     5/5

    a great course to follow, i would suggest people to obtain at least couple of weeks or more hands-on experiences on APEX before jump into the Intermedia course. A general understanding of CSS, html and javascript is recommended as well


    Chao Yu
    March 6, 2020
     4.7/5

    Extra nuggets of information that were included and not part of the outline (e.g. lots of good web site references given that will be useful in the future).

    Sometime he \"over answers\" - more info given than needed to answer a question. Can sometime just make it more confusing.

    nope. worked great for me.
    Mike Duffy
    February 6, 2020
     5/5

    Tyson used every minute of the allotted time to provide valuable and useful information. I have already implemented several of the ideas he presented during the course, and am in the process of implementing several more. This course has saved me many hou

    It was online, but I can\'t think of a single thing to improve it. It was outstanding!
    sskasser@hotmail.com
    February 6, 2020
     4.9/5
    Jaimie Baccus
    September 11, 2017
     5/5
    Francisco M. Calm
    August 14, 2017
     5/5
    Armando Umandap
    August 14, 2017
     5/5
    Dennis Malkowski
    July 10, 2017
     4.9/5
    Darrell Lawrence
    May 15, 2017
     2.3/5
    Shahid Munir
    May 15, 2017
     4.8/5
    Dylan Howard
    May 15, 2017
     4.9/5
    paul_garber@waters.com
    March 13, 2017
     4/5
    Vijay Shah
    December 12, 2016
     4.7/5
    Antuane Latimore
    December 12, 2016
     5/5
    SuryRicciardi@polk-county.net
    November 14, 2016
     5/5
    Darryl Maraj
    November 14, 2016
     5/5
    Mulu Bekele
    October 3, 2016
     5/5

    [What did you particularly like about the course?] Simply, it was helpful.

    Everything was fine except we experienced some issues with the sound on the first day. However, I think it was specific to the presenter's internet connection and he resolved it.
    Clay Walls
    October 3, 2016
     5/5

    The instructor was very knowledgeable

    Overall the class was very good. Sometime I think the class did wonder off topic. I would prefer to do the class eval on my own time instead of during class time
    Dan Dailey
    October 3, 2016
     5/5

    The Instructor was very knowledgeable about the material.
    Bryan Moore
    October 3, 2016
     4.3/5
    Dan Brennan
    October 3, 2016
     5/5

    [What did you particularly like about the course?] flexibility to go into topics not covered in core curriculum
    Bobby Lai
    September 19, 2016
     4.7/5
    Subhashis Chakraborty
    September 19, 2016
     4.4/5

    Tyson's knowledge and enthusiasm for the subject was great!
    Paul Stearman
    September 19, 2016
     5/5
    Sridhar Ramaswamy
    September 19, 2016
     5/5
    Stephen George
    September 19, 2016
     4.5/5

    Tyson was knowledgeable and confident, so felt we got the best knowledge.
    Balaji Namasivayam
    September 19, 2016
     5/5

    Tyson shared lots of information about APEX that is not available in books or that I knew was available. He also was able to give examples to clarify examples.

    This class was very well presented.
    Gregory Gaynes
    September 19, 2016
     4/5
    Eyad Odeh
    July 25, 2016
     4.4/5
    Yousif Edan
    July 25, 2016
     5/5

    The information was valuable and presented well by Tyson.

    Access to video of that day's particular module directly after the class would be helpful in cementing the lessons.
    Don Ricardo JR
    June 13, 2016
     4.2/5

    [What did you particularly like about the course?] Real world knowledge

    Wait about 2 s more for feedback before proceeding Make sure people know that early workshops are used by later workshops.
    Paul Steinbach
    June 13, 2016
     5/5

    [What did you particularly like about the course?] class was great and instructor was great, he too time to explain what was not clear
    Slavik Gidenko
    June 13, 2016
     4/5
    Alex Ta
    June 7, 2016
     4.9/5

    [What did you particularly like about the course?] In depth life applicaton
    Chan-Hsiang Liu
    June 7, 2016
     5/5
    Hasmik Hatamian
    June 7, 2016
     4.5/5
    Gonzalo Calderon
    June 7, 2016
     5/5
    Jenny Zhang
    June 7, 2016
     5/5
    Danny Pham
    June 7, 2016
     4.8/5
    Huy Tran
    June 7, 2016
     5/5
    Luke Liu
    June 7, 2016
     4.3/5

    the instructor was very good in guiding every steps.
    He encouraged us asking questions.
    that was very helpful.
    yangsoon ji
    May 2, 2016
     4.8/5

    Being able to follow along and do exercises with Tyson.

    on-line interaction was perfect.
    George Rakauskas
    May 2, 2016
     5/5
    Tray Halverson
    May 2, 2016
     5/5
    Jane Yan
    April 4, 2016
     5/5

    Tyson explained very concisely and gave many examples on each topic. Also the online presentation of the 2 seminars were much fitting much better into my learning specifics.
    gheorghiu_alice@smc.edu
    April 4, 2016
     5/5
    LIU_WENDY@smc.edu
    April 4, 2016
     5/5

    [What did you particularly like about the course?] The way in which the instructor encouraged examples from our own APEX environment. He helped us see ways to apply the class to SMC specific problems
    Brian Pena
    April 4, 2016
     5/5
    James Killion
    March 28, 2016
     5/5

    Tyson was especially enthusiastic, and took time to answer any questions thoroughly!
    Joseph Myers
    February 29, 2016
     4.5/5

    The instructor dedicated a lot of time to explain concepts that were unclear to us. He didn't went further through the course until all of us understood the lesson we were working on. He gave good examples and was well prepared for our questions.
    Goran Pacelat
    February 29, 2016
     3.2/5
    John Holt
    February 29, 2016
     4.5/5

    lots of information
    jtomkins@ucsc.edu
    February 29, 2016
     4.6/5

    Tyson was a good presenter. Learning new stuff

    On line content was very good...
    David Gruginski
    December 14, 2015
     5/5

    I like the GoToTraining session.
    Jay Alspaugh
    December 14, 2015
     5/5

    Tyson was a great instructor. Made everything understandable, even for a baboon like myself. I think he made a mistake once or twice, but he smoothly recovered and turned it into a learning experience. Well done!

    GoToMeeting worked fine.
    Jeff Johnson
    December 14, 2015
     5/5

    [What did you particularly like about the course?] How to use the page designer. Tyson had deep knowledge of all topics covered and was never stumped.

    [Improvement needed] Nothing - It was great!

    Text in viewing image was pretty small except when instructor enlarged it, (e.g., when typing code). Default was 56% but if I increased that size, I couldn't scroll the window to see everything.
    Scott A Gray
    December 14, 2015
     5/5
    Ying Shi
    December 14, 2015
     5/5

    [What did you particularly like about the course?] Its pertinence to what I wanted and need to know. The presentation.
    Rick Nickerson
    December 14, 2015
     5/5

    [What did you particularly like about the course?] dynamic actions, error handling
    Tony Bowers
    December 14, 2015
     5/5

    I liked that Tyson would use some on the fly examples. When he ran into an occasional issue, he talked through the troubleshooting steps he was taking and explained what the problem was as he corrected it. He also did a good job of answering all of my q
    Jim Jennings
    November 9, 2015
     5/5

    Great information to expand my understanding of more advanced APEX topics. Instructor was excellent and extremely knowledgeable.

    In both the intro and advance class we did not have enough time to get through all the topics. Perhaps some extra hours should be added to each class in order to cover all the material. But it was extremely helpful that Tyson took the time to answer spe
    Marianne Shaieb
    November 9, 2015
     4.4/5

    Very well done
    Vitor Oliveira
    November 9, 2015
    $2,700.00
    Details Price Qty
    05/17 - 05/21show details +$2,700.00 (USD)  
    06/21 - 06/25show details +$2,700.00 (USD)  

    You May Like

    Copyright © Skillbuilders.com

    Free Online Registration Required

    The tutorial session you want to view requires your registering with us.

    It’s fast and easy, and totally FREE.

    And best of all, once you are registered, you’ll also have access to all the other 100’s of FREE Video Tutorials we offer!

     

    ×

    Message modal