4.5 out of 5
4.5
34 reviews on Udemy

Laravel Query Builder

Utilising Laravel's powerful query builder to do the heavy lifting while interacting with database
Instructor:
Ali Shah
3,854 students enrolled
English [Auto-generated]
Learn how to use Laravel's Query Builder
Understand MySQL queries
Learn how to translate raw sql queries into query builder
Understand main concepts around MySQL
MySql subqueries
MySql join and sub joins using query builder

In this course, we will go through Laravel’s query builder together and understand how to fully utilize its power. We will be working with “sakila” sample database where we will write raw sql queries and then we will translate those raw queries using query builder. By the end of this course, you should be more than comfortable with query builder to use it in any of your project or at your work.

Introduction

1
Introduction

Sakila database installation and setup

https://dev.mysql.com/doc/sakila/en/sakila-installation.html

2
Understanding how to run a basic query and get results from database

In this lesson, we will run basic sql query to get some records from database and then we will translate that query using query builder

3
Understanding different ways of using the WHERE keyword according to our needs

In this lesson we will have a look at keyword WHERE and how it works

4
Exploring different conditionals in query builder

In this lesson we will explore different ways of writing conditionals in query builder

5
Understanding Joins in MySQL

In this lesson, we will briefly touch on joins and how joins work. Then we will write a multiple join query to get the results. Then we will build same query using query builder

6
Understanding subqueries

In this lesson, we will look at keyword like and will also run a subquery to get some results. Then we will build the same query using query builder

7
Understanding complex joins

In this lesson we will build a query using joins along with subquery to get results

8
Handling subqueries within a query and then joining results

In this lesson, we will build a complex query using couple of sub queries and then we will stitch the results to get desired data from database

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.5
4.5 out of 5
34 Ratings

Detailed Rating

Stars 5
15
Stars 4
15
Stars 3
3
Stars 2
1
Stars 1
0
da85a54d96a88c46c48ea97b1b78a1c9
30-Day Money-Back Guarantee

Includes

2 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion
Skip to toolbar