Mô tả

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! I do expect you to have knowledge in Laravel before starting this course, since we’re going to focus purely on databases and eloquent.


Tools we will be using

We 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.

Bạn sẽ học được gì

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

Yêu cầu

  • 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

Nội dung khoá học

9 sections

Course Introduction

3 lectures
Introduction
01:06
Course structure
02:02
Source code
00:52

Mastering Migrations

12 lectures
Project & database setup
05:38
Database configuration file
02:34
What are migrations and how do they work?
05:28
Creating our first migration
03:40
Column modifiers
04:38
Running migrations & different options
06:41
Squashing migrations
02:33
Modifying Columns
03:40
Renaming Columns
01:56
Dropping Columns
02:28
Migrations Cleanup
00:49
Chapter Quiz!
8 questions

Mastering Factories & Seeders

8 lectures
Factories vs Seeders - What is the difference?
01:15
Defining our first Factory
04:36
Using a Factory through a Seeder
03:01
Using a Factory through Artisan Tinker
01:21
Defining our first Seeder
06:46
Using a JSON file to read Data for our Seeders
04:14
Calling Multiple Seeders
00:55
Chapter Quiz!
7 questions

Mastering the Query Builder [PART 1]

14 lectures
Primary & Foreign Keys
06:19
Introduction to the Query Builder
06:28
First, Value and Find Methods
03:40
Retrieving a List of Column Values
00:44
Inserts Through the Query Builder
06:14
Insert & Get Id Through the Query Builder
01:20
Updating Through the Query Builder
06:36
Deleting Through the Query Builder
02:59
Aggregates Methods
03:28
whereNot & orWhereNot
02:30
Determining if Records Exist
01:49
whereBetween & whereNotBetween Methods
01:37
Debugging Through the Query Builder
01:58
Chapter Quiz!
9 questions

Mastering the Query Builder [PART 2]

15 lectures
Database Transactions
06:09
Pessimistic Locking
02:41
Chunking Data
02:43
Streaming Results Lazily
04:08
Raw Methods
03:36
Ordering Through the Query Builder
03:50
Full Text indexes
05:00
Limit & Offset Through the Query Builder
02:39
Conditional Clauses
02:15
Removing Existing Ordering
01:49
Chapter Quiz!
9 questions
Using the paginate() method
08:03
Using the simplePaginate() method
01:46
Using the cursorPaginate() method
04:18
Chapter Quiz!
8 questions

Mastering Eloquent ORM

20 lectures
Introduction to Eloquent
04:06
Eloquent Model Conventions
13:37
The $fillable And $guarded Properties
04:56
Building Queries
02:52
Retrieving Single Models
08:38
Inserting / Creating Models
05:13
Retrieving All Models
04:31
firstOrCreate & firstOrNew
04:34
Updating Models
03:50
Attribute Changes [isDirty, isClean, & wasChanged]
07:32
UpdateOrCreate & Upserting Models
04:15
Deleting Models
02:46
Soft Deleting Models
05:39
Pruning Models
02:43
Replicating Models
01:58
Global Scopes
07:45
Local Scopes
06:03
Dynamic Scopes
03:58
Using a Trait to store Scopes
02:08
Chapter Quiz!
18 questions

Mastering Relationships [PART 1]

9 lectures
What are Relationships?
01:32
One to One Relationship
14:14
One to Many / Belongs To Relationship
08:04
Many to Many Relationship
16:15
Eager Loading
02:44
Has one Through Relationship
08:24
Has One of Many Relationship
06:01
Has Many Through Relationship
07:14
Chapter Quiz!
6 questions

Mastering Advanced Relationships [PART 2]

6 lectures
What are Polymorphic Relationships?
01:17
One to One Polymorphic Relationship
10:00
One to Many Polymorphic Relationship
09:02
One of Many Polymorphic Relationship
02:41
Many to Many Polymorphic Relationship
07:00
Chapter Quiz!
4 questions

Create a Advanced Laravel Blog

14 lectures
Project Setup
01:53
Installing Laravel Breeze
03:17
Defining Migrations
08:30
Defining Models / Relationships
05:45
Creating Models, Controllers, Factories & Migrations
01:49
Inserting Data Using Factories & Seeders
09:58
Setting up Article Routes
04:13
Setting up The Frontend Pages
03:03
The index() Method
08:48
The show() Method
09:49
The create() & store() Methods
16:46
The edit() & update() Methods
12:19
The destroy() method
02:43
Using Policies For Unauthorized Users
04:42

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.