Home Page

Overview


Topics Covered in APEX Beginner Course

Introduction to APEX

This section provides an overview of APEX and its components, suitable for individuals who are new to APEX or want to strengthen their foundational knowledge. Topics include understanding APEX architecture, making installation decisions, managing workspaces and applications efficiently, and navigating the Application Express user interface effectively.

SQL Workshop

SQL Workshop is a tool in APEX for managing database objects and executing SQL and PL/SQL statements. Learners will explore how to use The Object Browser, Query Builder, and SQL Commands for database management, as well as creating scripts to execute multiple related commands.

Utilities

This section covers various utilities in APEX for tasks such as data import/export, instance health monitoring, and streamlining deployment scripts. Topics include importing and exporting data in various formats, using Database Monitor, and generating schema object DDL.

Application Builder

Application Builder is used for building applications in APEX. Learners will learn how to create applications from scratch or based on a spreadsheet, review and edit application objects, and navigate the builder efficiently. Additional topics include reporting and charting SQL statements, page rendering and processing overview, and creating forms and associated reports.

Creating Pages

This section focuses on creating and modifying pages in APEX, assigning pages to groups, and understanding different page types such as reports, forms, and calendars. Learners will also explore page processing techniques for performing actions and controlling page flow.

Regions and Items

Regions and items are essential components of APEX applications. Learners will learn how to create and modify regions, buttons, and items, and understand different item types. Topics also include customizing queries, conditionally displaying components, and providing search filters.

Page Processing

Page processing involves validating form input, controlling page flow, and understanding APEX URL structure. Learners will gain insights into computations, branches, debugging applications, and managing session state.

Shared Components

Shared components enhance user experience and streamline development in APEX. This section covers creating lists, breadcrumbs, and items for tracking global values. Additional topics include organizing user navigation, avoiding hard coding values, and discussing the possibility of web services.

Other Page and Region Types

Learners will explore advanced page and region types such as interactive reports, charts, and calendars. The usefulness of the APEX Global Page (Page Zero) for displaying the same content on multiple pages will also be discussed.

Utilities and Reporting

This section covers utilities for translation, exporting, and importing data in APEX.

Advanced Development Techniques

Advanced development techniques focus on authentication, authorization, and security in APEX applications. Topics include identifying users, defining user roles, and preventing security threats such as Cross Site Scripting and SQL Injection.

Administration and Deploying An Application

Learners will learn how to prepare applications for deployment, manage users, logs, and preferences, provision workspaces, and define application models.

Instructor


3+ Years of experience in Oracle APEX Development

Course Learning Outcomes


By completing the APEX Beginner Course, learners will achieve the following outcomes:

  • Understanding APEX Architecture and Installation
  • Manage database objects with tools like The Object Browser and Query Builder.
  • Execute SQL and PL/SQL statements.
  • Generate schema object DDL scripts.
  • Create applications from scratch or spreadsheets.
  • Edit and manage application objects.
  • Generate reports and charts, and understand page rendering and processing.
  • Create and modify reports, forms, and calendars.
  • Manage page groups and control page processing.
  • Create and customize regions, buttons, and items.
  • Implement various item types and apply conditional logic.
  • Validate form inputs and manage session state.
  • Control page flow and understand APEX URL structure.
  • Utilize computations, branches, and debugging tools.
  • Effective Use of Shared Components
  • Create and manage lists, breadcrumbs, and global items.
  • Enhance user navigation and avoid hard coding values.
  • Use the APEX Global Page (Page Zero) for consistent content.
  • Proficiency in APEX Utilities and Reporting:
  • Utilize tools for translation and data import/export.
  • Develop advanced reporting capabilities.
  • Implementation of Advanced Development Techniques.
  • Implement robust authentication and authorization.
  • Define user roles and enhance security.
  • Prevent Cross Site Scripting and SQL Injection.
  • Administration and Deployment Skill.
  • Prepare applications for deployment.
  • Manage users, logs, and preferences.
  • Provision workspaces and define application models.

PayPal Integration Example
1000$ $500 for Beginner Level