YoVDO

Introduction to the Query Builder - Laravel 9 Course for Beginners

Offered By: Code With Dary via YouTube

Tags

Laravel Courses Database Management Courses Data Persistence Courses

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

iOS Persistence and Core Data
Udacity
Accediendo a la nube con iOS
Tecnológico de Monterrey via Coursera
SAP HANA Cloud Platform Essentials
SAP Learning
Developing Android Apps
Udacity
SAP Cloud Platform Essentials
SAP Learning