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 users table for the e-commerce database, with an id primary key, a unique name, and a country_id that serves as a foreign key linking to the countries table.

Explore the one-to-many relationship between countries and users in MySQL. See how country_id links users to countries and how primary and foreign key constraints enforce belongs to and has many.

Create a categories table to organize products into hierarchical categories such as electronics, computers, and laptops. Define a self-referencing parent_id foreign key with a unique name constraint and cascade delete.

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 the product_categories table to link products and categories via two foreign keys, establish a primary key, enforce a unique product_id and category_id pair, and enable a many-to-many relationship.

Learn how to implement a many-to-many relationship between products and categories using a pivot table with two foreign keys, and see how inner joins reveal linked items.

Create a ratings table to let users rate products in an e-commerce app, implementing a many-to-many link via user_id and product_id, with rating as enum 1–5 and cascade on delete.

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.

Create a profiles table and enforce a one-to-one relationship with the users table by adding a unique constraint on user_id and a foreign key with on delete cascade.

Drop and recreate the main database, then load a full data file from resources to seed it. Explore the categories, products, and ratings tables, noting parent_id relationships and subcategories.

Join the countries and users tables, group by country name, and count the number of users registered from each country.

Display each country with the total user count and total order amount by inner joining counters, users, and orders. Group by country for accurate counts and sums.

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.

Connect the users, orders, and order items tables. Group by user and sum order item quantities to reveal the total number of products ordered per user.

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

Get the total amount and total number of orders for each country by inner joining orders and users, then group by country and order by total.

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.

Learn to retrieve each product’s ratings count, ratings total, and ratings average, and load products with their price and rating metrics using group by product id.

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.

Learn to fetch the ten most popular products by joining products with ratings, ordering by average rating in descending order, and limiting results to ten.

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.

retrieve the 10 best seller products by joining products and order items, grouping by product, and summing quantities to compute total sold quantity and limit to ten.

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.

Build an e-commerce web app using MySQL, JavaScript, and Laravel 5.8, covering product listings, category hierarchy, search, filters, cart, checkout, coupons, and test-mode payments.

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.

Build an e-commerce header with a dynamic category search and Font Awesome icons, using PHP, Laravel, and JavaScript, while styling with form controls and preparing for categories table.

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.

Create a dynamic e-commerce header with a hoverable categories list, authentication-aware links for login and logout, and a styling setup to display the menu on hover.

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.

Learn to build an e-commerce application using PSP Laura Vail javascript and perfect money payment processing, including creating sections, integrating images, styling with future.css, and organizing categories and counts.

build a many-to-many relationship between users and rules by creating a rules table and a user_rules table, configuring migrations, models, and basic controllers in Laravel.

Create an account layout with a left sidebar and right main content using Laravel blade, including a sidebar partial and a main content view controlled by a route and controller.

Learn to build a Laravel-based admin panel with dynamic sidebar links, authentication and authorization, and a brand management module implementing create, edit, update, and delete operations.

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.

Discover data filters in a Laravel e-commerce app, using an abstract base filter and concrete brand, product, and category filters with the Eloquent builder.

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 MySQL, JavaScript, Laravel 5.8, and e-commerce project: implement brand management with a brand repository and data filters, including a brand filter subclass, Ajax, and per-page pagination.

Build an e-commerce web application using javascript and the perfect money payment system, with a focus on brands management, data tables, and ajax-driven data interactions.

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.

Build an ajax form component for an e-commerce app using Laravel, enabling delete and update actions via ajax, with file upload support and submission callbacks.

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.

Develop an ajax form component for an e-commerce app, using javascript and laravel, to display a success message after submission, clear previous messages, and render server errors beside inputs.

Learn to build a JavaScript list component for an e-commerce app with Laravel and perfect money, featuring add, remove, clear, first item, filter by attributes, and JSON conversion.

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.

Develop and attach an ajax delete form to each item with a submit callback, enable and disable delete actions, handle select box states, and retrieve item id via data attributes.

Learn to build a data list component in JavaScript for an e-commerce app, including insertion, AJAX requests, server responses, and refreshing the view.

Implement and update a data list component for an e-commerce web app, detailing data item elements, master and non-master items, on select behavior, select all, and initial selection handling.

Learn to build a data list component for an e-commerce web app, enabling client-side item deletion, server-backed submissions, and ajax form handling with search form integration.

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.

Part 31 teaches building a javascript data list component for e-commerce app, including a get objects function, a 16-byte random id, and a recursive compare objects utility with ignore attributes.