Enterprise Database Systems
Oracle Commerce: Platform Fundamentals
Advanced Configuration Options
Building Simple Applications
Core Commerce and the Product Catalog
Data Models and JSP
Extending Oracle Commerce Applications
Form Handling with Pipelines and REST
Oracle Commerce Application Structure and Deployment
Using the Repository

Advanced Configuration Options

Course Number:
df_ocpf_a07_it_enus
Lesson Objectives

Advanced Configuration Options

  • start the course
  • create custom property types that allow the programmatic manipulation of repository item properties
  • distinguish between the methods for overriding and extending functions
  • work with custom attributes to extend the functionality of an application
  • describe how the Oracle Commerce User Directory groups users by organization and role
  • view the user principals in the ACC
  • view the organization principals in the ACC
  • view the role principals in the ACC
  • distinguish the differences between user segments and the user directory
  • describe how the user directory can be used to control site access with page level security
  • describe how the user directory uses secured repositories to implement object-level security
  • describe the concept of database transactions and database concurrency and consistency
  • identify the ways Oracle Commerce supports JTA
  • define the start and end points (the boundaries) of a transaction
  • create an Oracle Commerce application module that contains a simple Java EE application
  • override the properties of a global component with application-specific values set from the Sandbox module's local configuration layer
  • create and configure a component based on an out-of-the-box component class
  • register the Sandbox configuration layer and namespace with the ACC
  • create and deploy a globally scoped component based on a custom class
  • declare the DSP tag library for use in a JSP
  • use standard Dynamo Servlet beans to display dynamic and conditional content on a page
  • write a custom Dynamo Servlet bean class, and use that bean in a JSP to display conditional content

Overview/Description
Oracle Commerce applications are robust and highly configurable. Advanced concepts such as custom properties, transaction management, and Oracle Commerce Principals can be applied to build rich and scalable web applications. In this course, you will learn how to add additional logic to manipulate properties, create and use new principals in the Oracle Commerce User Directory, learn transaction management, and apply your Oracle Commerce knowledge to build working applications. This course is one of a series in the Skillsoft learning path that covers the material for the Oracle Commerce Platform Fundamentals for Developers.

Target Audience
Application developers; data architects; technical architects; and anyone with experience in Java programming, XML parsing and editing, basic JavaServer page and HTML page coding, and a basic understanding of SQL database table structure and data querying.

Building Simple Applications

Course Number:
df_ocpf_a02_it_enus
Lesson Objectives

Building Simple Applications

  • start the course
  • describe how Dynamo Servlet Beans (droplets) are used to generate page content
  • write a simple Dynamo Servlet Bean (droplet)
  • write a ForEach droplet to iterate over an unknown number of items in an array
  • identify the four most frequently used Dynamo Servlet Beans
  • describe how servlets generate dynamic content (HTML) that is returned to a JSP in response to a request
  • describe how to create a custom servlet bean
  • write a JSP page to accept strings, arrays, and objects
  • recognize how a servlet bean is used to render the content specified by the page in the output open parameter
  • describe how web applications often have many sources and forms of data
  • describe how content repositories provide storage for content items and the ability to associate metadata with content
  • demonstrate repository features in the ACC
  • describe how servlet beans are used to display repository contents
  • list the ways queries can match patterns in text, query through collections, query through complex values, and specify presentation order
  • describe how a property allows a drilldown into single and multivalue subproperties
  • demonstrate how to combine an RQL servlet bean to an ItemLookup servlet bean
  • describe the advantages of using the Data Anywhere Architecture to access SQL databases
  • list the properties of a repository component and know their location and functionality
  • describe how item descriptors describe the structure of a repository item
  • describe how enumerated properties are used and how the value is actually stored in the database
  • identify how an item-type property can refer to an item type defined in a separate repository
  • build two objects and define the relationship between them

Overview/Description
The Oracle Commerce Platform contains robust tools used to create rich web applications. Understanding its custom libraries and JSP usage is essential for any developer. In this course, you will be able to describe the custom beans of the Oracle Commerce Platform, create server-side Java application modules, describe the repository structure, and configure the repository. This course is one of a series in the Skillsoft learning path that covers the material for the Oracle Commerce Platform Fundamentals for Developers.

Target Audience
Application developers; data architects; technical architects; and anyone with experience in Java programming, XML parsing and editing, basic JavaServer page and HTML page coding, and a basic understanding of SQL database table structure and data querying

Core Commerce and the Product Catalog

Course Number:
df_ocpf_a05_it_enus
Lesson Objectives

Core Commerce and the Product Catalog

  • start the course
  • describe how Core Commerce is built on the core platform
  • recognize how the flexible catalog hierarchy helps customize the catalog
  • identify the properties of the Commerce Reference Store (CRS) and how it provides code, configuration, and data for simulating a complete working commerce application
  • list the item types of the product catalog repository
  • define how category item types use navigational links for browsing
  • recognize that SKUs are purchasable items and are associated with a particular fulfiller
  • describe how media is a base item type in the catalog repository, which contains a reference to an image file
  • choose the different ways to display the Oracle Commerce product catalog
  • define the Core Commerce (DCS) and Commerce Reference Store (CRS) module structure
  • list the multiple ways to extend the catalog
  • describe how subtypes are used when custom properties apply only to some instances of that item type
  • list the steps for extending catalog item types
  • use profile components for a user-centered application design
  • describe an overview of the profile repository
  • identify the stages in the life cycle of the Profile object
  • identify how the profile repository uses Oracle Commerce's XML file combination to construct the definition file
  • list the ways the profile repository can be modified
  • describe how to add a business object to the profile
  • describe how the Admin UI provides an option to view the combined XML file
  • name the profile submission handler methods
  • migrate the Trunk Show Repository to the MyStore module

Overview/Description
Oracle Commerce comes with commerce-specific repositories as well as Core Platform repositories extended for commerce. Knowing the structure of commerce catalogs and catalog-related objects is essential to design and build Oracle Commerce applications. In this course, you will learn how product catalogs are conceptually implemented in repositories, the ways in which catalog repository data is displayed on a page, and apply SQL repository configuration skills to Commerce product catalog customizations. This course is one of a series in the Skillsoft learning path that covers the material for the Oracle Commerce Platform Fundamentals for Developers.

Target Audience
Application developers; data architects; technical architects; and anyone with experience in Java programming, XML parsing and editing, basic JavaServer page and HTML page coding, and a basic understanding of SQL database table structure and data querying.

Data Models and JSP

Course Number:
df_ocpf_a03_it_enus
Lesson Objectives

Data Models and JSP

  • 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
  • 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 databasecomposite 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
  • 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
  • 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
  • build a JSP form using collections, tag, and error handling

Overview/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.

Target Audience
Application developers; data architects; technical architects; and anyone with experience in Java programming, XML parsing and editing, basic JavaServer page and HTML page coding, and a basic understanding of SQL database table structure and data querying.

Extending Oracle Commerce Applications

Course Number:
df_ocpf_a08_it_enus
Lesson Objectives

Extending Oracle Commerce Applications

  • start the course
  • work with the Profile Adapter Repository
  • create and configure a SQL repository
  • create a subtype of an item descriptor, create items of that subtype, and optionally display the unique subtype properties on a page
  • use the Repository Form Handler to add, modify, and delete repository items
  • use the Repository programming interface to programmatically manipulate repository data within Java code
  • configure a repository definition to implement an overridable derived property
  • consider the steps required to add version capability to a SQL repository
  • configure a repository so that items are preloaded upon repository startup
  • start the Commerce Reference Store server, explore the storefront, and take a close look at the Product Catalog
  • configure Eclipse to manage your Commerce Reference Store development work
  • extend the catalog by adding a custom property to the product repository item definition
  • add a property to the user profile definition
  • update the user details page, displaying an additional profile property
  • create a custom form handler and use that form on a page
  • use the Administration UI and the ACC to explore Oracle Commerce pipeline configurations
  • build and deploy a completed Oracle Commerce application

Overview/Description
The Oracle Commerce Platform provides the developer with a full-featured framework to build web applications. To master Oracle Commerce, it is important that you know how to extend applications' capabilities. In this course, you will create and configure a SQL repository, configure a repository so that items are preloaded upon repository startup, and other essential tasks for extending Oracle Commerce applications. This course is one of a series in the Skillsoft learning path that covers the material for the Oracle Commerce Platform Fundamentals for Developers.

Target Audience
Application developers; data architects; technical architects; and anyone with experience in Java programming, XML parsing and editing, basic JavaServer page and HTML page coding, and a basic understanding of SQL database table structure and data querying.

Form Handling with Pipelines and REST

Course Number:
df_ocpf_a06_it_enus
Lesson Objectives

Form Handling with Pipelines and REST

  • start the course
  • describe how form handler components handle input from an HTML form
  • apply property handler methods in form handlers
  • identify the two-step process in handling form errors
  • describe how Oracle Commerce exposes Java Transaction API (JTA) services as Nucleus components
  • identify the methods used for transaction management
  • identify the best practices used for writing form handlers
  • configure and customize chains of processors that perform operations on data in a configurable sequence
  • describe how the Oracle Commerce pipeline architecture uses processors instead of servlets
  • identify how the Pipeline Result object is used to report errors
  • distinguish between the Commerce Pipeline Processor classes
  • list the pipelines and the details on the processors that make them up
  • use XML to make your custom changes to pipelines
  • distinguish between the features of the legacy REST API and the REST MVC
  • describe how REST MVC uses chainable components (actors)
  • recognize how an actor helps generate a model
  • work with XML to define an actor
  • list the attributes and elements of the actor element
  • describe how bean filtering converts a bean into a map of properties
  • use the bean element to define a filter for a Java bean class or interface that is in the ModelMap
  • distinguish the differences in access control between legacy REST and REST MVC
  • use the Administration UI to explore the Request Handling servlet pipeline configuration

Overview/Description
There are many ways to extend the functionality of Oracle Commerce. Knowing when and how to extend the repository form handlers is essential to support custom requirements. In this course, you will learn how to extend the platform repository form handlers to support customized functionality, control transaction boundaries programmatically, and configure and customize chains of processors that perform operations on data in a configurable sequence. This course is one of a series in the Skillsoft learning path that covers the material for the Oracle Commerce Platform Fundamentals for Developers.

Target Audience
Application developers; data architects; technical architects; and anyone with experience in Java programming, XML parsing and editing, basic JavaServer page and HTML page coding, and a basic understanding of SQL database table structure and data querying.

Oracle Commerce Application Structure and Deployment

Course Number:
df_ocpf_a01_it_enus
Lesson Objectives

Oracle Commerce Application Structure and Deployment

  • start the course
  • describe the features and capabilities that the Oracle Commerce Platform provides for online commerce solution development
  • distinguish between core concepts of a Repository, Profile, and Scenario
  • identify the development tools, file and folder structure, configuration files, and application modules
  • list the steps needed to assemble, deploy, and run Oracle Commerce Platform applications
  • describe the several methods for creating an EAR for your application
  • instantiate and configure standard nucleus components
  • set up properties files and component configuration
  • describe how Oracle Commerce uses environment variables and configuration layering
  • list important types of layers as set by the config path
  • describe how sessions are special server-side objects corresponding to different users or browsers
  • examine application log files and configure component logging levels
  • create, configure, and deploy a session-scoped component
  • list the types of custom component classes and where they are used
  • describe how to reference custom components within a Java program
  • create a Java class in Eclipse, browse to find the superclass, and import classes and packages
  • describe the basics on the JSP syntax and use JSP tags
  • perform the steps needed for Eclipse to include the DSP and DSPEL tag libraries
  • describe how importing a component allows access to its properties by a simple name rather than the full component path
  • write a simple, completely static JSP page
  • write a program to pass values into an embedded JSP page
  • use Eclipse in collaboration with tag libraries to build and integrate an Oracle Commerce application

Overview/Description
Since the Oracle Commerce Platform consists of such a broad range of technologies, understanding its application structure and deployment is essential for any developer. In this course, you will be able to describe the features and capabilities of the Oracle Commerce Platform, create an Oracle Commerce Platform application module, and deploy Oracle Commerce Platform applications. This course is one of a series in the Skillsoft learning path that covers the material for the Oracle Commerce Platform Fundamentals for Developers.

Target Audience
Application developers; data architects; technical architects; and anyone with experience in Java programming, XML parsing and editing, basic JavaServer page and HTML page coding, and a basic understanding of SQL database table structure and data querying

Using the Repository

Course Number:
df_ocpf_a04_it_enus
Lesson Objectives

Using the Repository

  • 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
  • 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
  • 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
  • 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
  • review the Trunk Show Repository and supporting SQL table definitions and consider what steps would be required to add versioning

Overview/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.

Target Audience
Application developers; data architects; technical architects; and anyone with experience in Java programming, XML parsing and editing, basic JavaServer page and HTML page coding, and a basic understanding of SQL database table structure and data querying

Close Chat Live