Introduction to the Query Builder - Laravel 9 Course for Beginners
Offered By: Code With Dary via YouTube
Course Description
Overview
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
Taught by
Code With Dary
Related Courses
Create an eCommerce Website Using Laravel (PHP & MySQL)Udemy PHP with Laravel for beginners - Become a Master in Laravel
Udemy Beginning Laravel 10 - From Novice to Professional (2023)
Udemy Laravel PHP Framework - Beginners
Udemy Learn Laravel 7 along with REST API & Livewire
Udemy