108 / 278 · Module 5 — Salesforce Data Model + SOQL · filtered: code← prev ⊞ all next →

5.50What you actually need to memorize

This:

SELECT Id, Name
FROM Account
WHERE External_Customer_ID__c = :customerId

This:

SELECT
    Id,
    FirstName,
    LastName,
    Account.Name
FROM Contact
WHERE Account.Status__c = 'Active'

And this:

SELECT
    Id,
    Name,
    (
        SELECT
            Id,
            FirstName,
            LastName
        FROM Contacts
    )
FROM Account

Plus:

Account
    ↓
Contacts

Account
    ↓
Opportunities

Account
    ↓
Cases

and:

__c
custom field/object

__r
custom relationship

If those become familiar, you have enough Salesforce data-model literacy for a Mule integration interview.