Introduction to the Query Builder | Full Laravel 9 Course | Laravel For Beginners | Learn Laravel

This video will show you how to you could the query builder in Laravel – Want to learn the most popular PHP framework? Laravel makes your development process a lot easier without sacrificing your applications functionalities.

🔗 Useful links

📚 New Udemy Course

📲 Let’s plan a meeting

💌 Newsletter

🔥 Resources

🔗 Useful links

📋 Table of Content
00:00 - Introduction
01:25 - Defining the DB Facade
03:02 - Selecting all values from a table
03:58 - Parameter binding
05:34 - Persisting data
07:23 - Updating data
08:33 - Deleting data
09:14 - Method chaining: get()
10:30 - Method chaining: select()
11:19 - Method chaining: where()
13:40 - Method chaining: whereBetween()
14:32 - Method chaining: whereNotBetween()
14:49 - Method chaining: whereIn()
15:18 - Method chaining: whereNull() & whereNotNull()
16:26 - Method chaining: distinct()
17:44 - Method chaining: orderBy()
18:43 - Method chaining: skip() & take()
19:28 - Method chaining: inRandomOrder()
20:15 - Method chaining: first()
21:08 - Method chaining: find()
22:09 - Method chaining: count()
22:41 - Method chaining: min(), max(), sum() and avg()

#laravel #framework #php #laravel9

[elexis]

What extensions are you using for autocompletion and database preview

[BoLLo]

whats the benefit of using method chaining instead of writing conventional queries using the DB:: facade? Is it somehow more secure/faster, or is method chaining just a wrapper for "easier" usage?

[amanprasadoo]

In migrations chapter you should also teach about rollback particular table and updating migrations also.
It's very helpful as dev.

[radybmcs]

Could you do more on Eloquent function please

[VKMilling]

1 issue I did notice here is that the timestamp fields for created_at and updated_at were not populated when doing the insert query.