Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Learning Force.com Application Development

You're reading from   Learning Force.com Application Development Use the Force.com platform to design and develop real-world, cutting-edge cloud applications

Arrow left icon
Product type Paperback
Published in Apr 2015
Publisher Packt
ISBN-13 9781782172796
Length 406 pages
Edition 1st Edition
Languages
Arrow right icon
Author (1):
Arrow left icon
Chamil Madusanka Chamil Madusanka
Author Profile Icon Chamil Madusanka
Chamil Madusanka
Arrow right icon
View More author details
Toc

Table of Contents (15) Chapters Close

Preface 1. Getting Started with Force.com FREE CHAPTER 2. Building the Data Model 3. Building the User Interface 4. Designing Apps for Multiple Users and Protecting Data 5. Implementing Business Processes 6. Data Management on the Force.com Platform 7. Custom Coding with Apex 8. Building Custom Pages with Visualforce 9. Analytics as a Service with the Force.com Platform 10. E-mail Services with the Force.com Platform 11. Building Public Websites with Force.com Sites 12. Deploying the Force.com Application A. Force.com Tools Index

Force.com platform query languages


The query languages are used to access data for data manipulation. There are two query languages in the Force.com platform:

  1. Salesforce.com Object Query Language (SOQL)

  2. Salesforce.com Object Search Language (SOSL)

Both of these languages are used to retrieve a set of data from the Force.com platform.

Salesforce.com Object Query Language (SOQL)

We assume that you are already familiar with query language such as SQL, which is the universal standard for interacting with relational databases. In the Force.com platform, we considered the data repository of the Force.com platform as the relational database. Therefore, we use SOQL instead of SQL for data-retrieving purposes. There are similarities as well as differences in SOQL and SQL.

Similarities

Differences

Most of the syntax

SOQL can only retrieve data (query-only language) while SQL can both read and write data.

Some overlapping functionalities

SOQL uses relationships but not Joins, while SQL implements relationships...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €18.99/month. Cancel anytime