• Online, Self-Paced
Course Description

The Oracle Commerce Platform contains a robust repository API. Understanding how to use Java to programmatically manipulate (retrieve, create, update, delete, or query) repository data is a must for any serious application. In this course, you will be able to implement transient (non-persisted) properties, apply rules to override a property's value derivation, and configure versioned repositories and consider their use in support of Commerce Platform functionality. 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

Repository API

  • start the course
  • describe how the Oracle Commerce Repository API is a set of interfaces that are used for generic data access
  • identify the classes used to view and manipulate repository elements
  • identify the steps in creating, updating, and deleting repository items
  • use Repository Query Language (RQL) to execute queries in a repository

Derived Properties

  • describe how a derived property is a transient property that derives its value from another property
  • recognize how properties are derived and how they are defined in configuration files
  • recognize how properties are derived from organizations and how they are defined in configuration files
  • define the steps in setting the value of a derived property
  • list the six different derivation methods used in Oracle Commerce and describe their functionality

Versioned and Hierarchical Repositories

  • describe how to use content administration for internally managed content such as products, images, and promotions
  • identify the steps in creating a module used to override the application elements that differ on the CA server
  • list the differences between versioned and unversioned repositories
  • list the steps for configuring versioned repositories
  • list the steps for creating versioned tables
  • list the different utilities used to import and export data
  • describe how hierarchical repositories are used and how they model the original file system

SQL Repository Caching

  • describe how each Oracle Commerce server in a cluster maintains its own caches
  • define the two phases performed in repository queries
  • list the six cache modes for repository items
  • identify the differences between preloading caches, cache types, and cache invalidation

Practice: Adding Versioning

  • review the Trunk Show Repository and supporting SQL table definitions and consider what steps would be required to add versioning

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.