Mastering Laravel 10 Query Builder, Eloquent & Relationships

From ZERO to Hero Using Migrations, Factories, Seeders, Query Builder, Eloquent ORM, Relationships & Polymorphism!

What you'll learn

Laravel's database configuration

Learn to work with Migrations

Learn how and when to use Seeders

Learn how and when to use Factories

Understand the Laravel Query Builder

Learn how to construct SQL queries using the Query Builder

Learn how to use the Query Builder to perform CRUD operations on the database

Understand how to use the Query Builder to build complex queries with conditional logic and dynamic filters

Laravel databases and Eloquent ORM

Learn how to use Eloquent to create, read, update, and delete records

Learn how to use Eloquent correctly to query data from the database

Learn how and when to use relationships

Learn how to use Eloquent to query polymorphic relationships

Learn Eager Loading vs Lazy Loading

Requirements

Understanding beginner topics in MySQL

How to set up a MySQL Database

Procedural Programming in PHP knowledge

Object-oriented PHP knowledge

Understand how the Laravel framework operates

Understand how the Model-View-Controller (MVC) framework works

Description

Are you struggling with Laravel databases and Eloquent? Do you want to learn how to easily manage your database with migrations and seeders? Look no further than Code With Dary's "Mastering Laravel Databases & Eloquent" course on Udemy! This comprehensive course covers the ins and outs of Factories, Seeders, Migrations, Query Builder, Eloquent, and relationships in Laravel 10. With Code With Dary's expert guidance, you'll learn how to efficiently manage your database and build powerful, scalable applications. Don't miss out on this opportunity to take your Laravel skills to the next level - enroll in "Mastering Laravel 10 Query Builder, Eloquent & Relationships" today!What is Laravel?Laravel is the go-to PHP web application framework for developers. With its extensive set of features and tools, Laravel enables developers to create web applications in a fast and efficient manner. One of the standout features of Laravel is its powerful database management system, which runs on top of the Eloquent ORM. Using Laravel and Eloquent, developers can seamlessly perform CRUD operations on the database, as well as execute complex queries with ease. Learning Laravel and Eloquent is a must for any PHP developer who needs to build modern, scalable web applications with confidence.Why is Laravel so popular?Laravel is popular because it provides developers with a powerful set of tools and features that make it easy to build modern, scalable web applications. It has a robust database management system that runs on top of the Eloquent ORM, which allows developers to easily perform CRUD operations on the database and execute complex queries. Laravel also has a large and active community of developers, which means that there are many resources available for learning and troubleshooting. Additionally, Laravel is easy to learn and use, which makes it a great choice for developers of all skill levels.Who is this course for?Some people may find Eloquent ORM difficult because it has a lot of features and can take time to fully understand. Additionally, working with complex relationships between database tables can sometimes be challenging. However, with practice and experience, developers can become proficient in using Eloquent to manage databases in Laravel applications. This course will teach you everything in depth about Laravel databases, Query Builder, and Eloquent!Tools we will be usingWe need to use a code editor for this task. It doesn't matter which one you use. I prefer using tools such as Ray from Spatie and Tinkerwell from BeyondCode. Both products are paid, but not required for this task. I use them in this course to make data outputting easier and to show you query speed, which can be compared to other queries.

Overview

Section 1: Course Introduction

Lecture 1 Introduction

Lecture 2 Course structure

Lecture 3 Source code

Section 2: Mastering Migrations

Lecture 4 Project & database setup

Lecture 5 Database configuration file

Lecture 6 What are migrations and how do they work?

Lecture 7 Creating our first migration

Lecture 8 Column modifiers

Lecture 9 Running migrations & different options

Lecture 10 Squashing migrations

Lecture 11 Modifying Columns

Lecture 12 Renaming Columns

Lecture 13 Migrations Cleanup

Lecture 14 Dropping Columns

Section 3: Mastering Factories & Seeders

Lecture 15 Factories vs Seeders - What is the difference?

Lecture 16 Defining our first Factory

Lecture 17 Using a Factory through a Seeder

Lecture 18 Using a Factory through Artisan Tinker

Lecture 19 Defining our first Seeder

Lecture 20 Using a JSON file to read Data for our Seeders

Lecture 21 Calling Multiple Seeders

Section 4: Mastering the Query Builder [PART 1]

Lecture 22 Primary & Foreign Keys

Lecture 23 Introduction to the Query Builder

Lecture 24 First, Value and Find Methods

Lecture 25 Retrieving a List of Column Values

Lecture 26 Inserts Through the Query Builder

Lecture 27 Insert & Get Id Through the Query Builder

Lecture 28 Updating Through the Query Builder

Lecture 29 Deleting Through the Query Builder

Lecture 30 Aggregates Methods

Lecture 31 whereNot & orWhereNot

Lecture 32 Determining if Records Exist

Lecture 33 whereBetween & whereNotBetween Methods

Lecture 34 Debugging Through the Query Builder

Section 5: Mastering the Query Builder [PART 2]

Lecture 35 Database Transactions

Lecture 36 Pessimistic Locking

Lecture 37 Chunking Data

Lecture 38 Streaming Results Lazily

Lecture 39 Raw Methods

Lecture 40 Ordering Through the Query Builder

Lecture 41 Full Text indexes

Lecture 42 Limit & Offset Through the Query Builder

Lecture 43 Conditional Clauses

Lecture 44 Removing Existing Ordering

Lecture 45 Using the paginate() method

Lecture 46 Using the simplePaginate() method

Section 6: Mastering Eloquent ORM

Lecture 47 Using the cursorPaginate() method

Lecture 48 Introduction to Eloquent

Lecture 49 Eloquent Model Conventions

Lecture 50 The $fillable And $guarded Properties

Lecture 51 Building Queries

Lecture 52 Retrieving Single Models

Lecture 53 Inserting / Creating Models

Lecture 54 Retrieving All Models

Lecture 55 firstOrCreate & firstOrNew

Lecture 56 Updating Models

Lecture 57 Attribute Changes [isDirty, isClean, & wasChanged]

Lecture 58 UpdateOrCreate & Upserting Models

Lecture 59 Deleting Models

Lecture 60 Soft Deleting Models

Lecture 61 Pruning Models

Lecture 62 Replicating Models

Lecture 63 Global Scopes

Lecture 64 Local Scopes

Lecture 65 Dynamic Scopes

Lecture 66 Using a Trait to store Scopes

Section 7: Mastering Relationships [PART 1]

Lecture 67 What are Relationships?

Lecture 68 One to One Relationship

Lecture 69 One to Many / Belongs To Relationship

Lecture 70 Many to Many Relationship

Lecture 71 Eager Loading

Lecture 72 Has one Through Relationship

Lecture 73 Has One of Many Relationship

Lecture 74 Has Many Through Relationship

Section 8: Mastering Advanced Relationships [PART 2]

Lecture 75 What are Polymorphic Relationships?

Lecture 76 One to One Polymorphic Relationship

Lecture 77 One to Many Polymorphic Relationship

Lecture 78 One of Many Polymorphic Relationship

Lecture 79 Many to Many Polymorphic Relationship

Section 9: Create a Advanced Laravel Blog

Lecture 80 Project Setup

Lecture 81 Installing Laravel Breeze

Lecture 82 Defining Migrations

Lecture 83 Defining Models / Relationships

Lecture 84 Creating Models, Controllers, Factories & Migrations

Lecture 85 Inserting Data Using Factories & Seeders

Lecture 86 Setting up Article Routes

Lecture 87 Setting up The Frontend Pages

Lecture 88 The index() Method

Lecture 89 The show() Method

Lecture 90 The create() & store() Methods

Lecture 91 The edit() & update() Methods

Lecture 92 The destroy() method

Lecture 93 Using Policies For Unauthorized Users

Laravel developers who want to sharpen their Query Builder and Eloquent skills.,Laravel developers who want to specialize the Query Builder.,Laravel developers who struggle with databases and Eloquent,Laravel developers who lack a strong understanding of relationships