Getting Started with SOQL

by Magulan D.

Revolutionize the use of simple query strings to make them more efficient using SOQL



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.








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.

130 pages, Kindle Edition

First published January 1, 2014

Reviews

[Abhi Tripathi · Rating 4 out of 5]

Feature of SOQL is so vast, but for the beginners as well as for experts this book will teach something, even I learned allot those things that I was not using most of the time in SOQL like toLabel() method. The use of Date literals with their example implementation in the queries.

The traditional method of explaining clauses like how to write SOQL, Where to use Caps and where not, that we need to take care of whenever writing an apex class. Limitation is the one difficult thing to handle in salesforce and if we are talking about SOQL then its limitation are most important thing to take care off. In the book limitation of SOQL have been explained in a brief way.

This book also addresses the standards and guidelines to be followed when writing SOQL statements. The standards and guidelines discussed in this book will help you to write SOQL statements without hitting any limitation set by Salesforce.com and to avoid unwanted data fetched through the queries.

[Ian Jamieson · Rating 4 out of 5]

I've just finished reading Getting Started with SOQl and have a much better understanding of this Saleforce tool. I'm an Admin myself but I'm always keen to learn more about the development side of things. This book is clearly written and aimed at newbies like myself - well worth reading to gain an extra bow of knowledge. http://bit.ly/1kusChR

[Mohitkumar Srivastav · Rating 4 out of 5]

This book is excellent for freshers who have no previous SQL experience or any experience writing queries and now have migrated to the SFDC platform and they need to learn SOQL for building pages ,triggers or batches using apex and Visualforce on force.com platform .The Author has explained the concepts in a very user friendly manner and used tools like force.com explorer for all practical insights .Definitely recommend this for fresher on the platform.

http://bit.ly/1kusChR

[Mike Ng · Rating 4 out of 5]

This book is concise and so easy to understand for beginner like me to gain knowledge into Salesforce.com especially focusing on SOQL. Having zero knowledge in SOQL prior to reading this book and was required to perform tasks on my work, I'm able to ramp myself up and get my job done in short duration. Get it here at SOQL

[Shravan · Rating 4 out of 5]

Awesome Introduction to SOQL. Very Simplified but powerful content. Really like the book.
http://bit.ly/1kusChR