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

Master Mysql, Javascript, Laravel 5.8 and e-commerce project, available at $19.99, has an average rating of 4.3, with 245 lectures, based on 26 reviews, and has 191 subscribers.

You will learn about Design and development of an ecommerce web application from scratch Developing resusable PHP and JAVASCRIPT components Developing recommendation systems Integrating payment system to your web application Mysql from scratch Mysql 16 advanced queries will be implemented on e-commerce database This course is ideal for individuals who are This course targets intermidiate to advanced PHP developers or Those who mastered Laravel basics and now want to take their state of knowlede to higher levels or Developers who love to write real client and server code which is favorable to employers or Javascript learners who want to create object oriented reusable components such as toggles, modals, ajax forms… or Those who want to learn Mysql or Those who have learnt Mysql fundamentals and want to know how to write advanced queries It is particularly useful for This course targets intermidiate to advanced PHP developers or Those who mastered Laravel basics and now want to take their state of knowlede to higher levels or Developers who love to write real client and server code which is favorable to employers or Javascript learners who want to create object oriented reusable components such as toggles, modals, ajax forms… or Those who want to learn Mysql or Those who have learnt Mysql fundamentals and want to know how to write advanced queries.

Enroll now: Master Mysql, Javascript, Laravel 5.8 and e-commerce project

Summary

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

Price: $19.99

Average Rating: 4.3

Number of Lectures: 245

Number of Published Lectures: 245

Number of Curriculum Items: 245

Number of Published Curriculum Objects: 245

Original Price: $34.99

Quality Status: approved

Status: Live

What You Will Learn

Design and development of an ecommerce web application from scratch
Developing resusable PHP and JAVASCRIPT components
Developing recommendation systems
Integrating payment system to your web application
Mysql from scratch
Mysql 16 advanced queries will be implemented on e-commerce database

Who Should Attend

This course targets intermidiate to advanced PHP developers
Those who mastered Laravel basics and now want to take their state of knowlede to higher levels
Developers who love to write real client and server code which is favorable to employers
Javascript learners who want to create object oriented reusable components such as toggles, modals, ajax forms…
Those who want to learn Mysql
Those who have learnt Mysql fundamentals and want to know how to write advanced queries

Target Audiences

This course targets intermidiate to advanced PHP developers
Those who mastered Laravel basics and now want to take their state of knowlede to higher levels
Developers who love to write real client and server code which is favorable to employers
Javascript learners who want to create object oriented reusable components such as toggles, modals, ajax forms…
Those who want to learn Mysql
Those who have learnt Mysql fundamentals and want to know how to write advanced queries

These are two courses in one. In First course – Mysql for beginners – You will learn Mysql from scratch and learn how to create and execute 16 advanced queries. In second course – Laravel & Javascript – You will learn how to create an advanced e-commerce web application with Javascript and Laravel 5.8. You will deal a lot with Javascript in this course. Get resources in latest lecture of each course.

In Mysql for beginners:

You will learn Mysql fundamentals

You will create a medium sized e-commerce database and it’s tables and you will learn relationships

You will prepare database with massive data and execute 16 advanced queries.

For Laravel & Javascript course:

The database for this course will be much more advanced in data and structure and we will entirely re-create it.

The most important features include:

Content management capabilities

Promotion and discount code tools

An easy to use checkout search engine optimized code and layout

Reporting tools.

Other features include:

Catalog management

Products management

Categories management

Discount and promotions management

Brands management

Content management

Orders management

Setting and reviews management

We will have following pages in our web application:

Home page

Category page

Products search page

Shopping cart page

Wish list page

Product details page

Product reviews page.

You will also learn how to implement a rating based item to item collaborative filtering recommendation system for both general and personalized recommendations. The course targets intermidiate to advanced developers but beginner developers who have learnt Laravel basics can use it too. To get full benefits from this course, it is recommended to take a basic Laravel course to learn fundamentals before diving in this course.

Course Curriculum

Chapter 1: Mysql for beginners – Fundamentals

Lecture 1: Introduction & Installation

Lecture 2: Create first database

Lecture 3: Create first table

Lecture 4: Analyse users table

Lecture 5: Add unique key and more columns to users table

Lecture 6: Retrieve data from users table with select command

Lecture 7: Learn how to delete users

Lecture 8: Learn simple and advanced ways of updating tables

Lecture 9: Learn foreign key and how to connect tables

Lecture 10: Learn how to join tables and get more complex data

Lecture 11: Learn how to use views for more complex queries

Chapter 2: Mysql for beginners – Create e-commerce datatabase and tables

Lecture 1: Create ecommerce database and countries table

Lecture 2: Create users table

Lecture 3: Learn one to many relationship

Lecture 4: Create categories table

Lecture 5: Create products table

Lecture 6: Create product_categories table

Lecture 7: Learn many to many relationship

Lecture 8: Create ratings table

Lecture 9: Create orders and order_items tables

Lecture 10: Create profiles table and learn one to one relationship

Chapter 3: Mysql for beginners – Complex queries

Lecture 1: Prepare database with massive data

Lecture 2: Get total number of users for each country

Lecture 3: Get total number of users and total amount of orders for each country

Lecture 4: Get total number and total amount of orders for each user

Lecture 5: Get total quantity of ordered products for each user

Lecture 6: Get each user ordered products with total sold count and total amount of pur…

Lecture 7: Get each user with ordered categories along with total sold count and total a…

Lecture 8: Get total number of products for each category

Lecture 9: Get total number and total amount of orders for each country

Lecture 10: Get each user's ratings count, ratings total and ratings average

Lecture 11: Get ratings count, ratings total and ratings average given to each product

Lecture 12: Get total number and total amount of orders for each month

Lecture 13: Get ten most popular products

Lecture 14: Get most popular product for each month

Lecture 15: Get ten best seller products

Lecture 16: Get best seller product for each month

Lecture 17: Get best order of each user

Chapter 4: Laravel & Javascript – Introduction

Lecture 1: Part 1. Introduction

Chapter 5: Laravel & Javascript – Preparing application

Lecture 1: Part 2. Preparing application

Chapter 6: Laravel & Javascript – Header and footer design

Lecture 1: Part 3. Header

Lecture 2: Part 4. Header

Lecture 3: Part 5. Header

Lecture 4: Part 6. Header

Lecture 5: Part 7. Footer

Lecture 6: Part 8. Footer

Chapter 7: Laravel & Javascript – User panel

Lecture 1: Part 9. Roles

Lecture 2: Part 10. User panel

Lecture 3: Part 11. User panel

Chapter 8: Laravel & Javascript – Introducing repositories and data filters

Lecture 1: Part 12. Repositories

Lecture 2: Part 13. Data filters

Lecture 3: Part 14. Data filters

Chapter 9: Laravel & Javascript – Brands management

Lecture 1: Part 15. Brands management

Lecture 2: Part 16. Brands management

Lecture 3: Part 17. Brands management

Lecture 4: Part 18. Brands management

Lecture 5: Part 19. Brands management

Chapter 10: Laravel & Javascript – Javascript reusable components

Lecture 1: Part 20. JS request component

Lecture 2: Part 21. JS ajax form component

Lecture 3: Part 22. Js ajax form component

Lecture 4: Part 23. JS ajax form component

Lecture 5: Part 24. JS list component

Lecture 6: Part 25. JS data list component

Lecture 7: Part 26. JS data list component

Lecture 8: Part 27. JS data list component

Lecture 9: Part 28. JS data list component

Lecture 10: Part 29. JS data list component

Lecture 11: Part 30. JS data list component

Lecture 12: Part 31. JS data list component

Chapter 11: Laravel & Javascript – More on brands management

Lecture 1: Part 32. Brands management

Lecture 2: Part 33. More methods for repositories

Lecture 3: Part 34. Brands management

Lecture 4: Part 35. Brands management

Lecture 5: Part 36. Brands management

Lecture 6: Part 37. Brands management

Chapter 12: Laravel & Javascript – Categories management

Lecture 1: Part 38. Categories management

Lecture 2: Part 39. Categories management

Lecture 3: Part 40. JS selectable list component

Lecture 4: Part 41. JS selectable list component

Lecture 5: Part 42. Categories management

Lecture 6: Part 43. Categories management

Lecture 7: Part 44. Categories management

Lecture 8: Part 45. Categories management

Chapter 13: Laravel & Javascript – Filters management

Lecture 1: Part 46. Filters management

Lecture 2: Part 47. Filters management

Lecture 3: Part 48. Filters management

Lecture 4: Part 49. JS modal component

Instructors

Danial Mohamadnejad
Programmer and developer

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 2 votes
4 stars: 6 votes
5 stars: 17 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu