Apex Academy: SOQL and Working with Databases

Focused View

Scott Lee

1:17:39

9 View

1. Course Overview

1. Course Overview.mp4

01:36

2. Retrieving Data with Code

1. Overview.mp4

02:21

2. Looking at Salesforces Database.mp4

06:29

3. Apex Tools of Data - SObjects, SOQL.mp4

02:24

4. Demo - Installing the Course Examples.mp4

01:15

5. Anatomy of a SOQL Statement.mp4

03:04

6. Demo - Inserting Course Test Data.mp4

02:08

7. Demo - Running SOQL Queries.mp4

04:31

8. Designing within Limits.mp4

02:23

9. Summary.mp4

01:35

3. Practicing SOQL in Apex

1. Overview.mp4

01:11

2. Sorting, Ordering, and Grouping.mp4

03:03

3. Binding Variables in Code.mp4

01:46

4. Summarizing with Aggregate Queries.mp4

03:39

5. Demo - Constructing Your Own SOQL.mp4

05:54

6. Demo - Practice with Operators.mp4

02:35

7. Summary.mp4

00:59

4. Avoiding the Database (In Tests)

1. Overview.mp4

01:22

2. Why Avoid Queries Why Ensure Them.mp4

05:29

3. Introducing Dependency Injection.mp4

04:15

4. Demo - Writing Tests for Speed.mp4

03:37

5. Summary.mp4

01:58

5. Balancing for Limits

1. Overview.mp4

01:30

2. Considering Transaction Restrictions.mp4

03:32

3. Techniques for Bulkifying Triggers.mp4

01:26

4. Demo - Organizing for Bulk Loads.mp4

05:15

5. Summary.mp4

02:22

Description

Apex coding requires working with data to be most effective, including the power of SOQL queries. This course will teach you how to work with the Salesforce database and write SOQL.

What You'll Learn?

Using and managing data retrieved in SOQL is critical to Salesforce Apex programming. In this course, Apex Academy: SOQL and Working with Databases, you’ll learn to write and utilize SOQL while managing governor limits. First, you’ll explore writing SOQL queries. Next, you’ll discover writing practical tests, including avoiding database activity in Apex tests for deployment performance. Finally, you’ll learn how to balance Apex work for bulkification and avoiding governor limits. When you’re finished with this course, you’ll have the skills and knowledge of Apex SOQL data management needed to work with data in Apex using best performance and quality practices.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Salesforce Development

Scott Lee

Instructor's Courses

Scott is the CEO of Elega Corporation, a videogame developer and educational content creator, and a Salesforce architect in the energy industry. He has produced business applications as a professional programmer for a decade across industries including litigation support, renewable energy, and natural gas using programming languages such as Python, Rust, C#, and database technologies. Under Elega Corporation, Scott is the lead designer and programmer on their city management game, Kalling Kingdom, first released in 2019. His formal education is in behavioral science with a BS in psychology and sociology from the University of Houston.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.