Advanced Oracle Application Express (APEX) Workshop
Duration: 3 Days

Tyson Jouglet

4.6/5 (161)
$2,400.00
  • Call for Group or Alumni Discounts.
    If you are a student of an accredited academic institution call us for a 25% discount.

    • In this course you will learn how to approach fine tuning your application to meet pixel perfect visual requirements. We will explore how to manually process forms both standard and tabular. We will discuss error management as well as debugging techniques using SQL/Developer integration. We will also build and consume RESTful web services using the declarative framework provided by APEX. Lastly we will look at performance concerns and common pitfalls and how to avoid them. This course is intended for a seasoned APEX developers who can very easily navigate the environment and component attributes.

    “Demos were very thorough, Many topics covered, but with plenty of detail. Tyson is awesome”

    “The teacher was very helpful and he really knew his material. Excellent teacher.”
    COMPLETELY UPDATED FOR APEX 18.1 !!
    Price Qty
    Advanced APEX Workshop 12/16 - 12/20show details + $2,400.00 (USD)  
    Advanced APEX Workshop 12/16 - 12/20show details + $2,400.00 (USD)  

    Customizing APEX Templates
    • Create Custom Templates
    • Use Subscriptions
      Building your own theme
    • Find a sample site and convert it to an APEX theme
    • How to approach modulating a design into components
      Responsive Web Design  
    • Allow applications to re-size to any device
    • Brief CSS overview
    • How do media queries work
    • Using print media query
        APEX Collections  
    • Create and use a collection.
    • Build an event application using a collection
    • Discuss collection limitations
    • Wrap collections in a database view
        Manual Forms with PL/SQL  
    • How to convert a declarative form to a manual form
    • Understand row locking in a web environment
    • Discuss MD5 hash and row versioning
    • Detect if row level updates are needed
        Manual Tabular forms  
    • Manually Creating Tabular Forms
    • Validation in Tabular Forms
    • Working with Collections
        Error Trapping & Logging  
    • Brief discussion on the interface injection design pattern
    • How to catch errors raised within APEX and PL/SQL
    • Map constraints and errors to friendly messages
        Debugging  
    • How to use the apex_debug API
    • How to approach locating a bug
    • Understand the sequence of events that happen on a page
    • Integrate SQL developer line by line debugger
        SQL Developer & APEX Integration  
    • Custom views and reports
    • Managing apex environment
    • Deploying applications
        Performance  
    • Settings which impact application performance
    • Fixing report pagination
    • How to use a dynamic report source
        Production Issues  
    • How to deploy an application
    • Discuss deployment strategies
    • Manage database objects, apex objects, and developer files
    • Deployment workflow
        Intro to Mobile Development  
    • Build a simple app using list views
    • Link the mobile app to the desktop version
    • Understand different user interfaces
        REST services - Publish  
    • Discuss ORDS(Oracle Resful Data Services) requirements
    • Create a declarative services to expose data for disparate systems
      REST services - Consume  
    • Read web service data from PL/SQL
    • Perform AJAX operations to retrieve data
    • apex.process javascript object
       
    Tyson Jouglet
    https://www.skillbuilders.com/our_team/tyson-jouglet/

    5/5

    Armando Umandap

    October 10, 2017

    3.3/5

    Scott Recher

    September 5, 2017

    4.9/5

    joseph dizon

    September 5, 2017

    4.8/5

    Michael Klapp

    March 6, 2017

    4/5

    Eyad Odeh

    March 6, 2017

    5/5

    SuryRicciardi@polk-county.net

    January 3, 2017

    4.5/5

    James Varga

    January 3, 2017

    4.8/5

    Puneet Datta

    January 3, 2017

    5/5

    Darryl Maraj

    November 28, 2016

    4.9/5

    Arleah D'Agostini

    November 28, 2016

    5/5

    Clay Walls

    October 24, 2016

    5/5


    everything was well prepared and delivered as expected

    hailin tang

    August 1, 2016

    5/5

    Margaret King

    May 16, 2016

    4.4/5


    I like workshops, especially about collections and manual tabular forms. I think examples like these are very useful for concept understanding.
    I like when instructor provides some real life examples, links and tools.


    This GoToTraining software worked quite well.

    Ivan Kmetovic

    May 16, 2016

    4.4/5


    Course instructors enthusiasm

    Ade Adekoya

    May 16, 2016

    4.6/5

    Jim Treadway

    May 16, 2016

    5/5


    Tyson is awesome!

    Jane Yan

    April 6, 2016

    4.8/5


    The instructor was awesome -- incredibly knowledgeable!


    Require more time between offering intermediate and advanced (even if it is at the client's request.) Then less time will be spent helping those who have fallen behind. Also, allow more time fro the class as a whole.

    Brian Pena

    April 6, 2016

    5/5


    Presentation of the course by Tyson, the patience and clarity.


    Due to the amount of material the pace was pretty fast. Maybe allow for 1/2 hour or so at the beginning of the course to set up the environment and get familiar with the tool/topic presented.

    gheorghiu_alice@smc.edu

    April 6, 2016

    5/5

    LIU_WENDY@smc.edu

    April 6, 2016

    4.8/5

    Lino Schildenfeld

    March 21, 2016

    5/5


    The instructors knowledge of the material and his understanding of his audience.

    Rick Nickerson

    January 25, 2016

    4.1/5


    The instructor answered every student's question clearly and completely.


    Could include more programming skills.

    Ying Shi

    January 25, 2016

    5/5


    Small class size. Instructor knowledgebase.


    No worked flawlessly for me.

    Heidi Marotta

    October 19, 2015

    5/5


    [What did you particularly like about the course?] examples code for procedural tabular forms.
    I would love a code repository of javascript, css for
    integration into future projects.


    more code lol!


    nope everything was great.
    It would be helpful to have each session broken down as opposed to one recording per day.

    armando plascencia

    October 19, 2015

    4.5/5


    Tyson was very knowledgeable and encouraging - no question was "stupid" he encouraged every one to feel comfortable asking questions.

    Robert Nial

    October 12, 2015

    5/5


    discussion and workshop on dynamic actions


    all good. connection is clear. instructor is engaging and workshops are effective.

    Lorena Benipayo

    October 12, 2015

    4.9/5


    the examples and course


    all good...

    Michael Sierra

    October 12, 2015

    4.8/5


    I liked that the course was customisable to our needs. Very helpful.


    Because the course was so customisable, it met all of our needs.


    [suggestions for improving?] The software delivery techniques were great.

    Craig Cosijn

    October 12, 2015

    4.5/5


    It is great that Tyson says his actions as he does them, otherwise it is difficult to work out which thing was clicked.

    Craig Walker

    October 12, 2015

    4.5/5


    The level of knowledge and extra items around the edge of the subject matter. The instructors presentation skills and technical knowledge skills were fantastic and really made the course enjoyable.


    More workshops where the instructor leads the class.

    Ben Skurka

    October 12, 2015

    4.3/5

    Ron Matlik

    October 12, 2015

    4.9/5


    Trainer was very knowledgeable and paced content well.


    [suggestions for improving?] No, very well done.

    Mick Wells

    October 12, 2015

    4.9/5


    Knowledgeable trainer. Covered a few topics I was weak on or not previously exposed to.

    Adam Townsley

    October 12, 2015

    4.7/5


    Concise and well paced.


    trainees should all be of roughly the same skill level

    Norm Payn

    October 12, 2015

    4.7/5


    Combination of presented material and workshops worked well for me.

    David Dowdle

    October 12, 2015

    4.3/5


    My class was fairly small which was nice


    [suggestions for improvement] Overall it was very good, but the course has a lot of information, and so more time would be nice.


    [do you have suggestions for improving the online software or delivery techniques?] I actually liked the software, no need to install anything and my screen was easily shared. In other words I don't have any suggestions.

    Jakub Kircun

    September 28, 2015

    4.5/5


    [What did you particularly like about the course?] learn a lot of things I have not seen in my self-taught

    MYLINH NGUYEN

    September 28, 2015

    5/5


    The instructor went deep to every detail of the workshops.

    riliescu@usgs.gov

    July 27, 2015

    5/5


    It gives me more knowledge other than what I already know.


    [suggestions for improvement of the course?] Spend more time on templates and layout.

    Mar Castro

    July 27, 2015

    4.8/5


    Covered a lot of advanced APEX capabilities

    Brian Hopper

    July 27, 2015

    4.7/5


    very detail instructions ... Nice!


    [suggestions for improvement of the course.] Need more than just 2 days ... maybe extend this to 3 days

    Mein Petsche

    July 9, 2015

    5/5

    Julie A. Ohnesorge

    July 9, 2015

    4.6/5

    Dave Barnhart

    July 9, 2015

    5/5


    The teacher was very helpful and he really knew his material. Excellent teacher.

    Jasna Klenjoska

    July 9, 2015

    4.8/5


    I like that the topics covered allow the developer to better understand the customization of logic and design the tool is capable of. It allowed me to determine areas of deeper focus for further study.

    Daniel Prudhoe

    July 9, 2015

    5/5


    Slides/notes are a good source for later reference

    Kostatin Bojovic

    July 9, 2015

    4.8/5


    Demos were very thorough, Many topics covered, but with plenty of detail. Tyson is awesome

    Jeff Kobe

    July 9, 2015

    5/5

    Brian Leahy

    July 9, 2015

    4.6/5

    First Last

    July 9, 2015

    5/5


    Very interactive and informative.

    Andrew Scott

    July 9, 2015

    4.7/5

    Daniel Latarski

    July 9, 2015

    5/5

    Kenn Liu

    June 8, 2015

    4.8/5


    Include course handouts for step-by-step workshops.

    Omar Rivera

    June 8, 2015

    5/5


    [What did you particularly like about the course?] The discussion on our real world problems and possible solutions from the course's material and from the instructor's experience.

    Calvin Hoang

    June 8, 2015

    5/5


    [What did you particularly like about the course?] the extent and detail of instructor's explanations regarding questions.


    maybe offer a 4 or 5 day class to cover more concepts in detail.

    Marcelino Ramos

    June 8, 2015

    4.6/5


    Instructor answered questions thoroughly

    OMAR SANTOS

    June 8, 2015

    5/5


    Great instructor. Very knowledgeable [Tyson Jouglet]

    Gary Jackson

    April 27, 2015

    5/5


    The instructor took time to help and step through questions. The instructor was exceptional and did an outstanding job. I definitely will recommend this training to others.

    Koss.Larry@epa.gov

    April 27, 2015

    5/5

    Bill Ferguson

    April 27, 2015

    4.9/5


    recorded video is a great option. hopefully there is not a deadline for us to see these recorded training video..we may not need all sessions of training for now, but may need them in the future..so it would be nice to come back to review these recorded

    Calvin Chu

    April 27, 2015

    4.7/5


    working with files and data loading


    [ suggestions for improving the online software or delivery techniques?] recommend using 2 screens. sometimes it was difficult to follow along and having to minimize and maximize screens or shrinking screen size was a pain.

    Michael Wise

    March 16, 2015

    4.3/5


    Showed me features of APEX I had never used before.


    [suggestions for improving the online software or delivery techniques?] No. the delivery technology worked very well.

    John Cottengim

    March 16, 2015

    4.5/5


    Enthusiasm of the instructor and technical knowledge.


    The on-line Software achieved the delivery of content.

    ade_adekoya01@yahoo.co.uk

    March 16, 2015

    5/5

    Raelyn Clark

    February 23, 2015

    5/5


    The presentation was very well done. The Instructor was very well versed in the subject matter.


    The delivery method was very good.

    Aram Mardikian

    February 23, 2015

    4.9/5


    I liked that the instructor completely understands the subject matter and liked that he included future features in version 5.


    Everything worked as expected I wish I had a second monitor.

    Daniel Odonnell

    February 23, 2015

    4.5/5


    The presenter [Tyson Jouglet] is top notch.

    Ozzy Palacios

    January 26, 2015

    4.4/5


    All the topics were very helpful


    [suggestions for improving the online software or delivery techniques?] I would have liked to try to create a plugin

    Hung Ta

    January 26, 2015

    4.8/5


    [What did you particularly like about the course?] Tyson

    Andrew Young

    December 15, 2014

    4.7/5

    Michael Parker

    December 15, 2014

    4.8/5

    jay.whitis@votec.net

    December 15, 2014

    4.7/5


    [What did you particularly like about the course?] Learning about collections.
    Tyson's delivery style. Very good. Knew his stuff and was always open to questions.

    Paul Donohoe

    December 1, 2014

    4.8/5


    Instructor was excellent and course was very interesting.

    Paul Dwan

    December 1, 2014

    5/5


    The instructor [Tyson Jouglet] was amazing!

    Amanda Scott

    December 1, 2014

    4.1/5

    Eddie Ryan

    December 1, 2014

    4.5/5


    Tyson really knows his stuff. I think the layout of the course was very good but just probably required a little more time.

    Eoin Mullally

    December 1, 2014

    4.3/5

    Stephen Curtis

    December 1, 2014

    4.8/5


    Presenter was a very good communicator and gave time to every question asked.


    [suggestions for improvement of the course] Perhaps a video link to the presenter.

    Michael O'Donovan

    December 1, 2014

    4/5

    Valerie Nolan

    December 1, 2014

    5/5

    David Frezel

    November 12, 2014

    4.7/5

    Jon Hoene

    November 12, 2014

    5/5

    Cheryl D'Amico

    November 12, 2014

    4.9/5


    [What did you particularly like about the course?] The best practices

    Shaina Mancini

    November 12, 2014

    5/5


    It was very informative and expanded on my knowledge of APEX and Oracle.


    The class was very good.

    Weston Devers

    November 12, 2014

    4.7/5

    Mary Kay

    November 12, 2014

    5/5


    [What did you particularly like about the course?] instructor

    Mike VanDuyne

    November 12, 2014

    3.9/5

    Charles Fursdon

    November 12, 2014

    4/5

    Mick Lucas

    November 12, 2014

    4.8/5


    The course covered a wide variety of topics and features of APEX, in detail

    Zachary Hudock

    November 12, 2014

    5/5


    instructor is very personable and presents material very clearly

    John Martin

    November 12, 2014

    4.6/5


    [What did you particularly like about the course?] collections, tabular forms, subscriptions, plugins, dynamic actions

    Angel Rosario

    October 20, 2014

    4.1/5


    VERY GOOD

    Hector Nuñez

    October 20, 2014

    3.6/5

    Tim Taggett

    October 20, 2014

    3.8/5


    [What did you particularly like about the course?] The time of the courses fit to my schedules.

    Troy Natanieliem

    October 20, 2014

    5/5

    Aleksandra Knezevic

    May 5, 2014

    4.9/5

    Susy Iype

    February 24, 2014

    4.1/5


    [I liked] The content covered.

    Aimee Schimmel

    October 7, 2013

    4.3/5


    Showed some advanced portions of the product that I was not aware of. It helped tremendously to see someone else use APEX and discuss it since I work primarily alone with the tool.


    ... the format was great

    Jeff Wells

    October 7, 2013

    5/5

    Dave Anderson

    October 7, 2013

    4.2/5


    [i particularly liked ] The class size was small and we did manage to get to the jQUERY stuff


    [improvements] There was an awful lot of material to cover in a mere 20 hours...me thinks that limit is only realistic if there are no questions...and there were a LOT of questions.

    CJ Messick

    July 29, 2013

    4.7/5


    [suggestions for improving the online software or delivery techniques?] none pretty good

    Hansjoerg Graesslin

    July 29, 2013

    4.3/5


    Instructors Knowledge, Exposure and Experience in APEX. Lot of his Side Trips are really helped.


    The Should cover some workshops to show how to link Javascript and jquery functions. Not requried to be on how to write Javascript or jquery but how to link with APEX.


    No Issues with Online Software.

    Kamal Chellappa

    June 10, 2013

    4.5/5


    I really like being able to attend a class from my desk, but still interact with the instructor.


    Some of the material seemed to repeat info covered in the intro class. I would've preferred more time for things like the "Dynamic Actions Deep Dive" that Patrick provided on Friday.


    The delivery platform is fine, except for Friday -- there was a noticable delay on GoToMeeting, but I'm sure that's out of your control.

    Michael Blackwell

    June 10, 2013

    4.6/5


    I liked the information on collections as that's something I will need to be doing with my project that wasn't discussed in the intro course. I enjoy working with APEX (when I know what I'm doing) and the course material was able to show me s


    I'm not sure what could improve at this time... Patrick explained everything sufficiently and his demos were well planned. He was able to answer most any questions that came along.


    Patrick, again, has done a very good job at presenting the material for this course. He's very good with the student questions that are asked and seems to be pretty excited with the software overall which makes learning from him a pleasure.

    Michael Jondle

    June 10, 2013

    5/5


    The navigation and layout topics were extremely useful,
    and
    Patrick was a first-class presenter -- knowledgeable and effective.


    [improvements] Provide weights/times of topics before class, so we could make better suggestions to instructor with respect to needs and emphasis on the topics.

    Clyde Ulmer

    May 6, 2013

    5/5


    Perfect presentations of Patrick Cimolini.
    Instructor has very deep knowledge and understanding
    of the APEX, was sharing his experience.


    [improvements?] THtte course already has good structure

    Helen Kudrna-Murzin

    May 6, 2013

    3.3/5


    course content, other attendees presented a diverse background made for good questions.

    Chris Freeman

    March 25, 2013

    3.1/5


    The security talks as well as some of the more complex form creations.

    Shane Walker

    March 25, 2013

    4.9/5


    good selected topic, convenient schedule


    More attention to javascript and CSS usage


    Everything was perfect

    Vitaliy Vaysfeld

    March 25, 2013

    3.2/5

    Kadhambari sankaranarayanan

    March 25, 2013

    3.4/5


    The hands-on exercises really helped me come to grips with the concepts.

    Larry Rice

    January 7, 2013

    4.3/5


    Instructor was very patient and held our interest


    [suggestions for improving the online software or delivery techniques?] Clearer instructions on Workshops

    Cara Rodriguez

    January 7, 2013

    2.9/5


    Learn more about APEX


    The delivery of the training is great!

    Andreas Lindarto

    January 7, 2013

    4.8/5

    Gary Bartz

    December 3, 2012

    4.8/5

    Matthew Ardito

    December 3, 2012

    5/5

    Dave Lloyd

    December 3, 2012

    4.5/5

    Tin La

    December 3, 2012

    5/5

    Clarisa Maman Orfali

    July 30, 2012

    4.5/5


    The instructor was very knowledgable and kept the course interesting

    Benjamin Assa

    July 30, 2012

    5/5


    [I liked] Section on dynamic actions and plugins. Also learned a lot more about the session state.

    Marc Hoban

    July 30, 2012

    5/5


    Instructor was excellent -- really knew his stuff


    Not sure the book was necessary


    No, everything worked well

    Eric Sprague

    July 30, 2012

    5/5


    The new concepts I learned.


    Liked the [online] format of the delivery very much.

    John Lamonday

    June 11, 2012

    5/5

    Erick Diaz Jorge

    June 11, 2012

    5/5


    no, excellent transmit ions

    Marcelo Burgos

    June 11, 2012

    4.5/5


    I liked the course, but I would have liked to have examples or steps for what we did in the exercises in a document so I could go back and look things up.

    Anita Corradini

    March 19, 2012

    4.9/5


    I really like how well Dan knows APEX. I really learned a great deal about the session state and Advisor. I am sure there is a great deal more I could learn. I didn't even realize Advisor existed. I basically taught myself APEX about 5 years ago, h


    The only thing I would suggest is to maybe have an intermediate course for the users that have taken the intro, but have not worked in APEX for very long. I felt there were some users in the course that could not get around as easily as they should have


    I feel this was a very well taught course. Thanks very much!

    Tracy Simonson

    March 19, 2012

    4.1/5


    The wealth of extremely technical information

    Alondo McClees

    March 19, 2012

    4.6/5


    [particularly liked] Interactivity


    [improvements] Increase course hours and also teach the concepts in depth

    Jhuma Chakraborty

    March 19, 2012

    4.2/5


    The instructor was great - friendly and kept me interested. I liked the tabular form module and PL/SQL module.

    Alex Buchholz

    March 19, 2012

    4.8/5


    [particularly liked] Eerything


    [improvments] Longer

    Steve Stowers

    January 17, 2012

    5/5

    Sultan Al-Tellawi

    January 17, 2012

    5/5


    Lot of important details are involved in this course. Good to extend with one more class (another 5 hours).

    Vijaya Karra

    January 17, 2012

    5/5


    I liked the hands on exercises

    Stephanie Rodgers

    December 14, 2011

    5/5

    William Smith

    December 14, 2011

    5/5

    Robert Gordy

    October 17, 2011

    4.8/5

    Robert Gerstein

    October 17, 2011

    5/5

    Robert (Marty) Friedline

    October 17, 2011

    4.5/5


    [What did you particularly like about the course?] Instructor

    mark pope

    September 12, 2011

    5/5

    Catherine Reese

    September 12, 2011

    5/5

    Lorre Johnson

    September 12, 2011

    3/5

    Michael Dennis

    September 12, 2011

    5/5

    Melissa Wright

    September 12, 2011

    5/5


    [What did you particularly like about the course?] the ability to share each others desktops to look at issues or questions.

    anthony reeves

    August 1, 2011

    5/5


    Covered topics I know I will need.


    I thought it worked quite well.

    Cathy Farrell

    August 1, 2011

    5/5


    Both the lecture and the hands-on workshops....


    I see not need for any improvements. Dan did a great job and knows the stuff in/out.

    stacy poulos

    August 1, 2011

    4.7/5

    Trinity Barbuto

    May 16, 2011

    4.4/5

    Thomas Rodriguez

    May 16, 2011

    5/5


    all good on this one, right pace and right content...Dan has really good diction and a great understanding of product.

    David Saint

    May 16, 2011

    4.5/5


    The hands on was great.


    When Dan is doing demo's he needs to slow down - he is clicking so quickly it is easy to get behind and then lost.

    Dennis Lordemann

    March 21, 2011

    5/5


    Instructor voice and tone. I'm not american so sometimes i don't understand some people with rough voice .


    Suggestion: Have classes in another languages. I have a lotta friends interesting but they don't speak english


    Nothing. Sound and image was perfect [online class]

    douglas.viana.lima@gmail.com

    March 21, 2011

    4.2/5

    Monicca Warjanto

    January 31, 2011

    4.9/5

    Shelly Hinegardner

    January 31, 2011

    4.5/5


    THe instructor was very knowledgeable and nice. We got through a good amount of material in a short amount of time. I particularly liked a couple of the late chapters, as they really applied to what I am working on.

    Eli Feuerstein

    September 27, 2010

    1.6/5


    I particularly liked that I could sit at home in shorts and a t-shirt while attending.

    Jeff White

    September 27, 2010

    3.9/5


    [What did you particularly like about the course?] On-Line, half day structure.

    Rob Duke

    September 27, 2010

    4.7/5


    [What did you particularly like about the course?] The knoweldge about apex and very good content.

    Rodolfo Rodriguez

    May 17, 2010

    4.8/5


    Instructor took time to answer our questions and showed examples

    Noli Bernal

    May 17, 2010

    4.5/5


    Information was valuable

    Beth Harrison

    May 17, 2010

    4.9/5


    Dan was very helpful answering questions, giving us information that we asked him to talk about. He was knows his stuff. He was very helpful in the workshops and made sure that we all got the desired result.


    Everything worked great. It was very helpful that he could look at our screens and help us when we had a problem during the workshops.

    Ann Bost

    May 17, 2010

    5/5


    [What did you particularly like about the course?] The instructer

    Stuart Schmied

    January 25, 2010

    $2,400.00

    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!

     

    ×