Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Laravel Query Builder
Rating: 4.6 out of 5(260 ratings)
11,409 students
Created byAli Shah
Last updated 6/2019
English

What you'll learn

  • 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

Course content

1 section • 8 lectures • 1h 42m total length

  • Introduction6:37

    Sakila database installation and setup

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

  • Understanding how to run a basic query and get results from database3:43

    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

  • Understanding different ways of using the WHERE keyword according to our needs8:37

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

  • Exploring different conditionals in query builder13:42

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

  • Understanding Joins in MySQL23:20

    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

  • Understanding subqueries28:12

    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

  • Understanding complex joins12:28

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

  • Handling subqueries within a query and then joining results6:17

    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

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

Report abuse