Laravel Query Builder

Utilising Laravel's powerful query builder to do the heavy lifting while interacting with database
English
English [Auto]
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

Requirements

  • Basic understanding of MySQL
  • Basic familiarity with Laravel's Eloquent

Description

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.

Who this course is for:

  • Fullstack developers
  • PHP developers
  • Web developers
  • Backend Developers

Course content

1 section8 lectures1h 42m total length
  • Introduction
    06:37
  • Understanding how to run a basic query and get results from database
    03:43
  • Understanding different ways of using the WHERE keyword according to our needs
    08:37
  • Exploring different conditionals in query builder
    13:42
  • Understanding Joins in MySQL
    23:20
  • Understanding subqueries
    28:12
  • Understanding complex joins
    12:28
  • Handling subqueries within a query and then joining results
    06:17

Instructor

Lead developer & Web Technologies Enthusiast
Ali Shah
  • 4.5 Instructor Rating
  • 311 Reviews
  • 14,850 Students
  • 3 Courses

My web development journey kicked off when a friend of mine needed some help with his website. I still remember the pain that I went through while trying to change text and some images. However, I was completely mesmerised by the whole notion of instructing web browser to do as how i would instruct it .

It was around 2008 when i decided to pursue web development as a career. In contrast to lot of great self taught programmers, I took the traditional route of going to university and did my B.Sc ( Hons ) in Applied Computing. Since then I have never looked back and have only moved forward.

Programming and any thing web related is my passion and I have put endless hours in  acquiring the required theoretical and practical knowledge to get where I am.

My goal is to sum up the knowledge I have acquired over the years; break it down and teach others in simple English, hoping that some body out there might find it beneficial.