Salesforce Development : Combining Apex with SOQL

Explore how Apex and soql overcome automation limits of workflow, process builder, and flows, enabling updates across any Salesforce record, and practice writing soql queries in the developer console.

Explore the strengths of soql over salesforce reports and data loader, showing faster, flexible queries, cross-object capabilities, and limits of reporting tools.

Learn to write soql queries with Workbench and the developer console, selecting fields by API name from Account and Contact objects.

Learn to write SOQL queries for opportunities, including standard fields and related data, using API names and the workbench; explore hidden objects like user rules and profiles.

Master filtering in SOQL to narrow account results by industry, phone, and billing state, using where clauses, equals, not equals, null checks, like, and in for multiple values.

Explore practical soql examples by querying opportunities, using like with % wildcards for monthly in names, filtering by amount with > or >=, and combining or conditions for stages.

Order your SOQL results by stage name with the order by clause, using ascending by default or descending, and extend to multiple fields such as stage name and close date.

Limit SOQL results by using the limit keyword in Apex and SOQL to fetch a precise number of records, from a single row to thousands.

Query parent data from child records in Salesforce using dot notation to fetch account fields such as name and annual revenue, and extend to custom objects via relationship lookups.

Learn to query child records from a parent in Salesforce by selecting account fields and embedding a subquery on opportunities, using the plural relationship name opportunities and dot notation.

Explore grouping SOQL results to summarize opportunities by account, using aggregate functions (sum, average, min, max, count) and group by account name, with related account fields via dot notation.

Use SOQL in Apex to fetch records and fields not available in trigger.new, overcoming its base field limitations and enabling access to related object data in opportunities.

Create and populate Apex lists from bracketed SOQL queries, storing Id, Name, StageName, Amount, and Owner from accounts and opportunities while matching the list object type to avoid errors.

Develop an Apex trigger to update an account's annual revenue by summing closed one opportunity amounts using a before trigger and a SOQL query with a bind variable.

Fix the trigger by using a SOQL query to fetch the related account industry and update the opportunity description accordingly, while avoiding SOQL inside loops to meet governor limits.

Create a before insert trigger on account to prevent duplicate account names by querying existing accounts with the same name using SOQL and showing an error on the name field.

This lecture demonstrates creating a before update trigger on the account to copy the account billing address to related contacts' mailing address, updating street, city, state, country, and postal code.

Test and debug a trigger that copies an account's billing address to related contact records, using system.debug to verify pre-update values, and switch to after update for reliable cross-object updates.

Automate opportunity records by populating the primary contact lookup field with the account's key contact when creating or updating an opportunity, provided the user has not set the primary contact.

Create a trigger on opportunity to auto-update the primary contact with the account's key contact on insert or when the field is blank on update.

Debug a trigger on opportunity primary contact by handling accounts with zero or multiple contacts. Convert to a list, apply limit 1, and verify size before accessing the first id.

Learn how test classes protect Apex code and triggers by validating multiple scenarios to ensure 75 percent code coverage for deployment to production with System.assertEquals assertions for each test class.

Discover how to use System.assertEquals to validate that the expected value matches the actual value in test methods, including boolean checks and optional error messages.

Use assertions and SOQL in test classes to validate an opportunity trigger that updates the primary contact with a key contact. Query latest record and compare actual to expected values.

Develop an apex test class named test opportunity primary contact with @isTest to validate three scenarios: existing primary contact, blank auto-population with the key contact, and no account contact.

Demonstrates testing opportunity primary contact logic by nulling the primary contact, triggering a lookup for the account's key contact, and validating update with SOQL queries and 100% test coverage.

Explore Apex and SOQL testing in a test class by simulating an account without contacts, creating an opportunity, and asserting a null primary contact to verify trigger behavior and coverage.

Create a post-update test class for a trigger that copies account billing address to contact mailing address, covering single and multiple contacts, null and existing mailing addresses, with latest-record verification.

Explore how an after update trigger copies an account's billing address to multiple contact mailing addresses, and validate with test classes using assertions and 100 percent coverage.

Explain how to build an Apex test class for account duplicates. Validate the 'cannot create a duplicate account' error and verify duplicate and non-duplicate scenarios to ensure code coverage.

Celebrate finishing the Salesforce development course by applying Apex to automation, completing assignments, and practicing to gain confidence in Apex and its capabilities.