Content Of Laravel Database: Query Builder

• Introduction
• Retrieving Results
• Retrieving All Rows From A Table
• Retrieving A Single Row / Column From A Table
• Retrieving A List Of Column Values
• Chunking Results
• Aggregates
• Selects
  1. Raw Expressions
• Joins
  1. Inner Join Clause
  2. Left Join Clause
  3. Cross Join Clause
  4. Advanced Join Clauses
  5. Sub-Query Joins
• Unions
• Where Clauses
• Simple Where Clauses
• Or Statements
  1. Additional Where Clauses
  2. whereBetween
  3. whereNotBetween
  4. whereIn / whereNotIn
  5. whereNull / whereNotNull
  6. whereDate / whereMonth / whereDay / whereYear / whereTime
  7. whereColumn
• Parameter Grouping
• Where Exists Clauses
• JSON Where Clauses
• Ordering, Grouping, Limit, & Offset
• orderBy
• latest / oldest
• inRandomOrder
• groupBy / having
• skip / take
• Conditional Clauses
• Inserts
• Auto-Incrementing IDs
• Updates
  1. Updating JSON Columns
  2. Increment & Decrement
• Deletes

Pessimistic Locking