Preparing for Oracle APEX

Preparing for Oracle APEX (APEX000)

Course Length: 2 days
Delivery Methods: Available as private class only
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.
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, Tables, and Forms
    4. Embedding Images and Media
  4. Introduction to CSS
    1. Introduction to CSS: Styling Web Pages
    2. CSS Selectors, Properties, and Values
    3. Styling Text, Colors, and Layouts
  5. Introduction to JavaScript
    1. Basic JavaScript: Making Web Pages Interactive
    2. JavaScript Syntax and Basic Programming Concepts
    3. DOM Manipulation and Event Handling
    4. Ajax
    5. 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. Populating Tables with Sample Data
    5. Basic SQL Queries: SELECT, INSERT, UPDATE, DELETE
    6. PL/SQL vs. SQL
Class Materials

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

Follow-on Courses
Live Private Class
  • Private Class for your Team
  • Live training
  • Online or On-location
  • Customizable
  • Expert Instructors
Request Proposal