SOQL & SOSL

Introduction of SOQL & SOSL

Introduction of Queries traversing from Child to Parent Object

Introduction of Queries traversing from Parent to Child Object

Introduction of aggregate Queries

Introduction of Semi-Join & Anti-Join

Field Semi-Join & Anti-Join

Reference Semi-Join & Anti-Join