|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/soql-in-salesforce-crash-course/
课程评论：没有评论
**Salesforce SOQL 快速入门课程总结** 本课程旨在帮助学员掌握 Salesforce 对象查询语言（SOQL），这是与 Salesforce 数据库交互的核心语言，也是开启开发者之旅的重要基石。SOQL 基于 Oracle，并与 SQL 高度相似。 **课程主要内容：** * **SOQL 基础：** * 什么是 SOQL？ * 为什么需要 SOQL？ * SOQL 与 SQL 的关系（SOQL 是 SQL 的扩展）。 * 使用 Developer Console 构建基础 SOQL 查询。 * **SOQL 中的运算符与子句：** * AND, OR, NOT, LIKE * ORDER BY, GROUP BY, HAVING * LIMIT, OFFSET, WHERE * **SOQL 用例与技巧：** * 在 SOQL 中使用 NULL 值。 * 使用转义字符。 * 使用日期特定过滤器。 * 从父对象查询子对象信息。 * 从子对象查询父对象信息。 * **最佳实践与性能：** * 编写高效 SOQL 查询的最佳实践。 * 了解 Salesforce 的 Governor Limits 对 SOQL 的限制。 * **实践与巩固：** * 通过 9 个实际用例深入理解查询结构和编写技巧。 * 通过趣味测验游戏检验学习成果。 本课程致力于为学员提供一个扎实的 SOQL 学习机会，加速学员的 Salesforce 开发者之旅。
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 discuss 9 practice use cases to understand the query structure and writing them effectively.We 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.
