SOQL in Salesforce - Crash Course

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 discuss 9 practice use cases to understand the query structure and writing them effectively.

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.