Data Private

Preparing for Oracle APEX (APEX000)

2 days
Oracle Application Express (APEX)

The Preparing for Oracle APEX course is specifically designed for individuals new to web development and database design who are looking to start their journey with Oracle APEX.

Talk to a Learning ConsultantRequest a Private Class

Register or Request Training

  • Private class for your team
  • Live expert instructor
  • Online or on‑location
  • Customizable agenda
  • Proposal responses same day as request
Request Proposal

Course Overview

The Preparing for Oracle APEX course is specifically designed for individuals new to web development and database design who are looking to start their journey with Oracle APEX. The course begins with an introduction to Oracle APEX, highlighting its architecture, the benefits of low-code development, and comparison with Microsoft Access. It goes on to provide an overview of the essential concepts and technologies used in web development, such as HTML, CSS, and JavaScript, as well as a foundational understanding of SQL and relational databases. Participants will explore both client-side and server-side programming to gain a broader understanding of how web applications function. The course ends with a lesson covering the basics of creating a database schema in Oracle and a quick introduction to SQL and PL/SQL to familiarize students with key database concepts. This course serves as a preparatory step, equipping students with the background knowledge needed to confidently begin learning Oracle APEX.

Course Benefits

  • Gain a high-level introduction to web development technologies, including HTML, CSS, and JavaScript, without needing prior experience.
  • Review the basics of SQL and relational databases, focusing on the concepts essential for Oracle APEX development.
  • Learn how to set up a simple Oracle database schema using the HR Schema, providing a practical introduction to database design.
  • Understand the fundamental differences between low-code solutions like Oracle APEX and traditional development tools such as Microsoft Access.
  • Explore the architecture and key features of Oracle APEX, preparing you for more advanced learning.
  • Review the client-side and server-side programming landscapes to better understand how web applications are structured.
  • Develop a basic familiarity with key web technologies that will support your future learning in Oracle APEX.
  • Build the foundational knowledge needed to begin learning APEX confidently, without diving into complex programming or database management.

Delivery Methods

Private Class
Delivered for your team at your site or online.

Course Outline

  1. Getting Ready for APEX
    1. Introduction to APEX Architecture
    2. Advantages and Disadvantages of Low-Code Solutions
    3. Comparing APEX and Microsoft Access: Application Capabilities
    4. Creating Applications: APEX vs. Microsoft Access Workflow
    5. Required Knowledge for End-to-End Application Development
  2. A Quick Overview of Web Development
    1. HTML is Part of a Team
    2. Client-side Programming
    3. Server-side Programming
  3. Introduction to HTML
    1. Overview of HTML: Structuring Web Pages
    2. Basic HTML Elements: Headers, Paragraphs, and Links
    3. Creating Lists
    4. Working with Lists (Exercise)
    5. Creating Tables
    6. Working with a Table (Exercise)
    7. Creating Forms
    8. Working with a Form (Exercise)
    9. Images
  4. Introduction to CSS
    1. Introduction to CSS: Styling Web Pages
    2. CSS Selectors, Properties, and Values
    3. Working with CSS Selectors and Properties (Exercise)
    4. Styling Text, Colors, and Layouts
    5. Working with CSS Positioning (Exercise)
    6. Using CSS in Oracle APEX
  5. Introduction to JavaScript
    1. Basic JavaScript: Making Web Pages Interactive
    2. JavaScript Syntax and Basic Programming Concepts
    3. Computing the Average of Integers (Exercise)
    4. DOM Manipulation and Event Handling
    5. Working with DOM Manipulation and Event Handling (Exercise)
    6. Using JavaScript to Change Page Styles
    7. Creating Custom Background Color Buttons (Exercise)
    8. Ajax
    9. Introduction to jQuery
  6. SQL and Relational Databases
    1. Introduction to Relational Database Concepts
    2. Understanding Tables, Rows, and Columns
    3. Creating Tables, Constraints, and Relationships
    4. Creating the Employees Extended Table (Exercise)
    5. Populating Tables with Sample Data
    6. Basic SQL Queries: SELECT, INSERT, UPDATE, DELETE
    7. Modifying Data in the Employees Extended Table (Exercise)
    8. PL/SQL vs. SQL
    9. Displaying Employee Name and Department Name (Exercise)
    10. Package Basics

Class Materials

Each student receives a comprehensive set of materials, including course notes and all class examples.

Have questions about this course?

We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.

Talk to a Learning Consultant