Laravel Database Queries - From Beginner to Super Advanced
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
Course content
- Preview02:16
- Preview02:51
- Preview02:27
- Preview03:57
- 02:05How the course videos & resources look like
Requirements
- PHP and object oriented programming
- Laravel at basic level
- Composer installed
- Server environment installed (like Xampp)
- Internet connection
Description
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 this courses. One of the answer is, that courses do not teach database part enough. This brand new 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.
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!
Who this course is for:
- Everyone who wants to master database queries using Laravel PHP framework
- Everyone who feels uncomfortable when creating database driven web apps in Laravel
- Everyone who wants to practice database queries in Laravel by querying blog and booking system databases
- Everyone who wants to learn how to create API's in Laravel framework
Instructor
![Symfony, Laravel & PHPUnit Stuff](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.2 Instructor Rating
- 1,454 Reviews
- 21,077 Students
- 9 Courses
My name is Robert. I am a passionate full-stack web developer with many years of experience in web industry. I have created/participated in many web applications and websites, as well as hybrid mobile applications, mainly for interactive agencies and individuals. I have extensive development experience in the PHP technology including strong architecture and coding skills. I love to work on complex and business-critical tasks.
Here on Udemy I publish premium courses/tutorials on how to build modern web applications. My methodology is teaching through engineering and showing non-standard solutions. Currently I focus on PHP, Symfony, Laravel, web and hybrid mobile applications.
There is no the only right and the best technology for me. And the reason for that is very simple: programming is thinking, not a specific programming language or tool. The same problem can be solved using many languages or tools with the same effect.
Since a short time ago, I've also been sharing my knowledge and experience by writing on a blog and creating online courses.