Section 3: Working with Databases (14%)

Previous Section | Next Section

Section 3: Working with Databases (14%)

3.1 Demonstrate understanding of the architectural layers of the database access classes, including models, repositories, and data mappers

Models, resource models, and collections in Magento, their impact on performance. Repositories, SearchCriteria, WebAPI, WebAPI access, extension attributes

How to create an entity that supports extension attributes

How to implement SearchCriteria processing in the `repository::getList` method

How to perform bulk save operations in Magento

How to extend the Magento data object (Data API class) with an attribute that has values in a remote system

How to extend existing WebAPI calls with a new parameter

How to create a dynamic WebAPI ACL

The difference between extension attributes and custom attributes

3.2 Demonstrate understanding of the staging workflow

Staging modification to the Magento database operations (row_id, entity managers)

How does data versioning work?

Different possibilities of data versioning (row/table/database level) and how this is implemented in Magento

The role of the entity manager

High level staging implementation overview

3.3 Demonstrate an ability to use different types of setup scripts in Magento

Schema and data setup scripts, uninstall scripts, recurring scripts, uninstall schema vs. uninstall data

What happens when an 'uninstall script' is executed: data version change, deleted tables, etc.

Recurring scripts and their order in the setup:upgrade process

Accessing areas and system configuration values in setup scripts