SOQL in Salesforce - Crash Course

Learn how to write effective SOQL queries in Salesforce and improve your skills as a Salesforce Developer

4.79 (33 reviews)
Udemy
platform
English
language
IT Certification
category
139
students
2 hours
content
Nov 2022
last update
$39.99
regular price

What you will learn

Learn how to write SOQL

Basics to Advanced concepts in SOQL

Write effective parent to child and child to parent queries in Apex

Effective Use Cases and Examples to understand different operators, clauses and functions in SOQL

Description

In this course, you will learn all about SOQL - Salesforce Object Query Language


SOQL is the language Salesforce uses to communicate to the database and it is an important seeping stone in starting your Developer Journey. The Salesforce Query Language is powered by Oracle and it has everything you need and is very similar to SQL.


We will start by understanding the Query Structure of SOQL which will make it easy of you write queries.


We will cover:

- Basics of SOQL

- What is SOQL

- Why do we need SOQL

- How is SOQL an extension of SQL

- Build basic queries Out of the Box using Developer Console

- Different Operators & Clauses in SOQL : AND, OR, NOT, LIKE, ORDER BY, GROUP BY, HAVING, LIMIT, OFFSET, WHERE


We will also look at use cases on how to:


- Use Null in SOQL

- Use Escape Characters in SOQL

- Use Date Specific Filters in SOQL

- Query Parent information from Child SOQL

- Query Child information from Parent SOQL


We will understand the best practices of writing effective SOQL

We will also understand the Governor Limits by Salesforce on SOQL

Lastly we will play a quiz game to see what you learnt.


Hope this course turns out to be a good learning opportunity for you and sets you up to speed for your Developer journey.

Content

Introduction to SOQL

SOQL is So QooL
Why do we need SOQL?
SOQL Query Structure
Build Queries OOTB

Let's write some SOQL

5 Easy Use Cases

Operators in SOQL

Important Operators in SOQL
Use Null checks in Queries
Use Boolean Flags in SOQL

Relationships in SOQL

Query related records in SOQL

Playing around with Date and DateTime

Date & DateTime specific queries

Reserved Characters & Escape Characters in SOQL

Reserved Characters
Missing SQL? Don't

Limits & Considerations

Reserved Characters in SOQL
Governor Limits

Quiz Time

Let's see what you learnt

Screenshots

SOQL in Salesforce - Crash Course - Screenshot_01SOQL in Salesforce - Crash Course - Screenshot_02SOQL in Salesforce - Crash Course - Screenshot_03SOQL in Salesforce - Crash Course - Screenshot_04

Reviews

James
March 6, 2023
He takes the time to explain the thinking, he doesn't just tell you the answer. This is key for a marketing professional that is learning SOQL, because I'm able to first think in English, then learn how to convert that into the correct format in SOQL...rather than just memorizing a bunch of commands. Excellent course!

Charts

Price

SOQL in Salesforce - Crash Course - Price chart

Rating

SOQL in Salesforce - Crash Course - Ratings chart

Enrollment distribution

SOQL in Salesforce - Crash Course - Distribution chart

Related Topics

4962374
udemy ID
11/5/2022
course created date
11/10/2022
course indexed date
Bot
course submited by