Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
8 Hour(s) 15 Minute(s)
Language
English
Taught by
Robert Apollo | Senior PHP Developer
Rating
Course Overview
Master Laravel Query Builder and Eloquent ORM - the Most Important Things when building any Dynamic Web App in Laravel
Still not comfortable with Laravel PHP Framework?
Design and query database is probably the most difficult part of building database driven web applications. There are a lot of Laravel courses out there, but many students still feel like they are not good Laravel developers after completing that courses. One of the answer is, that courses do not teach database part enough. This course fills this gap. This course has more than 100 lectures and all of them are only about creating and querying databases in Laravel framework.
Check out the written comments on this course. This course has the most 5 star written ratings of all my courses!
Welcome to the very comprehensive Laravel Databases course. This course will teach you all you need to know to become a master at querying relational databases using Laravel framework. This course is the excellent training and is a must Laravel resource with lots of practical exercises about Laravel Query Builder and Eloquent ORM. After completing this course, you will be able to design robust Laravel database applications and query its databases.
This course consists of three main parts divided into 10 sections:
1. Theory with lots of practical and understandable examples about Laravel Query Builder and Eloquent ORM
2. Design and query blog database schema
3. Design and query hotel booking system database schema
(see curriculum for more details)
During the course, you will also learn about creating APIs and query its databases. You will learn a lot of very useful techniques to query databases very easily, including searching (also full text searching), sorting, filtering and pagination of database results. Also about creating indexes to boost performance of select queries, about creating custom models for pivot tables, query events, database table relationships and many other things (see curriculum).
The most interesting part of this course is to design and query database for hotel booking system (all tables optimized to third normal form - 3NF).
To better consolidate the acquired knowledge the course includes, in addition to lectures - quizzes, assignments and other practical activities.
For each lecture that requires coding, there are files resources that you can download and copy & paste, but I encourage you to write code from the screen.
I promise that you'll be a better Laravel developer after completing this course. And even if for some reason you will not like this course, Udemy always offers you a 30-day money back guarantee. But I doubt that you will not like it. I am 100% sure that you will be happy after completing this Laravel course!
Course Content
- 10 section(s)
- 102 lecture(s)
- Section 1 Introduction
- Section 2 Laravel Querying Databases - Getting Started
- Section 3 Laravel Query Builder
- Section 4 Laravel Eloquent ORM basics
- Section 5 Database table relationships using Eloquent ORM
- Section 6 Eloquent, Query Builder or raw sql on DB facade – which to use and when to use
- Section 7 Laravel & Redis Database
- Section 8 API Resources using Eloquent ORM and serialization
- Section 9 Laravel Database Project 1 – Simple blog
- Section 10 Laravel Database Project 2 – Hotel booking system
What You’ll Learn
- You Will Learn the Most Important and Most Difficult Part of Laravel - Querying Databases
- You will be the expert at querying databases using Laravel PHP framework
- You will learn and practice Laravel Query Builder
- You will learn and practice Laravel Eloquent ORM
- You will learn and practice Laravel raw database queries
- You will learn when to use each type of querying databases in Laravel
- You will learn how to optimize your database queries
- You will design and query databases for blog and hotel booking system
Skills covered in this course
Reviews
-
SStanley maliwa
Its an understandable course
-
KKire Geshoski
Great explanation of the essence of DB querying
-
SSaeesh Naik
not beginner friendly at all :(
-
AAndré Robillard
This is a good course covering the essentiel of Laravel queries. Even though this course was written in an older version of Laravel while the version 9 was out at the time I took this course, I could follow along with some minor adjustments. Good programmers should be able to adapt and find the information over the internet so this is what I did and I could follow the course with Laravel 9. The only minor negative comment I have is that examples used in the first part of the course are too close to the official Laravel documentation and were sometimes confusing. I think a better approach would be blend the Hotel example and base the entire course on that example. I would nevertheless highly recommend this course. Good Job!
