Free Salesforce Admin Tutorial >

Chapter 4 - Data Modelling >

Database and Objects in Salesforce

Database and Objects in Salesforce

What You’ll Learn


tickWhat is a Database?

tickWhat are Salesforce objects & its types?

tickHow to create objects in Salesforce?

Data Modeling is a process that involves the structuring of the data in the database by creating tables(objects), and columns(fields). So, to learn Data Modeling in Salesforce, the first thing one should learn is Database.

About Database

It is simply a base of data, and can also be defined as an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS).

Databases are widely divided into two major types or categories namely, Relational or Sequence Databases and Non-relational or Non-sequence databases or No SQL databases. An organization may use them individually or combined, depending on the nature of the data and its required functionality.

Databases often store information about people, such as customers or users. For example, social media platforms use databases to store user information, such as names, email addresses, and user behavior. Such data can be used to recommend content to users and improve the user experience.

Table: Student

Id

First Name

Last Name

Email

Year of Birth

1

Peter

Lee

plee@university.edu

1992

2

Jonathan

Edwards

jedward@university.edu

1993

3

Marilyn

Kim

mkim@university.edu

1995

4

Joe

Martinez

jmartinez@university.edu

1994

6

Haley

Mfume

hmfume@university.edu

1992

12

John

Letty

jletty@university.edu

1995

In A Relational Database

  • Data related to each object/entity is stored in a separate table.
  • Each table comprises a number of columns of a particular data type such as Text, Number, or Date.
  • Information is stored in the rows of tables.
  • Tables can be related to other tables using the concept of Primary Key and Foreign Key.

Whereas In Salesforce

  • Databases use objects to store data.
  • Each object comprises several fields that correspond to columns in a database.
  • Data is stored in records of objects which correspond to the rows in a database.
  • Objects can be related to other objects using relationship fields.

What Are Objects In Salesforce?

Objects in the Salesforce platform are represented in the form of a table which is used to categorize the data and is similar to an entity in a database.

Types Of Objects In Salesforce

There are 2 different types of objects in Salesforce:

1. Salesforce Standard Objects

Standard Objects are the objects which are already present in Salesforce by default. Common business objects like Account, Contact, Lead, and Opportunity are all standard objects. Although we can customize these standard objects but we cannot delete them.

2. Salesforce Custom Objects

Custom Objects are new objects created to store information unique to an organization. Custom objects extend the functionality that standard objects provide. We can both customize and delete custom objects.

Note:

Each object in the Salesforce platform has several built-in features like user interface, security, sharing model, and much more.

Download Study Material

Get access to exclusive study material for Salesforce Certification and ace your exams!

Download Now

Our Salesforce Certification Courses

Hey there! Glad you made it through our Salesforce Admin Training for beginners. But wait! We've got some high-in-demand Salesforce courses for you to take your Salesforce skills to the next level, making you a desired professional in the Salesforce job market.

Post a Comment

Your email address will not be published. Required fields are marked *