Apex Academy: The Power of SOQL
The key to awakening the power of Apex lies in SOQL. Learn how to write SOQL queries, how to integrate SOQL in your Apex triggers, and how to defend your org from bugs by using SOQL in your test classes.
What you'll learn
The key to awakening the power of Apex lies in SOQL, Salesforce's data querying language. In this course, Apex Academy: The Power of SOQL, you get to see this power first hand. You'll start by learning how to write SOQL queries and how to integrate SOQL in your Apex triggers. You'll also get to see how to defend your org from bugs by using SOQL in your test classes. When you're finished with this course, you'll be able to write Apex triggers with unlimited automation powers in your org.
Table of contents
- Overview 2m
- Introduction to SOQL 3m
- SOQL Versus Reporting 2m
- SOQL Versus Data Loader 3m
- Where to Write SOQL Queries 4m
- How to Write a SOQL Query 6m
- SOQL Query Examples 3m
- Frequently Asked Questions 1m
- How to Filter SOQL Queries 6m
- WHERE Clause Cheat Sheet 2m
- Organizing Results 2m
- Advanced SOQL Queries 1m
- Understanding Relationships 3m
- Querying Parent Data 2m
- Querying Child Data 3m
- Grouping SOQL Results 3m
- Practice Exercises Overview 3m
- Practice Exercises 6m
- Summary 1m
- Introduction 1m
- Why We Combine SOQL with Apex 5m
- Example: Trigger.new Limitations 2m
- Techniques to Combine SOQL with Apex 1m
- Storing SOQL Results in a List 5m
- Bind Variables 9m
- Introduction: De-duplication Trigger 3m
- Demo: De-duplication Trigger 10m
- Testing the De-duplication Trigger 7m
- Challenge: De-duplication Trigger 1m
- Introduction: Comparable Opportunities 4m
- Demo: Comparable Opportunities 7m
- Testing the Comparable Opportunities Trigger 2m
- Challenge: Comparable Opportunities Trigger 1m
- Summary 1m
- Introduction 1m
- The Ultimate Testing Tool 7m
- How to Use System.assertEquals() 3m
- Test Classes Need SOQL 5m
- The Complete Guide to Testing in Salesforce 3m
- The Deployment Lifecycle 5m
- The Failed Deployment Lifecycle 4m
- De-duplication Trigger Test Class 2m
- De-duplication Test Scenario 1 4m
- De-duplication Test Scenario 2 3m
- Comparable Opportunities Test Class 1m
- Comparable Opportunities Test Scenario 1 2m
- Comparable Opportunities Test Scenario 2 4m
- Course Homework 4m
- Summary 1m
About the author
David Liu is a self-taught programmer whose dreams came true when he became a Salesforce Technical Architect at Google. Now, David dreams of inspiring the next generation of Salesforce developers. He's a four-time Salesforce MVP winner and runs SFDC99.com, the world's most popular Salesforce blog. David has been a close partner with Salesforce throughout his career, often speaking and developing content for Dreamforce, Trailhead, webinars, user groups, and the official Salesforce developer websi... more