Introduction to the Query Builder - Laravel 9 Course for Beginners

Explore the powerful Query Builder in Laravel through this comprehensive 25-minute video tutorial. Learn how to efficiently interact with databases using Laravel's DB Facade, covering essential operations like selecting, inserting, updating, and deleting data. Master various method chaining techniques including get(), select(), where(), whereBetween(), whereIn(), distinct(), orderBy(), and more. Discover how to optimize your database queries with skip(), take(), inRandomOrder(), and aggregation functions. Perfect for beginners and intermediate developers looking to enhance their Laravel skills and streamline database operations in their PHP applications.

Syllabus

- Introduction
- Defining the DB Facade
- Selecting all values from a table
- Parameter binding
- Persisting data
- Updating data
- Deleting data
- Method chaining: get
- Method chaining: select
- Method chaining: where
- Method chaining: whereBetween
- Method chaining: whereNotBetween
- Method chaining: whereIn
- Method chaining: whereNull & whereNotNull
- Method chaining: distinct
- Method chaining: orderBy
- Method chaining: skip & take
- Method chaining: inRandomOrder
- Method chaining: first
- Method chaining: find
- Method chaining: count
- Method chaining: min, max, sum and avg