Login to your account

Username or Email *

Password *

Remember Me

Forgot your password?
Forgot your username?

Home
Courses
Projects
Challenge
Recap Quiz
Live Courses
Interview

Lesson: 38 | Implementing a Stateful Batch Apex to Aggregate Data

User Story
Code
Video

User Story

As a Salesforce Administrator, I want to use a Batch Apex class to calculate the total number of accounts and store the result in a new account record.

The organization requires a solution to count the total number of Account records in Salesforce and store this aggregate value in a newly created Account record. The solution should process records efficiently, handling large datasets using Batch Apex, and ensure the total is accurately calculated and stored.

Code

Apex Class:

global class BatchAccountStateFul implements Database.Batchable<Sobject>, Database.Stateful {
  public Decimal AR = 0;
  global Database.QueryLocator start(Database.BatchableContext bc) {
    String query = 'Select Id from Account';
    return Database.getQueryLocator(query);
  }
  global void execute(Database.BatchableContext bc, List<SObject> scope) {
    for(sobject s :scope) {
      AR+=1;
        
        
    }
  }
  global void finish(Database.BatchableContext bc) {
    Account ac = new Account(Name='Batch Apex Stateful');
    ac.AnnualRevenue = AR;
    insert ac;
  }
}

Apex Code (Execution):

BatchAccountStateFul objA = new BatchAccountStateFul();
Database.executeBatch(objA,10);

Video

Video does not exists.

Prev You need to login to have access to the quizzes. MARK THIS AS UNDERSTOOD Next

Mastered by 15 users.

Exercises

A. Administrator | Exercises (62 lessons)

01 | Brand Theme Settings

02 | Account number must be numeric

03 | Account Number must be 7 digits

04 | Account Site must not be blank

05 | Create Formula_Practice Object for Formula Field Practice

06 | Initials of a Contact

07 | Amount must have a value greater than 0

08 | Calculate the Account Score

09 | Account Number must be numeric and not blank

10 | Verify if a Field's Content Includes a Specified String

11 | Link to LinkedIn

12 | This record is not editable.

13 | Account number is required

14 | Date must be in the current year or in the future

15 | Annual Revenue must be between 0 and 100,000

16 | Billing Street, City and Country are Required

17 | Date must be in current year and month

18 | WebSite must have an extension of com or org

19 | A valid two country code is required

20 | Delivery Date: Max 14 Days After Close

21 | Validate Stage Name of the Opportunity Object

22 | Length of State

23 | A new case with an active account must be prioritized

24 | Phone Number Has International Format

25 | Remaining Days

26 | Close Date Must be Weekday

27 | Prevent Open Cases from Being Reset to New

28 | Amount must have a value greater than 0

29 | The End Date must be after the Start Date

30 | Case Origin cannot be edited

31 | Only admins can change account names

32 | Number must be a positive even number

33 | Invalid Billing State

34 | Invalid Teacher Email Address

35 | Future Birthdate Error

36 | Create Image Based on Rating Value

37 | Creating a Dynamic Validation Rule with Metadata Control

38 | Number must be a positive odd number

39 | Summer Business Hours

40 | Open Opportunities by Stage

41 | Monitor Email Field Changes on Contact Object

42 | Close Date Validation for New Opportunities and Date Changes

43 | Email or Phone Required

44 | Start date must be in the current month

45 | Calculating Sales Tax

46 | Website must end with org

47 | Add Global Login IP Range to System Administrator Profile

48 | Day of the Week

49 | Create Labor Day Holiday

50 | Salary Range Check

51 | Birthday Checker

52 | New Contact Welcome Email Template

53 | Formatted Date

54 | Configure Field Dependency for Industry and Product Interest on Account Object

55 | Length of Account Must be 8 Digits

56 | Calculating Age from Birthdate

57 | Invalid Primary Contact Update for Inactive Account

58 | CloseDate 15 days Ahead

59 | Opportunity Stage Name Order Validation

60 | Track Opportunity Close Date History

61 | Display Status Change Date/Time on Task Object

62 | Restrict Account Lookup to Active Accounts

B. Flow Builder | Exercises (69 lessons)

01 | Create a Contact

02 | Account Creation with Contact Addition

03 | Create a Case

04 | Create Account, Contact and Case

05 | Create New User

06 | Screen Flow | Create a New Case

07 | Create a New Account and Task

08 | Clone an Account

09 | Get the Total Number of Active Accounts

10 | Create an Account with multiple Contacts

11 | Update Rating when a Lead is created or updated

12 | Update Close Date to Monday If Saturday or Sunday Selected

13 | Create a Quiz Program

14 | Screen Flow | Email Template

15 | Screen Flow | Other Address as default value from Mailing Address

16 | Schedule Triggered Flow | Send Birthday Message

17 | Screen Flow Simple Addition with Flows

18 | Update the priority of new cases to high

19 | Set Time Base flow for Accounts

20 | Notify contacts of an account when the account is updated

21 | To create an account when a platform event is created

22 | Auto-Create Opportunities for Hot-Rated Accounts

23 | Automatic Task Creation for Missing Contact Information

24 | Account Case Priority Distribution Flow

25 | Email Notification for Deleted Closed Lost Opportunities

26 | Seamlessly Searching and Creating Accounts with Flow Builder

27 | Creating Automated Celebration Emails for National Holidays in Salesforce

28 | Purge COVID 19 Symptoms Survey

29 | User Verification Code for Salesforce Login

30 | Auto-Inactivation of Inactive User Accounts

31 | Update the case owner as the Account Owner

32 | Deactivate inactive Users

33 | Create a Contact Linked to Most Recent Account

34 | Notification Process for Web to Lead Creations

35 | Develop a Job Application Management App

36 | Mass Task Reassignment

37 | Send Follow-Up Email After Opportunity Creation

38 | Automating Case Escalation

39 | Automate Case Owner Update Based on Account Owner Changes

40 | Generate Credit Card Number with Flows using Apex Action

41 | Implement "Mass Delete" Flow for Account Management

42 | Managing Account Contacts with Max Contacts

43 | Automated Flow to Delete Inactive Accounts Older Than 30 Days

44 | Screen Flow to Display Account Details on Home Page

45 | Time-Off Request Flow

46 | Dependent Picklists

47 | Dynamic Record Lookup and Update

48 | File Upload with Notes

49 | Create a Form for License Allocation and User Creation

50 | Automate Opportunity Stage Email Notifications

51 | Automatically Assign Permission Sets to New Users

52 | Create SubFlow to Validate and Shorten String Length

53 | Delete Selected Contacts Button with Screen Flow

54 | Set Sequential Opportunity Close Dates Subflow

55 | Ensure Primary Contact Exists for Accounts

56 | Automate Deletion of Middle Accounts Based on Creation Order

57 | Create a Screen Flow for Filtering Accounts

58 | Create a Screen Flow to Display Accounts by Date Range

59 | Create a Screen Flow for Deleting API Logs

60 | Login Alert for Suspicious Activity

61 | Track Account Owner Changes

62 | Secure Account Cleanup Flow

63 | Auto-Extend Opportunity Close Date Based on Metadata

64 | Assigning and Tracking User Scores

65 | Notify Account Owners Based on Account Rating

66 | Restrict Case Creation for Accounts with Open Cases

67 | Assign Tasks from Inactive Users to Active Users

68 | Account Name Length Validation Flow

69 | Prevent Duplicate Contact Creation Based on Name and Birthdate

C. Apex Beginner | Exercises (78 lessons)

01 | User Login Form

02 | Check if a number is odd or even

03 | Generate Full Name

04 | Add two numbers

05 | Square Root of a Number

06 | Calculate the Area of a Triangle

07 | Generate a Random Number

08 | Convert Kilometers to Miles

09 | Opportunities within a Specific Amount Range

10 | Cube of a number

11 | Case Transformation of Mixed Casing in a String

12 | Accounts with Related Contacts

13 | Days of a Month

14 | Calculate the maximum of three integers.

15 | Sum of the elements of two Lists

16 | Sum of the numbers from 1 to 10

17 | The greatest element of a List

18 | Finding the Maximum Number in a List Using

19 | The average of the elements of a List

20 | Account-Contact Verification

21 | Accounts with Associated Contacts

22 | Accounts with Open Cases and Unclosed Opportunities

23 | Account and Case Connection

24 | Initializing a New Set

25 | Create a Map

26 | Create a List of Colors

27 | Iterate over a List

28 | Maps

29 | Convert a List to a Set

30 | Convert a Set to a List

31 | Days of a specific month and a year in words

32 | Multiplication Table

33 | Voter Eligibility Checker

34 | Which day did you born?

35 | How long have you been living?

36 | How many days are there in the current year?

37 | What is the sum of multiples of 7 between 1 and 1000?

38 | The sum of the Perfect Squares

39 | Check if a List of integers contains only odd numbers?

40 | Sum of all elements in integer array?

41 | Merge two Lists

42 | Is your name palindrome?

43 | Convert all the element to UpperCase

44 | Secure Password

45 | Average Annual Revenue by Account Rating

46 | Accounts with Related Cases

47 | Active Owner and Creator Accounts

48 | Accounts with Two or More Related Contacts

49 | Number Parity Checker

50 | Split Full Name into First and Last Name Variables

51 | Contact Lookup for Account Management

52 | Opportunity Tracking for Sales Forecasting

53 | High Priority Case Management

54 | Lead Conversion Tracking

55 | Account Lookup by Email

56 | High-Value Opportunity Tracking

57 | Sales Lead Tracking

58 | Inactive Account Monitoring

59 | View Comprehensive Information about Accounts and Related Records using SOQL Query

60 | View Cases for Accounts Starting with "Bank"

61 | Advanced Account and Contact Search

62 | Account Health Check

63 | Opportunity Pipeline Report

64 | Upcoming Opportunities

65 | Identify Accounts with Contacts and No Closed Opportunities or Cases

66 | Identifying Even Numbers in a List

67 | Calculating and Displaying Megan's Age

68 | Create Random American Named Contacts in Salesforce

69 | Email Address List Conversion

70 | Bulk Update Account Ratings

72 | Creating a New Automated User

73 | Account and Contact Generation

74 | Month Name to Numeric Representation Conversion Utility

75 | Retrieve Accounts with Related Contacts and Cases

79 | Mass Update of User Roles to Null

Discount Calculator

Grade Converter

Simple Number Checker

D. Apex Intermediate | Exercises (97 lessons)

01 | Sum of the numbers from 1 to 10

02 | Create 100 Accounts

03 | School Grading

04 | Max Integer

05 | Create a Lead Trigger that updates the value of Rating

06 | Create a trigger which updates the description of the related opportunities of an account...

07 | Update Description when an Account is created or updated

08 | Update Account's Billing Country as USA for America or AMERICA values

10 | Automatically Copy Mailing Address to Other Address When "Mailing Address Is Same As Other...

100 | Automatically Adjust Opportunity Close Dates Based on a Custom Range

101 | Scheduled Batch Update for Account Annual Revenue

102 | Update Account Ratings Based on Closed Case Count

103 | Preventing Multiple Open Cases for an Account

11 | Create List With Method and Parameters

12 | Set Lead Source to Web Upon Opportunity Creation or Update

13 | Automatically Set Opportunity Lead Source and Type

14 | Mandatory Type Field for Opportunities

15 | Student Management System

16 | Account Name Validation on Creation

17 | Unique Email

18 | Account Name can not be changed

19 | Concatenate two fields

20 | Update billing country to USA if entered as America

21 | Create a trigger that determines if the account name has changed

22 | Create a contact related to Account if Create Contact Field is Checked

23 | Update the description of the related opportunities of an account

24 | Prevents users to delete Accounts with related opportunities

25 | Create an Opportunity related to Account Object

26 | Update Annual Revenue

27 | Prevents users to change Stage Name of Won and Lost Opportunities

28 | Avoid deletion of the account with a contact

29 | Prevent users to create an opportunity with an existing name

30 | Future Method Example 01

31 | Future Method Example 02

32 | Apex Scheduler Example

33 | Update Contact Description Upon Insertion or Update

34 | Prevent Deletion of Closed Won Opportunities

35 | Create Opportunity On Lead Conversion

36 | Batch Apex | Delete Records

37 | Batch Apex | Update Records

38 | Implementing a Stateful Batch Apex to Aggregate Data

39 | Batch Apex | Inactive Account Deleter

40 | UpdateAccountBillingAddress

41 | Delete Inactive Accounts

42 | Send New Year Message

43 | Debug the number of Deleted Accounts

44 | Update description when the Name of an Account is updated

47 | Update Phone Number of the Contacts when an Account is updated

48 | Prevent Duplicate Contact Creation

49 | Animal Sound Simulator

50 | Prevent Account Deletion

51 | Updating Last Contact Date on Account When Contacts Are Added or Updated in Salesforce

52 | Automatically Set Case Status and Priority for Email-Originated Cases

53 | Automatically Set Lead Rating Based on LeadSource

54 | Automatically Create Associated Contact Record for New Account

55 | Automatically Create Associated Contact Record for New Consulting Account

56 | Automatically Create Multiple Contact Records Based on Number of Contacts Specified on Account...

57 | Update Account with Latest Opportunity Amount

58 | Update Opportunity Stages on Account Deactivation

59 | Prevent Deletion of Active Accounts

60 | Restrict Editing of Closed Opportunities

61 | Validation rule to require Closed Lost Reason on Opportunities

62 | Restrict Account deletion to System Administrators only

63 | Prevent Deletion of Closed Opportunities

65 | Update Contact Owner When Account Owner Changes

66 | Preventing Duplicate Contact Records Trigger

67 | Deleting secondary contacts with a batch apex class

68 | Account Trigger for Updating Related Contacts

69 | Auto-assign Task to Case Owner

70 | Email Alert for High Priority Cases

71 | Notify User on Info Modification

72 | Schedule a daily Apex job to notify users on company holidays

73 | Prevent creation of new Account records outside of business hours

74 | Phone Number Formatting

75 | Vehicle Inventory Management

76 | Expense Tracking Application

77 | Set default value for Opportunity Type field as New Customer when left blank

78 | Constructor Example

79 | Interface Class

80 | Interface Class

81 | Random Stage Name Generator

82 | Deactivate System Administrator after 30 days inactivity

83 | Eliminate Duplicate Integers from a List

84 | Switch | Date Utility - Convert Month Name to Number

85 | Switch | Shipping Cost Calculator

86 | Empowering Account Owners in Salesforce

87 | Update Account Annual Revenue Based on Opportunity Amount Summaries

88 | Update Account Contacts Summary Fields

89 | Automated Phone Number Retrieval and Case Creation for Accounts with Missing Phone Information

90 | Update fields when an Account is created.

91 | Automated Test Data Entry

94 | Create Person Account for Each Contact

95 | Prevent Duplicate Contacts in the System

96 | Convert 24-Hour Time to 12-Hour Format

97 | Account Merge Utility

98 | Create Duplicate Accounts Dynamically Based on Existing Records

99 | Create Apex Method to Validate and Shorten String Length

E. Integration | Exercises (6 lessons)

01 | Retrieve List of Animals from Remote Server using HTTP GET Request

02 | Add a New Animal to Remote Server using HTTP POST Request

03 | Customer Contact Creation

04 | Lead Creation from Customer Information

05 | Create Salesforce Accounts, Contacts, and Cases from External API Data

06 | Create an API to Add Account Data with Related Child Records

F. Lightning Web Component (LWC) Exercises (14 lessons)

01 | Hello World

02 | Area of Triangle

03 | Interactive Addition Calculator

04 | Fetch Contacts Via Apex (Filter by Number)

05 | Mortgage Calculation

06 | Registration Form

07 | Event Booking Form

08 | Create an Opportunity

09 | Hotel Booking

10 | Login Form

11 | Fetch Closed Opportunities

12 | Search Account

13 | Search Accounts (2nd Way)

42 | JavaScript Methods

Go to top