Learn Soql In 60 Minutes
Published 10/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 369.91 MB | Duration: 1h 19m
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
If you are a Salesforce Administrator who knows NOTHING about SOQL and would like to be able to read and write SOQL queries confidently, then this is the mini-course for you.Unlock the full potential of Salesforce analytics with this introductory guide to SOQL (Salesforce Object Query Language). Perfect for aspiring Salesforce developers, admins, and anyone looking to harness the power of Salesforce data.YES! You can really read the key sections of this book in 60 minutes.YES! Once you have completed those key sections you will be able to read and write basic SOQL queries.YES! Practice exercises (and answers) have been provided to test and re-enforce your knowledgeWhat's in this mini-course:What SOQL is and how it differs from SQLDefining the data you want with the SELECT statementRefining your results using the WHERE clauseOrganise your results for maximum impact and usabilityAnd much moreEquip yourself with the knowledge and tools to excel in Salesforce with this introductory SOQL tutorial.Learn the common SOQL formatting mistakes. Avoid common pitfalls such as spelling mistakes, using field names instead of API names, and more.Additional Content - How To Use AI To Speed Up Your SOQL ActivitiesDiscover how AI can enhance your SOQL capabilities with this FREE resource that covers:Generating SOQL QueriesCorrecting SOQL ErrorsThings To Be Wary of When Generating SOQL With AI ToolsStart your journey to SOQL mastery today!
Overview
Section 1: Part 1: SOQL Basics
Lecture 1 Introduction to Part 1
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 8 Introduction to Part 2
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 14 Introduction to Part 3
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.
Screenshots
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!