Name: Learn Mysql with Node JS from Joe Santos Garcia
Brand: Tenlibrary
SKU: LMWNJFJSG
Availability: InStock

$100.00

Learn Mysql with Node JS from Joe Santos Garcia

Sale page

You will receive this product within 24 – 48 hours after payment

SKU: LMWNJFJSG Category: Everything Else Tags: Joe Santos Garcia, Learn Mysql with Node JS, Learn Mysql with Node JS from Joe Santos Garcia

Learn Mysql with Node JS from Joe Santos Garcia

Sale page

Great for those if you guys are looking to become fullstack developers.

Now even if you don’t want to become a fullstack developer you need this course because you will learn how to create an API that connects to the front end through react. So to make the story short… This is what you will learn

1.MYSQL

2. Node JS – Backend

3. Adonis JS – Backend Framework

4. React JS – Front End Framework

5. REST

6. Build a Inventory Management System

Course Curriculum

Introduction

Mysql

Creating database (4:26)

creating a table with columns and rows (10:16)

Column types (8:26)

column settings (6:01)

Alter Tables and Columns (10:25)

Insert Data in Tables (9:24)

Cleaning up and adding new data (17:49)

Cleaning up and adding new data part 2 (14:50)

SELECT DATA (14:13)

Logical Operators (20:14)

MYSQL Functions part 1 (16:49)

MYSQL Functions part 2 (9:26)

Relationships

Organizing our data through relationships (1:37)

One To One: When to use one to one relationship (3:20)

One to One: Build our tables for one to one relationships (21:52)

One to One: Create data for one to one relationship (6:06)

One to One: Query through one to one relationships (3:44)

One to Many: Creating data for one to many relationships (2:06)

One to Many: One to Many: relationships cross and inner joins (13:28)

PAUSE: SQL JOINS DIAGRAM (4:51)

Changes to database to try left right full joins (3:17)

One to Many: Left, Right, Full, Outer Joins (12:44)

Many To Many: When to use a many to many relationship (2:30)

Many To Many: create tables and insert data for many to many relationships (5:35)

Many To Many: Association between books and tags (1:54)

Many To Many: Read data from a many to many relationship (4:39)

Many To Many: Update many to many association table (4:44)

Many to Many: DELETE Many to Many association (9:52)

Inventory Management System

What we will be building in this project (6:32)

Create our first routes for products (8:05)

create our first layout and page for products (11:05)

Create partials for the layout (4:24)

show all products table layout (6:06)

Setting up the create show edit (8:59)

Create the user table (11:36)

create the products and brands tables (18:58)

Create the orders and items tables (17:25)

MAKING MISTAKES FOR YOU TO LEARN (28:54)

Edit the left Menu (6:12)

Edit left menu part 2 (6:22)

Products

Create new product form view (19:21)

Inserting New Products (30:03)

Stoping SQL Injection (9:09)

Display all products (21:10)

Inner Join 3 tables for brands and users (13:05)

Add image_url to products table (8:14)

Build the view of the show page (29:27)

Logic for the show product page (13:09)

Pass Data to Edit Page (13:45)

Logic to Edit Products (12:48)

Delete a Product (5:35)

Brands

Duplicate what we did on products (12:24)

Logic to show all brands (7:53)

Add Img Url Column To Brands Table (6:27)

Insert Brand to Brands Table (9:21)

Edit and update brand (6:17)

View the brand show page (6:26)

Delete a Brand (2:41)

Dynamically Fill The Products Form with Brands (27:54)

orders

Setting up to work on the orders (7:43)

Getting our Starter Kit Inside Adonis JS (17:48)

adding new to things to create page (33:30)

adding new things to create page part 2 (12:52)

Converting html to jsx (9:14)

Working with forms in React (19:59)

Using packages for state and countries lists (16:44)

Make the popup visible (17:51)

Setting up api for products (23:45)

Add items to order in the front end (18:45)

Display all item (15:40)

Remove item from order (7:49)

submitting our data to the backend (16:15)

Insert our order (15:12)

Insert Items to table (21:47)

Validation in the front end (18:54)

Errors and Redirects after submit (12:37)

Displaying all orders (18:58)

displaying all orders part 2 (15:40)

Working the front end of the show page (26:11)

Display Data on Show Page (22:49)

Fixing bugs (34:36)

adding images to our orders (8:37)

How to delete an order and challege your self to edit one (7:35)

Dashboard

Setting up for our dashboard (9:43)

Getting our data ready for our chart (14:41)

Displaying Charts (27:09)

Conclusion

Completed Files

Get immediately download Learn Mysql with Node JS from Joe Santos Garcia

Reviews

There are no reviews yet.

Be the first to review “Learn Mysql with Node JS from Joe Santos Garcia” Cancel reply

You must be logged in to post a review.

After receive your order, It will take 0-12 hours to be download available.

The Course is digital products included PDFs,Videos (MP4,TS,AVI files), Audio (MP3,M4A), Document (Word, Exel,Power Point..)

We will provide the download link accordingly with the Email address on your “Order Reciep”.

Contact Email : [email protected]
Skype : [email protected]