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.

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.

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.

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.

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.

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.

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.

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.

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.

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.