Course 1.3 · Curriculum 2026.1
Objects, fields, relationships and the lookup-versus-master-detail decision
Model data so it still works in year three. The lookup decision is taught through the rollup backfill it forces on you.
- Estimated effort
- 5 hr
- Lessons
- 42
- Modules
- 7
- Material
- 5 hr
Estimated effort is the sum of the lesson and lab times in this version of the course. It is not video runtime, which is lower.
Canadian dollars. One learner, lifetime access to this course version. Tax extra.
1 lesson free to preview
This course does not issue a certificate on its own. It counts toward the paths listed below, and those do.
01What you will learn
7 capabilities, stated as things you can do
Each one is what you should be able to do at the end, not what the course covers. If an outcome is not testable, it is not an outcome.
- Choose between a lookup and a master-detail relationship, and state the cost of each in rollups and sharing.
- Explain why most parent-child links in a real org are lookups, and what that means for reporting.
- Specify a rollup with a declarative rollup tool, and schedule the backfill that realtime rollups skip.
- Pick a field type that will not need migrating in a year, including the picklist-versus-lookup decision.
- Build a junction object for a many-to-many relationship without producing duplicate records.
- Write a formula field that stays readable, and know the three things a formula cannot do.
- Read an existing custom object and say why it was built that way.
02Curriculum
7 modules, 42 lessons
Every lesson shows its length and its type. A SCORM lesson looks like any other lesson, which is the point of ingesting packages rather than linking out to them.
7 modules · 42 lessons · 5 hr of material
Field type, length and picklist strategy are the decisions people regret. Each one here is taught with its migration cost attached.
- VideoThe field types, and the three you will misuse6 min
- VideoPicklist, global value set, or lookup to a custom objectA picklist that a business user needs to add values to weekly is a lookup wearing a costume. Decide by who owns the list.Preview7 min
- ReadingText versus a controlled list: the migration you can avoid6 min
- VideoField length, and the ceiling you hit two years later7 min
- VideoDefault values, and the field that trained everyone to ignore it6 min
- LabLab: pick the right field type for six real requirements6 min
What a formula field can do, and the three things it cannot, taught before you rely on one somewhere load bearing.
- VideoFormula fields: what they can do, and the three things they cannot7 min
- VideoCross-object formulas, and how far up the tree they can reach6 min
- ReadingValidation rules, and where they belong versus a Flow7 min
- VideoThe formula field whose help text undersold what it didHelp text is a claim, not a guarantee. A field marked informational can still be the thing every other automation depends on.6 min
- VideoBlank versus zero, and the formula that got it wrong7 min
- LabLab: write three formula fields a real report will need6 min
The heart of the course. A master-detail relationship buys you rollups and inherited sharing, and costs you cascade delete and restricted reparenting.
- VideoLookup versus master-detail, stated as a tradeMaster-detail gives native rollup summaries and inherited sharing. It also deletes children with the parent and restricts reparenting.6 min
- VideoWhat master-detail buys you: rollups and inherited sharing7 min
- VideoWhat master-detail costs you: cascade delete and restricted reparenting6 min
- ReadingHierarchical relationships and self-lookups7 min
- VideoChanging a lookup to master-detail after the fact, and why you rarely can6 min
- LabLab: model a quoting process end to end7 min
A many-to-many relationship needs a junction object with its own fields, not two bare lookups bolted together.
- VideoJunction objects, and the duplicate nobody expected6 min
- VideoA junction object with its own fields, not two bare lookups6 min
- ReadingMany-to-many reporting, and the report type it needs7 min
- VideoSharing through a junction: whose access actually wins6 min
- VideoDeleting one side of a junction, and what happens to the count7 min
- LabLab: build a junction object and prove the count is right6 min
Rollup summary fields exist only on the master-detail parent. On a lookup they are simply not offered, and that is the whole story.
- VideoWhy your rollup summary field is greyed outRollup summary fields exist only on the master-detail parent, never on a lookup. On a lookup they are simply not offered, and that is the whole story.7 min
- VideoMost parent-child links in a real org are lookups, not master-detail6 min
- ReadingReporting your way to a total without a rollup at all6 min
- VideoRoll-up summary fields on master-detail: count, sum, min, max7 min
- VideoThe rollup you cannot build declaratively at all6 min
- LabLab: find every lookup relationship in an org that wants a rollup7 min
The three connected facts about rollups, in order: most links are lookups, so native rollups are impossible, so you need a tool, and that tool needs a backfill.
- VideoDeclarative rollup tools, and how they actually recalculateRealtime mode fires on record change. A no-op save does not change anything, so it fires nothing, and your historical totals stay wrong.6 min
- VideoRealtime mode, and the no-op save that fires nothing6 min
- ReadingScheduled recalculation, and when you actually need it7 min
- VideoPurchase order totals wrong on 16 of 79 records, and what fixed itOne purchase order header disagreed with the sum of its own lines. All 79 records were backfilled to zero mismatches.6 min
- VideoChange request totals empty on 143 records, and the same fix twice7 min
- LabLab: install a rollup tool, define a rollup, run the backfill, verify the number6 min
The skill that pays for the rest of the course: opening a schema someone else built and reconstructing the decision behind it.
- VideoReading an existing custom object, and why it was built that way7 min
- VideoThe three connected facts about rollups, said back to you in one minute6 min
- ReadingA field inventory: what to record before you touch a schema7 min
- LabLab: reverse-engineer a custom object’s design decisionsThe capstone lab. Given an unfamiliar custom object, write down every relationship, field type and rollup decision and defend each one.31 min
- VideoSigns a custom object is about to need a rebuild6 min
- QuizCheck: objects, fields and relationships12 min
03Before you start
What you need first
Assumed knowledge and setup
- Course 1.1, or the equivalent understanding of the standard object graph.
- A Developer Edition org you can create custom objects in.
- The rollup lab uses a free declarative rollup package. Installation is part of the lab.
Courses that come first
Part of these paths
- Salesforce AdministratorShareCo Certified Administrator
- Salesforce DeveloperShareCo Certified Developer
- The Full StackShareCo Certified Platform Engineer
04Who teaches it
Ege Taskent
Salesforce Developer, Certified Platform Administrator
The credential, and the rollout. The half of an implementation where people actually start using the thing.
Salesforce Certified Platform Administrator
05Reviews
No learner reviews yet
This course has not been taken by enough people to publish an honest rating, and we will not print invented quotes on a page that sells verification discipline. Here is what we can evidence instead.
- Assessment
- Lesson checks onlyThis course carries lesson checks. The certificate is issued by the path assessment, not by this course.
- Curriculum version
- 2026.1You enrol into a version. Content changes do not move you mid-course, and your required-lesson count is snapshotted at enrollment.
- Refunds
- 14 daysFull refund within 14 days if you have completed under a quarter of the required lessons. Stated here rather than in a footer.
Start 1.3
Enrol as an individual, or buy seats and assign this course to your team. Progress is reported per lesson, per module and per path.
- 5 hr estimated effort, labs included
- Lifetime access to the version you enrol in
- A ShareCo certificate is not a Salesforce certification