Preparing for Oracle APEX (APEX000)
Build the web, database, SQL, and low-code foundations you need to begin learning Oracle APEX, including HTML, CSS, JavaScript, and core PL/SQL basics.
Register or Request Training
- Private class for your team
- Live expert instructor
- Online or on‑location
- Customizable agenda
- Proposal responses same day as request
Course Overview
This introductory course prepares learners for Oracle APEX by building essential knowledge of web development, relational databases, and low-code application development. Participants explore APEX architecture and compare its capabilities and workflow with Microsoft Access.
The course introduces HTML, CSS, JavaScript, client-side and server-side programming, SQL, and PL/SQL. Learners also work with database tables, constraints, relationships, sample data, and basic queries, gaining the foundation needed to begin learning Oracle APEX with confidence.
Course Benefits
- Explain the architecture and key capabilities of Oracle APEX.
- Compare low-code development in Oracle APEX with application development in Microsoft Access.
- Describe how client-side and server-side technologies work together in web applications.
- Use foundational HTML elements to structure pages, tables, forms, lists, links, and images.
- Apply CSS selectors and properties to style text, colors, positioning, and page layouts.
- Use basic JavaScript, DOM manipulation, event handling, Ajax, and jQuery concepts to add interactivity.
- Explain relational database concepts, including tables, rows, columns, constraints, and relationships.
- Work with basic SQL statements and distinguish SQL from PL/SQL.
- Build the technical foundation needed to continue learning Oracle APEX.
Delivery Methods
Live expert-led online training from anywhere. Guaranteed to run .
Delivered for your team at your site or online.
Course Outline
- Getting Ready for Oracle APEX
- Oracle APEX architecture
- Advantages and disadvantages of low-code solutions
- Oracle APEX and Microsoft Access application capabilities
- Application creation workflows in Oracle APEX and Microsoft Access
- Knowledge required for end-to-end application development
- Web Development Overview
- How HTML works with other web technologies
- Client-side programming
- Server-side programming
- Introduction to HTML
- Structuring web pages with HTML
- Headings, paragraphs, and links
- Creating lists
- Exercise: Working with lists
- Creating tables
- Exercise: Working with a table
- Creating forms
- Exercise: Working with a form
- Adding images
- Introduction to CSS
- Styling web pages with CSS
- CSS selectors, properties, and values
- Exercise: Working with CSS selectors and properties
- Styling text, colors, and layouts
- Exercise: Working with CSS positioning
- Using CSS in Oracle APEX
- Introduction to JavaScript
- Adding interactivity with JavaScript
- JavaScript syntax and basic programming concepts
- Exercise: Computing the average of integers
- DOM manipulation and event handling
- Exercise: Working with DOM manipulation and event handling
- Changing page styles with JavaScript
- Exercise: Creating custom background-color buttons
- Ajax
- Introduction to jQuery
- SQL and Relational Databases
- Relational database concepts
- Tables, rows, and columns
- Tables, constraints, and relationships
- Exercise: Creating the Employees Extended table
- Populating tables with sample data
- Basic SQL statements: SELECT, INSERT, UPDATE, and DELETE
- Exercise: Modifying data in the Employees Extended table
- SQL and PL/SQL
- Exercise: Displaying employee and department names
- Package basics
Class Materials
Each student receives a comprehensive set of materials, including course notes and all class examples.
Follow-on Courses
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.