Phase B: Data Architecture & Management

Design & Optimisation

• Data modelling

• Data model Relationships

• Data Model Relationship Considerations

• Define External Objects with Salesforce Connect

• Salesforce Connect Considerations for all Adaptors

• Custom Settings

• Picklist vs Custom Objects and Associated limitations

• Picklist Performance

• The Ultimate Guide to Salesforce Integration

• Data Integration Patterns - Aggregation

• Introduction to Large Data Volume Concepts

• Best Practices for Deployments with Large Data Volumes

• Lightning PLatform Query Optimizer

• Query Plan Tool

• Custom Indexes

• Skinny Tables

• Salesforce Big Object Reference

• Big Object Implementation Guide

• Maximising the Performance of FORCE.com SOQL Reports and List Views

• Working With Vary Large SOQL Queries

• Salesforce Query Search Optimisation Cheat Sheet

• Make SOQL Selective

Custom Metadata Types

• Custom Metadata Types

• Introducing Custom Metada Types: Blog

Data Management Best Practise Guides

• Data Management Best Practise Guides

• Ask An Architect - Effective Salesforce Data Management Strategy Part1

• Ask An Architect - Effective Salesforce Data Management Strategy Part2

Data Movement

• Import Data Into Salesforce

• Choosing a Method for Importing Data

• Bulk API 2.0 and Bulk API Developer Guide

• Data Skew - Managing Lookup Skew

• Designing Record Access for enterprise Scale

• Granular Locking

• Backup and Restore