• Online, Self-Paced
Course Description

The Oracle Commerce Platform consists of a data and presentation layer. Understanding the data relationships, and how that data is accessed is a fundamental skill for any developer. In this course, you will be able to describe the data relationships in the Oracle Commerce Platform, create data sources, describe form handling mechanisms, and write robust JSP. This course is one of a series in the Skillsoft learning path that covers the material for the Oracle Commerce Platform Fundamentals for Developers.

Learning Objectives

Data Element Relationships

  • start the course
  • choose the collection type when working with ordered/unordered data
  • name the Java collection types that bind keys to values
  • identify when two items have a many-to-many relationship
  • describe how auxiliary and multi tables are joined with the primary table
  • list the steps in setting up a test data source
  • describe how to make your repository accessible in the ACC


SQL Repository Data Models

  • identify how item types can be created as subtypes of other item types
  • list the attributes of item descriptors for a subtype item
  • identify how a composite ID is a unique ID represented by more than one column in the database composite ID is a unique ID represented by more than one column in the database
  • list the ways how grouping properties can improve performance
  • describe how to configure cascading relationships


Repository Form Handlers

  • describe the mechanism Oracle Commerce uses for handling forms
  • specify how Oracle Commerce normally accesses properties of beans
  • configure fields of a form page by associating them with the properties of the form handler
  • specify how to provide methods to select from an enumerated list of possible options
  • list the methods that can be called on submission to process the data in a form


JSP Design

  • write a JSP page using form page redirection to set the action page back to the form page
  • list the properties RepositoryFormHandler uses to help manage form errors
  • describe how form submission and handling occurs, and how request-scoped form handlers work
  • describe how form handlers know which item in the repository to update


Practice: Request Repository Form Handler

  • build a JSP form using collections, tag, and error handling


Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration