Mastering Laravel 10 Query Builder, Eloquent & Relationships

0

1

2

3

4

5

Posted on 08 Apr 06:00 | by mitsumi | 46 views

Mastering Laravel 10 Query Builder, Eloquent & Relationships
Published 4/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.24 GB | Duration: 7h 26m

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 ChangessDirty, 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