Getting Started with SOQL
This course has been retired. Check out the alternatives below
-
What do you get with a Packt Subscription?
- Instant access to this title and 7,500+ eBooks & Videos
- Constantly updated with 100+ new titles each month
- Breadth and depth in over 1,000+ technologies
-
Introduction to SOQL
- Introduction to SOQL
- What is SOQL?
- Purpose of SOQL
- SOQL syntax
- Writing your first SOQL statement
- Summary
-
Basic SOQL Statements
- 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
-
Advanced SOQL Statements
- 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
-
Functions in SOQL
- 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
-
Limitations and Best Practices
- Limitations and Best Practices
- Standards to be followed in SOQL
- Best practices
- Limitations in objects
- Other limitations
- Summary
-
Tools with Installation Guidelines
- Tools with Installation Guidelines
- Using the Force.com Explorer software
- Workbench
- Dataloader.io
- The Apex Data Loader tool
- Summary