Getting Started with SOQL

Revolutionize the use of simple query strings to make them more efficient using SOQL.
Preview in Mapt
Code Files

Getting Started with SOQL

Magulan D

Revolutionize the use of simple query strings to make them more efficient using SOQL.
Mapt Subscription
FREE
$29.99/m after trial
eBook
$11.90
RRP $16.99
Save 29%
Print + eBook
$27.99
RRP $27.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$11.90
$27.99
$29.99p/m after trial
RRP $16.99
RRP $27.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


Getting Started with SOQL Book Cover
Getting Started with SOQL
$ 16.99
$ 11.90
Getting Started with NoSQL Book Cover
Getting Started with NoSQL
$ 14.99
$ 10.50
Buy 2 for $22.40
Save $9.58
Add to Cart
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 

Book Details

ISBN 139781783287352
Paperback130 pages

Book Description

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.

Table of Contents

Chapter 1: Introduction to SOQL
What is SOQL?
Purpose of SOQL
SOQL syntax
Writing your first SOQL statement
Summary
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
Summary
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
Summary
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
Summary
Chapter 5: Limitations and Best Practices
Standards to be followed in SOQL
Best practices
Limitations in objects
Other limitations
Summary
Chapter 6: Tools with Installation Guidelines
Using the Force.com Explorer software
Workbench
Dataloader.io
The Apex Data Loader tool
Summary

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

Authors

Table of Contents

Chapter 1: Introduction to SOQL
What is SOQL?
Purpose of SOQL
SOQL syntax
Writing your first SOQL statement
Summary
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
Summary
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
Summary
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
Summary
Chapter 5: Limitations and Best Practices
Standards to be followed in SOQL
Best practices
Limitations in objects
Other limitations
Summary
Chapter 6: Tools with Installation Guidelines
Using the Force.com Explorer software
Workbench
Dataloader.io
The Apex Data Loader tool
Summary

Book Details

ISBN 139781783287352
Paperback130 pages
Read More

Read More Reviews

Recommended for You

Visualforce Development Cookbook Book Cover
Visualforce Development Cookbook
$ 29.99
$ 21.00
Learning Apex Programming Book Cover
Learning Apex Programming
$ 26.99
$ 18.90
Learning Salesforce Visual Workflow Book Cover
Learning Salesforce Visual Workflow
$ 39.99
$ 28.00
Visualforce Developer's guide Book Cover
Visualforce Developer's guide
$ 23.99
$ 16.80
Force.com Tips and Tricks Book Cover
Force.com Tips and Tricks
$ 16.99
$ 11.90
Force.com Enterprise Architecture Book Cover
Force.com Enterprise Architecture
$ 35.99
$ 25.20