Master Mysql, Javascript, Laravel 5.8 and e-commerce project

Learn to design a medium sized e-commerce database from scratch by dropping and recreating the main database, creating a counter table and a countries table, and planning relationships.

Create a products table for an e-commerce database with an auto-incrementing id, name, and a decimal price (10,2) defaulting to 0.00. Insert sample items and related categories.

Create orders and order_items tables with primary keys and foreign keys (user_id, order_id, product_id), enforcing a one-to-many relationship from user to orders and a many-to-many link via order_items.

Learn to retrieve each user's total orders and total order amount by joining users and orders, grouping by user id, and sorting results in descending order.

Master MySQL: learn to compute the total number of products per category using joins, group by, and count, and order results by the tally.

Learn to fetch each user's ratings count, ratings total, and ratings average by joining the users and ratings tables, using count, sum, and avg for admin user management.

Get the total amount and total number of orders for each month by grouping orders by order date, using a simple select and group by query.

Create views to compute monthly top products by average ratings, then join these views with the products table to identify the most popular product for each month.

Create and use database views to compute the best seller for each month by joining orders and order items, aggregating sold quantities, and identifying the highest monthly sales per product.

Learn how to retrieve the best order for each user by joining users and orders, grouping by user, and using having with max(order_total) to select the highest order.

Prepare a laravel 5.8 e-commerce app by installing with composer, configuring mysql, and setting public path; migrate, enable authentication with make:auth, run the local server, and create a test user.

Create the header by adding a header partial into the default layout and using bootstrap grid for a responsive logo and shop name.

Create and style a header for an e-commerce app with a multi-line navigation, including welcome sign-in, shop and categories links, and css tweaks for margins, font size, and bold items.

Explore building an e-commerce web app using a PSP logo, JavaScript, and a payment system, then implement header enhancements, router partial views, and social links.

build a repository structure for a Laravel 5.8 e-commerce app, implement a base brand repository with dependency injection, and insert single or multiple rows via a brand table migration.

Learn to implement data filtering and repository search in a Laravel JavaScript e-commerce app, with per-page paging and sorting by newest or oldest brands to fetch filtered data.

Master brands management in an e-commerce web app by implementing Ajax-driven CRUD on brands, configuring delete actions, and styling interfaces with CSS in a Laravel and JavaScript workflow.

Master brands management in an e-commerce app by building dropdown actions with JavaScript and CSS, adding select-all functionality, dropdown toggles, and styled menu items.

This lecture guides you through adding and debugging dropdown menus in an e-commerce web app using JavaScript helpers and event listeners to manage dropdown behavior.

Create a JavaScript request component using jQuery ajax to handle get, post, delete, and put calls, building form data for an ajax-like data table in an e-commerce app.

Learn to build an e-commerce web app with javascript and ajax form components, collect form data into a data object, validate fields, and send it to the server via ajax.

Create a JavaScript data list component for an e-commerce app, enabling Ajax insert, delete, and batch operations, with a data list class managing items, selection, and client or server deletes.

Create a dynamic data list component with pagination and link interactions. Capture click events, prevent defaults, and use AJAX to fetch JSON data, refreshers, clear all, and delete client items.