Query Builder in Laravel
00:00:00 Introduction to Query Builder
00:02:40 Database Configuration
00:03:21 Retrieving All Rows from Table - table Method and get Method (Theory)
00:04:53 Creating Project
00:05:09 Download and Install XAMPP
00:05:56 Run Apache and MySQL
00:06:25 Opening phpMyAdmin
00:06:34 Create Database and Table
00:09:56 Mentioning Database Details in env file
00:10:44 Setting up Project
00:13:36 Retrieving All Rows from Table
00:18:12 Retrieving Single Row/Column from Table
00:19:19 first Method
00:21:03 where clause
00:22:22 value Method
00:23:10 find Method
00:24:14 pluck Method
00:26:28 chunk Method
00:30:55 Aggregates - count
00:32:08 max and min
00:32:57 Determining If Record exists
00:35:48 select Method
00:37:47 distinct Method
00:38:34 where Method
00:42:02 orWhere Method
00:43:38 whereBetween Method
00:44:47 orWhereBetween Method
00:47:03 whereDate Method
00:48:21 whereMonth Method
00:49:35 whereDay Method
00:50:30 whereyear Method
00:51:05 orderBy Method
00:52:46 latest and oldest Method
00:54:12 inRandomOrder Method
00:55:46 groupBy and having Method
00:57:10 Disabling mysql strict mode
00:58:00 take and skip Method
00:59:20 limit and offset Method
01:00:57 insert Method - Insert Data into Table
01:05:28 insertOrIgnore Method
01:07:24 insertGetId Method
01:08:58 update Method - Update Data into Table
01:12:47 updateOrInsert Method
01:18:50 delete Method - Delete Data from Table
01:19:46 truncate Method - Delete All Data from Table

Laravel Playlist:
   • Laravel 8 (Hindi)  

Core PHP Tutorials:    • Core PHP (Hindi)  

Advance PHP Tutorials:
   • Advance PHP (Hindi)  

PHP OSMS Project:
   • Online Service Management System PHP ...  

HTML Tutorials :    • HTML and HTML5 (Hindi)  

CSS Tutorials:    • CSS and CSS 3 (Hindi)  

SQL Tutorials:    • Structured Query Language - SQL (Hindi)  

Check Out Our Other Playlists:
   / geekyshow1  

Learn more about subject:
http://www.geekyshows.com/

________________________________________________

If you found this video valuable, give it a like.
If you know someone who needs to see it, share it.
If you have questions ask below in comment section.
Add it to a playlist if you want to watch it later.
________________________________________________

T A L K W I T H M E !
Business Email: [email protected]
Twitter:   / geekyshow1  
Website: http://www.geekyshows.com/
_______________________________________________

Make sure you LIKE, SUBSCRIBE, COMMENT, and REQUEST A VIDEO! :)
_______________________________________________