Introduction
SOQL is Salesforce's query language for retrieving data from objects.
Read more →Welcome to SOQL Skills: Your Free SQL Learning Hub
Discover free SQL tutorials and resources at SOQL Skills. Perfect for beginners and intermediates to master SQL coding!
Basics
Setup
SOQL setup uses Salesforce Developer Console or Workbench for queries.
Read more →Syntax
SOQL syntax uses SELECT and FROM for querying Salesforce objects.
Read more →Fields
SOQL fields specify object attributes like Name or Amount in queries.
Read more →Data Types
SOQL data types include String Number and Date with type safety.
Read more →Operators
SOQL operators include comparison and logical for query conditions.
Read more →WHERE
SOQL WHERE filters records using conditions like AND and OR.
Read more →ORDER BY
SOQL ORDER BY sorts results with ASC or DESC modifiers.
Read more →LIMIT
SOQL LIMIT restricts the number of returned records.
Read more →Comments
SOQL comments use /* */ for query annotations.
Read more →Errors
SOQL errors use try-catch in Apex or error messages in tools.
Read more →Debugging
SOQL debugging uses Query Editor or Apex logs for troubleshooting.
Read more →Best Practices
SOQL best practices include selective fields, efficient filters.
Read more →Security Basics
SOQL security prevents injection with bind variables.
Read more →Queries
SELECT
SOQL SELECT retrieves fields from Salesforce objects like Account.
Read more →FROM
SOQL FROM identifies the Salesforce object to query like Contact.
Read more →COUNT
SOQL COUNT aggregates record counts with COUNT() function.
Read more →DISTINCT
SOQL DISTINCT removes duplicate field values in query results.
Read more →LIKE
SOQL LIKE matches patterns with % and _ wildcards.
Read more →IN
SOQL IN filters records against a list of values.
Read more →NOT
SOQL NOT negates conditions like NOT IN or NOT LIKE.
Read more →AND
SOQL AND combines multiple conditions for precise filtering.
Read more →OR
SOQL OR allows multiple conditions for flexible filtering.
Read more →NULL Handling
SOQL NULL handling uses IS NULL or IS NOT NULL.
Read more →Subqueries
SOQL subqueries filter records with nested SELECT statements.
Read more →IN Subqueries
SOQL IN subqueries filter using related object data.
Read more →EXISTS Subqueries
SOQL EXISTS subqueries check for related record existence.
Read more →Bind Variables
SOQL bind variables use :variable for secure queries.
Read more →Dynamic SOQL
SOQL dynamic queries build queries at runtime in Apex.
Read more →OFFSET
SOQL OFFSET skips records for pagination with limits.
Read more →FOR UPDATE
SOQL FOR UPDATE locks records during query execution.
Read more →Aggregates
GROUP BY
SOQL GROUP BY groups records for aggregations like COUNT.
Read more →HAVING
SOQL HAVING filters grouped results with aggregate conditions.
Read more →COUNT Function
SOQL COUNT function counts records or distinct field values.
Read more →SUM Function
SOQL SUM function aggregates numeric fields like Amount.
Read more →AVG Function
SOQL AVG function calculates average of numeric fields.
Read more →MIN Function
SOQL MIN function finds the smallest field value.
Read more →MAX Function
SOQL MAX function finds the largest field value.
Read more →Aggregate Queries
SOQL aggregate queries use GROUP BY for summarized data.
Read more →Objects
Standard Objects
SOQL standard objects include Account Contact and Opportunity.
Read more →Custom Objects
SOQL custom objects query user-defined Salesforce objects.
Read more →Relationship Fields
SOQL relationship fields use dot notation like Account.Name.
Read more →Lookup Fields
SOQL lookup fields access related object data via lookups.
Read more →Master-Detail Fields
SOQL master-detail fields query tightly linked object data.
Read more →Relationships
Parent-Child Queries
SOQL parent-child queries use subqueries for related records.
Read more →Child-Parent Queries
SOQL child-parent queries use dot notation for parent fields.
Read more →Relationship Joins
SOQL relationship joins query related objects with subqueries.
Read more →Polymorphic Queries
SOQL polymorphic queries handle fields like WhatId in Tasks.
Read more →Functions
Date Functions
SOQL date functions like CALENDAR_YEAR process dates.
Read more →Date Literals
SOQL date literals like TODAY filter date fields.
Read more →Fields
Formula Fields
SOQL formula fields query calculated fields like Total_Amount__c.
Read more →Custom Metadata
SOQL custom metadata queries retrieve configuration data.
Read more →Field History
SOQL field history queries track field changes with History objects.
Read more →Performance
Query Limits
SOQL query limits enforce governor restrictions in Salesforce.
Read more →Selective Queries
SOQL selective queries use indexed fields for performance.
Read more →Query Optimization
SOQL optimization uses selective filters to avoid timeouts.
Read more →Bulk Queries
SOQL bulk queries handle large datasets with FOR loops.
Read more →Governor Limits
SOQL governor limits restrict query rows and execution time.
Read more →Security
Injection
SOQL injection prevention uses bind variables and escaping.
Read more →Access Control
SOQL access control ensures queries respect user permissions.
Read more →Sharing Rules
SOQL sharing rules enforce record visibility in queries.
Read more →Integration
Apex Integration
SOQL Apex integration embeds queries in Apex code.
Read more →Tools
Workbench
SOQL Workbench executes queries via a web interface.
Read more →Developer Console
SOQL Developer Console runs queries in Salesforce UI.
Read more →Data Loader
SOQL Data Loader exports data with query exports.
Read more →Query Editor
SOQL Query Editor tests queries in Developer Console.
Read more →Testing
Testing
SOQL testing uses Apex tests or Workbench for validation.
Read more →Unit Testing
SOQL unit testing validates queries in Apex test classes.
Read more →Performance Testing
SOQL performance testing checks governor limit compliance.
Read more →Data Validation
SOQL data validation ensures query accuracy with assertions.
Read more →Examples
Account Query
SOQL account query retrieves Account Name and Industry fields.
Read more →Contact Query
SOQL contact query fetches Contact Email with filters.
Read more →Opportunity Query
SOQL opportunity query retrieves Amount with date filters.
Read more →Relationship Query
SOQL relationship query joins Account and Contact data.
Read more →Aggregate Query
SOQL aggregate query groups Opportunities by Stage with SUM.
Read more →Dynamic Query
SOQL dynamic query builds filters in Apex at runtime.
Read more →Bulk Query
SOQL bulk query retrieves records with FOR loop in Apex.
Read more →Custom Object Query
SOQL custom object query fetches fields from custom objects.
Read more →Field History Query
SOQL field history query tracks Opportunity Amount changes.
Read more →Metadata Query
SOQL metadata query retrieves configuration settings.
Read more →Explore Our Tools
SOQL Error Explainer
This page provides the SOQL Error Explainer tool. Utilize it for your tasks.
Go to tool →SOQL Keyword Reference
This page provides the SOQL Keyword Reference tool. Utilize it for your tasks.
Go to tool →SOQL Limits Checker
This page provides the SOQL Limits Checker tool. Utilize it for your tasks.
Go to tool →SOQL Query Builder
This page provides the SOQL Query Builder tool. Utilize it for your tasks.
Go to tool →SOQL Query Commenter
This page provides the SOQL Query Commenter tool. Utilize it for your tasks.
Go to tool →SOQL Query Formatter
This page provides the SOQL Query Formatter tool. Utilize it for your tasks.
Go to tool →SOQL Relationship Query Explainer
This page provides the SOQL Relationship Query Explainer tool. Utilize it for your tasks.
Go to tool →SOQL to SOSL Converter Preview
This page provides the SOQL to SOSL Converter Preview tool. Utilize it for your tasks.
Go to tool →