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.
Course info
Rating
(85)
Level
Intermediate
Updated
Aug 18, 2016
Duration
2h 57m
Table of contents
Course Overview
Introduction
SOQL Boot Camp
Understanding SOQL in Apex
Writing Defensive Test Classes
Description
Course info
Rating
(85)
Level
Intermediate
Updated
Aug 18, 2016
Duration
2h 57m
Description

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.

About the author
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.

More from the author
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is David, and welcome to my Apex Academy course, where we learn the power of SOQL. I'm a Salesforce Technical Architect at Google. In this course, we unlock the true power of the Apex programming language by learning its greatest tool, SOQL. Some of the major topics we'll cover include why SOQL opens up the magical world of salesforce, how to integrate SOQL into your Apex triggers, and how to write real test classes that take advantage of SOQL and protect your org from unexpected bugs. By the end of this course, you'll know how to write triggers that'll be able to automate every business process in your org. Before beginning the course, you should be familiar with basic fundamentals of the Apex programming language and know how to write simple triggers. I hope you'll join me on this journey to learn SOQL with this Apex Academy course at Pluralsight.

SOQL Boot Camp
Hello my students, and welcome back to the Apex Academy. We're about to begin the SOQL boot camp, where I'll teach you nearly everything you'd ever want to know about the SOQL programming language. Like every good boot camp out there in this world, you're going to enter this camp as a fresh-faced SOQL beginner, but exit as a battle-hardened SOQL warrior, ready to put your imprint on the Salesforce world with your newfound SOQL skills. Your training begins now. Here's an overview of what we'll be learning during this boot camp. First, I'll give you the rundown on SOQL, what it is, why we use it, and where you can practice writing it. Once you understand the use cases of SOQL, we're going to move on and learn the basics of the SOQL language. How to write simple queries, how to filter your queries, and how to organize the results of your queries. Then, we'll move onto writing advanced SOQL queries. Yes, you'll be writing advanced SOQL by the end of this module. It's not a very deep programming language, yet it's wildly useful. It's not often in life you come across something both easy to learn and powerful. We're going to learn two advanced SOQL techniques, cross-object SOQL queries, and grouping SOQL queries. And lastly, we'll round it off with some exercises to make sure the lessons stick.

Understanding SOQL in Apex
It's time, it's time, it's finally time! Now at last, on this day, we combine SOQL with Apex to unlock the true potential of code. I'm your teacher, David Liu, and let's begin. Here's an overview of what we'll be covering in this module. First, we go into a technical dive of why Apex needs SOQL so badly. Then, I'll teach you the specific syntax we use for combining SOQL and Apex. There are two main techniques. One involves lists, and the other involves what we call a bind variable. Finally, we wrap it up with two coding demos of some very powerful triggers.

Writing Defensive Test Classes
We're back to the Apex Academy. Up till now, we've learned a lot of offense when it comes to coding, but now it's time to learn some defense. As you transition to becoming a more advanced developer, you need to start learning all the best practices when it comes to protecting your org with automated testing. There's a lot more to test classes than you think. Here's a summary of what we'll learn in this module. First, we talked about the ultimate testing tool. I kid you not, System. assertEquals changes everything for the better. Then, we'll learn how and why we apply our newfound SOQL knowledge into test classes, too. Then we jump into what I'm calling the complete guide to testing in Salesforce. We'll go deep into the true reason why we test, how most mature orgs use test classes, and how it fits together into the deployment lifecycle. Don't miss this part. Next, we go into demos of how we use our new testing tools to write test classes for the two triggers we wrote last module. And finally, we close out this course with your homework.