Section 4: Working with Databases in Magento (7%)

Previous Section | Next Section

Section 4: Working with Databases in Magento (7%)

4.1 Demonstrate ability to use data-related classes

Describe repositories and data API classes. How do you obtain an object or set of objects from the database using a repository? How do you configure and create a SearchCriteria instance using the builder? How do you use Data/Api classes?

Describe how to create and register new entities. How do you add a new table to the database?

Describe the entity load and save process.

Describe how to extend existing entities. What mechanisms are available to extend existing classes, for example by adding a new attribute, a new field in the database, or a new related entity?

Describe how to filter, sort, and specify the selected values for collections and repositories. How do you select a subset of records from the database?

Describe the database abstraction layer for Magento. What type of exceptions does the database layer throw? What additional functionality does Magento provide over Zend_Adapter?

4.2 Demonstrate an ability to use declarative schema

Demonstrate use of schema. How to manipulate columns and keys using declarative schema? What is the purpose of whitelisting? How to use Data and Schema patches? How to manage dependencies between patch files?