Getting Started with SOQL -- Table of Contents -- Getting Started with SOQL -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Errata -- Piracy -- Questions -- 1. Introduction to SOQL -- What is SOQL? -- Purpose of SOQL -- SOQL syntax -- Writing your first SOQL statement -- Summary -- 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 -- 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 -- 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 -- 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 -- 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 -- A. Review Questions -- Chapter 1 -- Chapter 2 -- Chapter 3 -- Chapter 4 -- Index.