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
Course Learning Outcomes
By the end of this course, you will be able to:
- Gain a comprehensive understanding of the APEX Builder and its capabilities.
- How to execute SQL and PL/SQL statements using Query Builder and SQL Commands.
- How to create and modify regions, buttons, and items within applications.
- You will be able to validate form input, control page flow, understand the APEX URL structure, and debug applications while managing session state.
- Create basic reports and forms to meet application requirements.
- Successfully deploy applications to new environments.
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
Course Learning Outcomes
By the end of this course, you will be able to:
- Gain a comprehensive understanding of the APEX Builder and its capabilities.
- How to execute SQL and PL/SQL statements using Query Builder and SQL Commands.
- How to create and modify regions, buttons, and items within applications.
- You will be able to validate form input, control page flow, understand the APEX URL structure, and debug applications while managing session state.
- Create basic reports and forms to meet application requirements.
- Successfully deploy applications to new environments.
