Laravel Database Queries – From Beginner to Highly Advanced

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome to the course. What and how we will learn

Lecture 2: Let's see Laravel database queries in action!

Lecture 3: Course structure

Lecture 4: How to benefit from these course as much as is possible

Lecture 5: How the course videos & resources look like

Chapter 2: Laravel Querying Databases – Getting Started

Lecture 1: Install Laravel and configure database settings

Lecture 2: Making raw SQL queries on DB facade

Lecture 3: Query events and transactions

Lecture 4: About database migrations

Lecture 5: Factories – generate dummy data for database

Lecture 6: Seeders – write data to the database

Chapter 3: Laravel Query Builder

Lecture 1: Getting results from the database: SELECT

Lecture 2: WHERE sql clause – part 1

Lecture 3: WHERE sql clause – part 2

Lecture 4: WHERE sql clause – part 3

Lecture 5: Pagination – show database results using subpages

Lecture 6: Full text search query

Lecture 7: Raw sql expressions

Lecture 8: Sql ORDER, GROUP, LIMIT, OFFSET clauses

Lecture 9: Conditional clauses & chunking results

Lecture 10: JOIN sql clauses: from simple to advanced queries

Lecture 11: UNION select clause

Lecture 12: INSERT statement

Lecture 13: UPDATE statement

Lecture 14: DELETE statement

Lecture 15: Pessimistic locking and debugging

Chapter 4: Laravel Eloquent ORM basics

Lecture 1: How to define and configure models. Optimized select queries on models

Lecture 2: Get single models and aggregates like count(), etc. Query scopes

Lecture 3: Collections & additional operations on Eloquent results

Lecture 4: Insert operations on models

Lecture 5: Update operations on models

Lecture 6: Delete operations on models

Lecture 7: Events on Laravel Eloquent queries

Lecture 8: Accessors – manipulate model properties when accessing them

Lecture 9: Mutators – manipulate model properties when saving them

Lecture 10: Cast attributes to other data format at query runtime

Chapter 5: Database table relationships using Eloquent ORM

Lecture 1: One To One database relationship

Lecture 2: One To Many database relationship

Lecture 3: Many To Many database relationship

Lecture 4: Has One Through database relationship

Lecture 5: Has Many Through database relationship

Lecture 6: One To One Polymorphic database relationship

Lecture 7: One To Many Polymorphic database relationship

Lecture 8: Many To Many Polymorphic database relationship

Lecture 9: Querying and counting database relationships (sql select)

Lecture 10: Querying and counting polymorphic database relationships (sql select)

Lecture 11: Insert/update/delete related models

Lecture 12: Create custom model for pivot table for many to many relationship

Lecture 13: Lazy and eager loading of models

Chapter 6: Eloquent, Query Builder or raw sql on DB facade – which to use and when to use

Lecture 1: Compare performance of three types of Laravel database queries and when to use t

Lecture 2: When to use raw database expressions in Laravel

Chapter 7: Laravel & Redis Database

Lecture 1: Install PhpRedis extension and Redis server

Lecture 2: Redis database usage using Laravel

Chapter 8: API Resources using Eloquent ORM and serialization

Lecture 1: Serialize eloquent model to array or json

Lecture 2: Resources and resource collections

Lecture 3: Include related resources (models) in JSON response

Lecture 4: Paginate JSON response and additional metadata of the response

Chapter 9: Laravel Database Project 1 – Simple blog

Lecture 1: Install and configure Laravel 7 and configure database connection

Lecture 2: Design database and create Post model and One To Many relationship

Lecture 3: Create Comment model and One To Many relationship

Lecture 4: Create Category model and One To Many relationship

Lecture 5: Create Tag model and Many To Many relationship with Post model

Lecture 6: Database queries for showing data on the main page – part 1

Lecture 7: Database queries for showing data on the main page – part 2

Lecture 8: Database query for showing data on the main page – part 3

Lecture 9: Queries for one post only, tag and category with the list of posts

Lecture 10: Search for blog posts in standard way – LIKE operator

Lecture 11: Search for blog posts using FULLTEXT index

Lecture 12: Sort database results by columns from the same table. Paginate results

Lecture 13: Sort (order) by related models

Lecture 14: Refactor the code from the previous step

Lecture 15: Filter blog post results by a user

Lecture 16: Filter blog post results by comments

Lecture 17: Create plain indexes on columns. Use raw sql on DB facade

Lecture 18: Create, update, delete blog post and post comment – write eloquent operations

Lecture 19: Update blog post’s related models – category and tag

Chapter 10: Laravel Database Project 2 – Hotel booking system

Lecture 1: Install and configure Laravel 7 and configure database connection

Lecture 2: Design database. Create first models, factories and seeders

Lecture 3: Create Hotel model and seed database with dummy data

Lecture 4: Create Room model and seed database with dummy data

Lecture 5: Create RoomType model and seed database with dummy data

Lecture 6: Create seeder for User model and populate database with dummy user data

Lecture 7: Create Reservation model and many to many relationship with Room model

Lecture 8: Create pivot (intermediate) table for Reservation and Room models

Lecture 9: Get reservation items that match date range from the database. Paginate results

Lecture 10: Eloquent style query to get date based matching rooms

Lecture 11: Search available rooms by city_id column of related table

Lecture 12: Join additional model and prevent overbooking

Lecture 13: Sort collection of rooms

Lecture 14: Filter collection of rooms by room size