Module 5 condensed cheat sheet

SALESFORCE MODEL
-----------------

Account
  company/customer organization

Contact
  person
  AccountId → Account

Opportunity
  potential deal
  AccountId → Account

Case
  support/customer issue
  AccountId → Account
  ContactId → Contact


CUSTOMIZATION
-------------

Foo__c
  custom field/object

Foo__r
  custom relationship traversal


SOQL
----

SELECT Id, Name
FROM Account
WHERE ...

No normal SQL-style JOIN thinking.


CHILD → PARENT

SELECT
    FirstName,
    Account.Name
FROM Contact


PARENT → CHILD

SELECT
    Name,
    (SELECT Email FROM Contacts)
FROM Account


INTEGRATION CONCERNS
--------------------

External IDs
N+1 queries
batch querying
incremental synchronization
watermarks
permissions
Salesforce validation rules
partial failures
schema drift
idempotency

The next module should be Module 6: Mule routing and orchestration — Choice, For Each, Parallel For Each, Scatter-Gather, Flow Reference, subflows, and when NOT to use each one. This is important because once an interviewer gives you anything more complex than “transform and upsert,” those are the components you'll use to actually assemble the business process.