SOQL learning using Real Life Scenario

SOQL Tutorial What is SOQL SOQL Real Life Scenario SOQL Naming Conventions SOQL WHERE SOQL Comparison Operators SOQL Logical Operators SOQL ORDER BY SOQL LIMIT SOQL OFFSET SOQL Aggregate Functions SOQL GROUP BY SOQL HAVING SOQL Relationship Queries SOQL Date Literals SOQL Date Functions SOQL History Objects SOQL Sharing Objects SOQL in APEX Apex Variables in SOQL Queries Static and Dynamic SOQL SOQL return types SOQL Governor Limits Efficient SOQL Queries

Over the course, we will be sharing various examples related to SOQL features. Let’s see the real-life use case, on which these will be explained.

Kyle Medical Group(KMG) is a healthcare provider across the USA, mainly related to heart diseases. KMG has several clinics in various states of the USA. KMG uses Salesforce to manage all the appointments for the patients.

KMG simplified data model:

Fig: Data Model of KMG Appointment Management System

1. The patients are represented in Contact standard object in Salesforce.
2. The clinics are represented by Clinic__c custom object in Salesforce.
3. An appointment is represented by Appointment__c custom object.
   • It has two lookup relationships, one with contact and another with clinic.
   • It’s a parent-child relationship.
   • A contact can have multiple appointments.
   • A clinic can have multiple appointments.
   • The appointment is a junction object.

Important

Note that the custom objects and custom fields are denoted by appending "__c" after their name, whereas standard objects and standard fields (Account, Contact, Opportunity, ...) don't have these suffix.
These are referred to as API Names in Salesforce.

Now, when we move towards specific examples explaining the features of SOQL, we shall refer to this model, for example.