Free Sample
+ Collection
Code Files

Getting Started with SOQL

Magulan D

Revolutionize the use of simple query strings to make them more efficient using SOQL.
RRP $16.99
RRP $27.99
Print + eBook

Want this title & more?

$12.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781783287352
Paperback130 pages

About This Book

  • Write optimized SOQL statements
  • Discover the standards to follow while writing SOQL statements
  • Learn how to write SOQL statements without hitting the limits set by

Who This Book Is For

If you are a developer or administrator, this book will help you to avoid hitting the limits set by For those of you who are preparing for the Advanced Developer certification, this book will also be particularly useful.

Table of Contents

Chapter 1: Introduction to SOQL
What is SOQL?
Purpose of SOQL
SOQL syntax
Writing your first SOQL statement
Chapter 2: Basic SOQL Statements
The alias notation
The WHERE clause
The comparison operators
The IN operator
The logical operators
The ORDER BY clause
The INCLUDES and EXCLUDES operators
Chapter 3: Advanced SOQL Statements
Relationship queries
Filtering multiselect picklist values
The escape sequences
The date formats
The date literals
Querying with the date fields
Sorting in both the ascending and descending orders
Using the GROUP BY ROLLUP clause
Using the FOR REFERENCE clause
Using the FOR VIEW clause
Using the GROUP BY CUBE clause
Using the OFFSET clause
Chapter 4: Functions in SOQL
Using the toLabel() method
Using the GROUP BY clause
Using the COUNT() method
Using the COUNT(Field_Name) method
Using the COUNT_DISTINCT() method
Using the MIN() method
Using the MAX() method
Using the SUM() method
Using the HAVING clause
Chapter 5: Limitations and Best Practices
Standards to be followed in SOQL
Best practices
Limitations in objects
Other limitations
Chapter 6: Tools with Installation Guidelines
Using the Explorer software
The Apex Data Loader tool

What You Will Learn

  • Discover how to write effective SOQL statements
  • Find out about the standards to be followed while writing SOQL statements
  • Understand the effective use of advanced SOQL statements
  • Fetch records from multiple objects
  • Sort records with multiple fields
  • Get to know about the tools that support the execution of SOQL statements and their installation guidelines
  • Understand the functional areas within SOQL queries
  • Implement mechanisms to manage SOQL on Salesforce

In Detail

This practical guide will tell you everything you need to know about SOQL statements. You will learn the optimum way to write complex SOQL statements with this easy-to-understand guide. Beginning with basic SOQL statements, you will progress quickly onto more advanced statements, such as how to filter multiselect picklist values to escape sequences.

This book will teach you how to sort records with more than one field, sorting with more than one field–one in ascending order and another field in descending order—and sorting null records in the first or in the last. You will learn about all the features provided while you are writing SOQL statements. This book will make you a SOQL expert by teaching you how to write SOQL statements in an optimized and effective way.


Read More