Oracle APEX Training Courses
Application Express (Oracle APEX) is a rapid web application development tool for the Oracle database. The Oracle Application Express (APEX) training class available from Firebox Training is unique, as the author of the courseware is on staff. Oracle Apex is very cutting-edge technology from Oracle. This course offers those developers a chance to get a jump-start and a hands-on Oracle APEX programming experience.
Oracle Apex is a very flexible development tool. In thie Oracle Apex training classes students learn the generally accepted best practices for developing Apex applications, include coding standards, quality assurance infrastructure, migration control and standardization of apex development environments.
Introduction to Oracle Application Express
Oracle Apex 4.2 – ORA901 – 5 Days
Introduction to Oracle Application Express Apex 4.2 – ORA901 – 5-Day Request a Class Date
Students learn how to create reports, forms, charts, and calendars using Oracle APEX 4.2. Students will learn how to create well formed APEX pages with navigation, CSS and Web Services.
Course ID: &ORA901 Duration: 5 days
Audience: Web developers,PL/SQL developers
What You Will Learn in Oracle Application Express:
Introduction to Oracle Apex
- Introduction to Oracle Apex
- The Oracle Apex homepage
- The Apex engine and lifecycle
- Apex versions
- Software requirements
- User roles
- Workspaces, schemas, users, and groups
Getting started with Apex
- The application homepage
- Sample application
- Developer navigation bar
- Page editor
- Page rendering
- Page processing
- Shared components
- Page editor views
SQL Workshop
- Using the Object Browser
- Issuing ad hoc statements
- Maintaining the SQL scripts repository
Creating reports
- Creating reports
- Basic reports
- Running your first report
- Report analysis pages
- Interactive reports
- Enhanced interactive reports
- Report and column attributes
- Layout and pagination
- The APEX_ITEM package
Creating forms
- Introduction to forms
- Master-detail forms
- Generating a primary key
- Form page options
- Running a master-detail form
- Procedure-based forms
Calendars and charts
- Creating calendars
- Calendar attributes
- Date intervals
- Column and day links
- HTML, SVG, and Flash charts
- Asynchronous updates
Managing session state
- What is a session?
- Understanding page URLs
- The Session State page
- Setting and getting session data
- Clearing session data
- Bookmarking pages
Navigation
- Overview of navigation
- Navigation bars
- Bread crumbs
- Tabsets
- Lists
- Trees
Validations and computations
- Validations and computations
- Item-level validations
- Regular expressions
- Page-level validation
- Creating components
JavaScript and CSS
- What is JavaScript?
- Adding JavaScript to an application
- Referencing HTML items with JavaScript
- Dynamic drop down menus
- JavaScript events
- Dynamic Actions
- Introduction to CSS
Page Layout
- Templates
- Page templates
- Substitution strings
- Regions and region templates
- Subregions
- Master pages
- HTML regions
Web sheets
- Application Controls
- Search
- Section Content
- Page controls
- View and access related pages
- Annotations
- Data Visualization
- Data Grids
- Data grid inline editing
- History
- Administration
Uploading and downloading documents
- Uploading and downloading documents
- Creating report of uploaded documents
- Storing document attributes
- Storing documents in a customized table
- Downloading documents from a customized table
Web services
- What is a web service?
- SOAP (Simple Object Access Protocol)
- WSDL (Web Services Description Language)
- UDDI (Universal Description Discovery and Integration)
- Support for RESTful web services
- Creating web service references
- Deplaying web service results
Emailing with Apex
- Configuring email settings
- Enabling network services with Oracle 11g
- The APEX_MAIL package
- Sending email from APEX
- Adding email attachments
- Viewing the email queue and logs
- Pushing the email queue
Creating PDFs
- PDF printing with Apex
- Installing BI Publisher on Windows
- Configuring APEX to work with BI Publisher
- Creating a simple PDF report
- Creating standard master-detail PDF reports
- Using BI Publisher Desktop
Plugins
- Item Type Plug-Ins
- Region Type Plug-Ins
- Process Type Plug-Ins
- Dynamic Action Type Plug-Ins
- Community Plug-In Repositories
Administering workspaces
- Creating a workspace
- Managing developers and users
- Exporting and importing workspaces
- Granting a new workspace
- Locking a workspace
- Managing storage and schema reports
- Workspace reports
Security
- Authentication
- Configuring LDAP authentication
- Authorization
- Access Control page
- Session state protection
Using Utilities
- Unloading data from a table
- Loading spreadsheet data into a table
- Generating application DDL
- Viewing object reports
- The recycle bin
- Other utilities
Globalization
- Language preferences
- Translating applications
- Language Identification
- Translating messages
- Translating internal messages
Deploying applications
- Deploying an application
- Deployment options
- Packaged applications
- Exporting application metadata
- Supporting objects
- Exporting supporting objects
- Importing an application
Appendix A – The APEX listener
Appendix B – Installation