• Onboard For Tech Teams

    • Reduce initial time to productivity.
    • Increase employee tenure.
    • Plug-and-play into HR onboarding and career pathing programs.
    • Customize for ad-hoc and cohort-based hiring approaches.

    Learn more
  • Upskill For Tech Teams

    • Upgrade and round out developer skills.
    • Tailor to tech stack and specific project.
    • Help teams, business units, centers of excellence and corporate tech universities.

    Learn more
  • Reskill For Tech Teams

    • Offer bootcamps to give employees a running start.
    • Create immersive and cadenced learning journeys with guaranteed results.
    • Supplement limited in-house L&D resources with all-inclusive programs to meet specific business goals.

    Learn more
  • Design For Tech Teams

    • Uplevel your existing tech learning framework.
    • Extend HR efforts to provide growth opportunities within the organization.
    • Prepare your team for an upcoming tech transformation.

    Learn more

Introduction To Application Express

Get your team started on a custom learning journey today!

Our Boulder, CO-based learning experts are ready to help!

Get A Quote!

Course Summary

Home > Courses >Back-End Development Training >Introduction To Application Express

The Introduction To Application Express training course is designed to demonstrate an introduction to Oracle Application Express (APEX) 5.0.

The course begins with an introduction into how to build a fully-functioning application from the ground-up.

Purpose
Learn how to build an application using Oracle APEX 5.0, Oracle’s premier Rapid Application Development tool.
Audience
Software developers, database users, business analysts, application developers, database administrators, and IT managers.
Role
Business Analyst - Software Developer - Technical Manager
Skill Level
Intermediate
Style
Hack-a-thon - Learning Spikes - Workshops
Duration
5 Days
Related Technologies
Download
imgprinter
  • Productivity Objectives:
    • Demonstrate how to create highly complex web-based applications
    • Create interactive reports that allow for full customization
    • Experiment with searching and sorting
    • Create control break reports
    • Perform highlighting to focus on specific rows or values
    • Add custom computations (including aggregations)
    • Apply charting and custom dashboards
Learn About Virtual Training

Request Information

Get your team upskilled or reskilled today. Chat with one of our experts to create a custom training proposal. Fully customized at no additional cost.

100secure

If you are not completely satisfied with your training class, we'll give you your money back.

secure100 secure100 secure100 secure100

about our training

  • keywordicon1
    Real-World Content

    Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.

  • keywordicon2
    Expert Practitioners

    Industry experts with 15+ years of industry experience that bring their battle scars into the classroom.

  • keywordicon3
    Experiential Learning

    More coding than lecture, coupled with architectural and design discussions.

  • keywordicon4
    Fully Customized

    One-size-fits-all doesn't apply to training teams. That's where we come in!

What You'll Learn

In the Introduction To Application Express training course, you'll learn:

  • Introduction To APEX
    • Overview Of The Class
    • History Of APEX
    • APEX Instance Options
    • Tools
      • Web Browser Selection
      • SQL
      • Plus
      • SQL Developer
  • APEX Installation
    • Removing The Old Version
    • Installing The New Version
    • APEX ADMIN Setup
    • Configuring RESTful Services
    • Configuring The Embedded PL/SQL Gateway
    • Creating A Workspace
  • The APEX Workspace
    • Roles For APEX Users
    • Anatomy Of An Application
    • Overview Of APEX Modules
      • Application Builder
      • SQL Workshop Interface
      • SQL Commands Interface
      • SQL Scripts Interface
      • Utilities Interface
    • Team Development / Administration
  • Our Real World Problem
    • Needed Database Objects
    • Designing For APEX
    • APEX And PLSQL
    • The “Parse As” Schema
  • Initial Object Design
    • Needed Database Objects
      • Tables
      • Views
      • Triggers
      • Sequences
      • Comments
    • Generating Application Documentation
  • Object Design II
    • Loading Data
    • Creating Lookup Tables
    • Loading And Running Scripts
    • User Interface Defaults
  • Creating & Navigating Apps
    • Using The Create Application Wizard
    • Understanding Websheets
    • Creating Applications From Spreadsheets
    • Creating Applications From Scratch
      • Regions
      • Public Pages / Global Pages
      • Navigation Bar Entries
      • Breadcrumbs / Lists / LOVs
  • Basic Forms And Reports
    • Forms On Tables
    • Forms On Procedures
    • Master-Detail Forms And Reports
    • Creating Searchable Reports
    • Using Declarative BLOBs
  • Advanced Forms And Reports
    • Creating Tabular Forms
    • Interactive Reports
    • User Help For Interactive Reports
    • Subscribing To Reports
    • Creating Calendars
    • Creating Charts
  • Programmatic Components
    • Using Conditions
    • Using Required Values
    • Using Validations
    • Creating Computations
    • Creating Processes
    • Using PL/SQL Regions
    • Using Dynamic SQL
  • Dynamic Actions
    • Understanding Dynamic Actions
    • Implementing Dynamic Actions
    • Using Multiple Triggering Elements
    • Using PL/SQL
    • Using JavaScript
  • APEX Security
    • Integrating User Security
    • Creating Needed Database Objects
    • Security Model Implementation
    • Authentication
    • Conditional Security
    • Controlling Data Access
    • Protecting Session State
  • Websheets
    • The Structure Of A Websheet
    • Navigating Websheets
    • Websheet Help
    • Markup Syntax
    • Authenticating & Authorizing Users
    • Sections In Websheets
    • Using Annotations
  • Creating A Websheet Application
    • Creating The Database Objects
    • Websheet Creation And Configuration
    • Creating Websheet Content
  • Bundling And Deployment
    • Application Component Identification
    • Including Supporting Objects
    • Importing An Application
  • Additional Developer Tools
    • Understanding Page Locks
    • Application Groups / Page Groups
    • The APEX Data Dictionary
    • Monitoring APEX Applications
    • The APEX Advisor
    • APEX Build Options
    • Using Page-Specific Utilities
  • Workspace Management
    • The APEX Administration Interface
    • Service Management
    • Metadata Management
    • User / Group Management
    • Monitoring Activity And Dashboards
  • APEX Team Development
    • The Team Development Interface
    • Features
    • Milestones
    • To-Do Items
    • Bugs
    • Feedback
    • Team Actions
    • Available User Roles
Real-world content

Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.

Expert Practitioners

Industry experts that bring their battle scars into the classroom.

Experiential Learning

More coding than lecture, coupled with architectural and design discussions.

Fully Customized

One-size-fits-all doesn't apply to training teams. That's where we come in!

Elite Instructor Program

We recently launched our internal Elite Instructor Program. The community driven instructor program is designed to support instructors in transforming students’ lives by consistently showing a world-class level of engagement, ability, and teaching prowess. Reach out today to learn more about our instructors.

Customized Technical Learning Solutions to Help Attract and Retain Talented Developers

Get In Touch
Talk to one of our Learning Solution Architects today

Let DI help you design solutions to onboard, upskill or reskill your software development organization. Fully customized. 100% guaranteed.

DevelopIntelligence leads technical and software development learning programs for Fortune 500 companies. We provide learning solutions for hundreds of thousands of engineers for over 250 global brands.

99statisfaction1 Educate learners using experienced practitioners.
pularsight Proven customization process is guaranteed.
budgetnewlogo We're a strategic partner, not just another vendor.

“I appreciated the instructor’s technique of writing live code examples rather than using fixed slide decks to present the material.”

VMware
vmware View more