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 QooL
Lecture 2 Why do we need SOQL?
Lecture 3 SOQL Query Structure
Lecture 4 Build Queries OOTB
Section 2: Let's write some SOQL
Lecture 5 5 Easy Use Cases
Section 3: Operators in SOQL
Lecture 6 Important Operators in SOQL
Lecture 7 Use Null checks in Queries
Lecture 8 Use Boolean Flags in SOQL
Section 4: Relationships in SOQL
Lecture 9 Query related records in SOQL
Section 5: Playing around with Date and DateTime
Lecture 10 Date & DateTime specific queries
Section 6: Reserved Characters & Escape Characters in SOQL
Lecture 11 Reserved Characters
Lecture 12 Missing SQL? Don't
Section 7: Limits & Considerations
Lecture 13 Reserved Characters in SOQL
Lecture 14 Governor Limits
Section 8: Quiz Time
Lecture 15 Let's see what you learnt
Anyone who wants to understand how to write queries in Salesforce,Anyone who wants to learn SOQL,Anyone who wants to do a crash course on SOQL



Download link

rapidgator.net:


uploadgig.com:


nitroflare.com:


1dl.net: