Learn Soql In 60 Minutes
Published 10/2024
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
An entry-level mini-course for aspiring and established Salesforce professionals who want to master SOQL
What you’ll learn
Where To Test and Type Your SOQL Queries
Defining The Salesforce Data You Want
Narrowing Your SOQL Query Results
Formatting Your SOQL Query Results
More Advanced SOQL Concepts
Using A SOQL Generator
Common SOQL Formatting Results
Requirements
Though this course assumes zero prior knowledge about SOQL, it does expect you to be working with, or learning about the Salesforce platform, in some capacity.
Description
Overview
Lecture 2 What is SOQL?
Lecture 3 Is SOQL The Same As SQL?
Lecture 4 Why You Should Learn SOQL
Lecture 5 Where To Test & Type Your SOQL Queries
Lecture 6 How To Sign Up For A Free Salesforce Developer Org
Lecture 7 How To Access The Salesforce Developer Console
Section 2: Define The Data You Want
Lecture 9 The SELECT Statement
Lecture 10 The SELECT Statement In Action
Lecture 11 Formatting Tips
Lecture 12 Practice Exercises
Lecture 13 Practice Exercises – Answers
Section 3: Narrowing Your SOQL Query Results
Lecture 15 The WHERE Clause
Lecture 16 Comparison Operators
Lecture 17 Logical Operators
Lecture 18 The LIMIT Clause
Lecture 19 The OFFSET Clause
Section 4: Formatting Your SOQL Query Results
Lecture 20 Introduction To Section 4
Lecture 21 The GROUP BY Clause
Lecture 22 The ORDER BY Clause
Lecture 23 NULLS FIRST/NULLS LAST
Lecture 24 Putting It All Together – Exercises
Lecture 25 Putting It All Together – Answers
Section 5: Further SOQL Tips & Resources
Lecture 26 Introduction To Section 5
Lecture 27 Referencing Related Object Data
Lecture 28 Semi-Joins & Anti-Joins
Lecture 29 LIKE and NOT LIKE
Lecture 30 COUNT ()
Lecture 31 NOT
Lecture 32 Multi-Select Picklists
Lecture 33 Using a SOQL Generator
Lecture 34 How To Use Workbench To Generate SOQL Queries
Lecture 35 Common SOQL Formatting Mistakes
Section 6: Additional Content – How To Use AI to Speed Up Your SOQL Activities
Lecture 36 Introduction To Section 6
Lecture 37 Generating SOQL Queries
Lecture 38 Correcting SOQL Queries
Lecture 39 Things To Be Wary of When Generating SOQL With AI Tools
Lecture 40 My AI Tool Of Choice
Salesforce Administrators and beginner Salesforce Developers who know nothing about SOQl, and would like to be able to read and write beginner to intermediate SOQL queries confidently.
