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
iOS Persistence and Core DataUdacity 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