Learn SOQL in Salesforce Development |LockdownLearning Day 2|Tutorials for beginners by Shrey Sharma

In this video you will learn SOQL in Salesforce development:
1. What is SOQL?
2. Different clauses in SOQL (or, AND and where)?
3. What is SOQL variable binding?
4. What are the different return types for SOQL?
5. What are SOQL aggregate functions?
This video is a part of the #LockdownLearning series in which Shrey will help you guys get the best out of these quarantine/lockdown days due to the COVID-19 pandemic by sharing his knowledge on Salesforce.
Every day at 8:00 p.m. IST he'll be going live on the channel till 14 Apr 2020.
Convert these lockdown days into an opportunity to learn and grow.
Also at the end of each session, he will give away a Salesforce Hulk T-shirt. So make sure to not miss it.
LINK FOR DAY 2 CHALLENGE:
s2-labs.com/sa...
Grow your business with THE BEST SALESFORCE IMPLEMENTATION and CONSULTANCY SERVICES
Reach us out here: cyntexa.com​
------
Get the BEST SALESFORCE COURSES & TRAINING here s2-labs.com/
Shrey is a Chief Executive Officer at Cyntexa which is considered as one of the top Salesforce Consulting Partner in the USA, UK, UAE, Australia, Singapore & India having a vibrant team of 100+ certified Salesforce experts which include developers, architects, consultants, administrators, and MVPs.
Shrey took Cyntexa from 5 to 100+ people in less than 1.5 years while multiplying the revenues by 8 times. Shrey has been an entrepreneur since the age of 13 as he was buying and selling stuff and making money in the school itself. Shrey is the Youngest Salesforce MVP in the world who firmly believes in providing value to the people and building long term value-based relationships. His mission is to disrupt the way professional technical services are delivered by bringing back the empathy for the end-user rather than being operational and transactional.
Shrey is popularly known as Salesforce Hulk in the Salesforce ecosystem as he was the first one to start creating videos on Salesforce on his TH-cam channel named as Salesforce Hulk and that too at the age of 19. Shrey is also the founder of S2 Labs which is a Salesforce Training Company, being the 1st one to start Salesforce training in Rajasthan, India, and currently selling his courses worldwide. Shrey is also a marvelous speaker who actively presents on topics that revolve around Salesforce and Entrepreneurship in various worldwide conferences. Shrey has also been a Judge in multiple technical and business hackathons organized by the Government of India like Smart India Hackathon.
Shrey is a leader with out of the box thinking who emphasizes not only on hitting the sales targets but also on providing an amazing experience to the customers as well as employees. Shrey believes in building a team with strong values, ethics, and behavior which leads to the amazing culture at Cyntexa.
------
STALK ME ON:
Instagram: / ​
Facebook: / ​
Twitter: / iamshreysharma​
LinkedIn: / imshreysh​. .
#salesforce #salesforcehulk #salesforceOhana #ohana #trailblazercommunity #trailblazer #trailhead #salesforcedevelopers #lockdownLearning #day2

[@revanthkumar6735]

Thank you Shrey

[@latarishabh]

Really very useful... Thanks Shrey

[@swaathikr6923]

Hi Shrey, Kindly give us some updates regarding PD1 certification contents.

[@harshpanchamiya6533]

Answer to the Challenge:
Answer to 1st question:
List agg = [select SUM(Amount),CALENDAR_YEAR(CreatedDate)
from Opportunity
where (Amount != null) AND
(StageName ='Closed Won' OR StageName ='Closed Lost')
AND OwnerId= :UserInfo.getUserId()
Group by CALENDAR_YEAR(CreatedDate)] ;

for(AggregateResult a:agg)
{
System.debug('Sum= '+(Decimal) a.get('expr0'));
System.debug(' Year= '+(Integer)a.get('expr1'));
}
Answer to 2nd question:
public static void fun2 (String firstDate,String SecondDate){
Date one = Date.valueOf(firstDate);
Date two = Date.valueOf(SecondDate);
List lst = [Select o.Name,o.CloseDate from Opportunity o
where o.CloseDate > :one
AND o.CloseDate < :two
AND o.Owner.FirstName='Saurman'
AND o.Owner.LastName='D\'souza' ];
for(Opportunity opp :lst)
{
System.debug(opp);
}
}

[@shreyachoithani3334]

Hello Shrey,
Thank you for the initiative!
I am a Salesforce Certified Admin (2X). So these videos will be very helpful for me to start learning development.
I have a doubt on one of the topic - SOQL Variable Binding.
In the end why did we System Debug the conlist2 with the index 0?
Than you!

[@rajeshshaw2002]

So that we can print the details of first index of conlist2 . The list can have more than one records but here we are printing only first record.

[@vinayakwalhe9130]

Start from 3:11

[@anandkapkar7156]

Bro i m waiting for this topic.... Thnks.

[@shubhamrahud9211]

Hii Could upload video about design multiple assessments by configuring assessment questions.

[@rajeshshaw2002]

Hi Shrey, can you please dive little deeper into these topics .It would be a great help for all of us.

[@yuvrajsinghshekhawat7146]

Hi, I am waiting for SOQL challange, and I am very excited to win Salesforce hulk t-shirt 😊 .... please update challenge link.....

[@sflearner9388]

Challenge 1 : SOQL Answer
SOQL Assignemnet
Assignemnet 1:
String userid = userinfo.getuserId();
List agg = [SELECT SUM(Amount) ,CALENDAR_YEAR(CreatedDate)
FROM Opportunity
WHERE ownerId=:userid and (stagename='Closed won' or stageName='Closed Lost') group by CALENDAR_YEAR(CreatedDate)] ;
Map sumtoYear = new Map() ;
for(AggregateResult a : agg){
sumtoYear.put((Integer)a.get('expr1') ,(Decimal) a.get('expr0')) ;
}
System.debug('sumtoYear'+sumtoYear);
Assignemnet 2:
Public static void method2(date dateparam1,date dateparam2 )
{
List oppLst = [Select CreatedDate, Id, LastModifiedDate from Opportunity where CreatedDate >: dateparam1 and CreatedDate

[@ravinderkd]

Can anyone share Aman Pathak's answer for Day-2 Challenge here. I couldn't able to see his answer in comments

[@sruthinikomaragiri9291]

Hii shrey, can you start teaching Salesforce admin plz ..

[@SalesforceHulk]

Coming up a series for it. WIll be posted in 2 days

[@sheetalk7528]

Shrey can we have some salesforce videos with respect to testing and how can we automate tests for the business process. Thanks!

[@SalesforceHulk]

Will take this as the next topic!

[@phanikumar3335]

SOQL full form Salesforce Object Query Language sir

[@shreyagoyal2585]

SOQL1 -
SELECT SUM(Amount), FISCAL_YEAR(CreatedDate) FROM Opportunity WHERE IsClosed=true AND Ownerid=: UserInfo.getUserId() group by FISCAL_YEAR(CreatedDate)
SOQL2-
String ownername='Saurman D\'Souza'
SELECT Name FROM Opportunity WHERE CloseDate>=:firstDate AND CloseDate

[@lovefrommars7468]

Mic ka issue solve karo yar

[@SalesforceHulk]

Noted

[@farahghanem3387]

I loved your admin videos and learned alot from them .. but after watching this one i'm a little disappointed .. I thought it would have more details and examples .. even the trailhead module has more content than this one .. please work on this

[@SalesforceHulk]

Thanks for the feedback, Farah!
I will try to make these live sessions more detail in the available time that I have.

[@farahghanem3387]

Thank you sir

[@reflectionstillz]

Why does he go blank finding simple words ?

[@IgiveyouNONE]

what you mean?

[@revanthkumar6735]

Its a natural thing bro...Happens for some

[@shaliniyadav8393]

Y do u fumble so much 😄