Soql In Salesforce - Crash Course

What you'll 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
Requirements
You should know your way around Salesforce as an Administrator, that's all.
Description
In this course, you will learn all about SOQL - Salesforce Object Query LanguageSOQL 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, WHEREWe 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 SOQLWe will understand the best practices of writing effective SOQLWe will also understand the Governor Limits by Salesforce on SOQLLastly 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.
Overview
Section 1: Introduction to SOQL
Lecture 1 SOQL is So...

Read more

Continue reading...