Getting Started with SOQL


Getting Started with SOQL
eBook: $16.99
Formats: PDF, PacktLib, ePub and Mobi formats
$14.44
save 15%!
Print + free eBook + free PacktLib access to the book: $44.98    Print cover: $27.99
$27.99
save 38%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • 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 Salesforce.com

Book Details

Language : English
Paperback : 130 pages [ 235mm x 191mm ]
Release Date : April 2014
ISBN : 1783287357
ISBN 13 : 9781783287352
Author(s) : Magulan D
Topics and Technologies : All Books, Application Development, CMS and eCommerce, Web Development, Open Source


Table of Contents

Preface
Chapter 1: Introduction to SOQL
Chapter 2: Basic SOQL Statements
Chapter 3: Advanced SOQL Statements
Chapter 4: Functions in SOQL
Chapter 5: Limitations and Best Practices
Chapter 6: Tools with Installation Guidelines
Appendix: Review Questions
Index
  • Chapter 2: Basic SOQL Statements
    • The alias notation
    • The WHERE clause
    • The comparison operators
      • The equals operator
      • The not equals operator
      • The less than or equal to operator
      • The less than operator
      • The greater than or equal to operator
      • The greater than operator
      • The LIKE operator
    • The IN operator
      • The NOT IN operator
    • The logical operators
      • The AND operator
      • The OR operator
    • The ORDER BY clause
    • The INCLUDES and EXCLUDES operators
    • Summary
  • Chapter 3: Advanced SOQL Statements
    • Relationship queries
    • Filtering multiselect picklist values
      • The INCLUDES operator
      • The EXCLUDES operator
    • 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
      • Governor limits
      • Understanding the limitations of the ORDER BY query
      • Understanding the limitations of the toLabel() query
      • Understanding the limitations of the COUNT() query
      • Understanding the limitations of the OFFSET clause
      • Limitations of the relationship queries
      • Notes and Attachments limitations
    • Summary
  • Chapter 6: Tools with Installation Guidelines
    • Using the Force.com Explorer software
      • Installing Force.com Explorer
    • Workbench
    • Dataloader.io
    • The Apex Data Loader tool
      • Downloading Data Loader without the Salesforce.com login
    • Summary

Magulan D

Magulan D is a Salesforce.com administrator and developer. He started his career as a PHP developer and also worked as a Siebel CRM developer. During his career as a PHP developer, he created many sites.

Magulan is also a blogger, posting many useful tutorials relating to Salesforce.com development and administration works. Often these are workarounds for problems or issues that people usually face in their development. He has been working as a Salesforce.com developer since 2011.

Sorry, we don't have any reviews for this title yet.

Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

Frequently bought together

Getting Started with SOQL +    HornetQ Messaging Developer’s Guide =
50% Off
the second eBook
Price for both: £19.95

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

  • 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.

Approach

This is a practical tutorial-based guide on using the new SOQL language, aimed at Force.com developers. Each topic is discussed with the help of standard SOQL queries.

Who this book is for

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

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software