Chod Matrix > Development > Database Design & Development > Intro To MySQL With Node.js – Learn To Use MySQL with Node!

3.75 out of 5

134 reviews on Udemy

Intro To MySQL With Node.js – Learn To Use MySQL with Node!

Learn MySql Database With Node.js and Javascript The Fast and Easy Way!

Instructor:

John Elder

4,266 students enrolled

English [Auto]

Understand how to use MySQL Databases With Node js

Understand the basics of what a Database can do.

Install Node, MySQL, Git Bash, Wamp, and MySQL module

You'll Learn How To Create a Database and Table

How to put data in and take data out using Node and Javascript

How to update and delete data from the database

How to explore what's in the database whenever you want

How to create basic reports with the data from your database

These days everything uses a database, and MySQL is one of the most popular databases out there. FREE and Open Source, Mysql is a great database for just about all your needs.

Likewise, Node.js is one of the most popular and powerful web development platforms. Pairing the two together is a powerful combination!

In this course you’ll learn the basics of using MySQL with Node.js and Javascript.

You’ll learn how to create databases and tables, add data, sort data, create reports, pull specific data, and more.

For this courses I’ll assume you already have a basic knowledge of Javascript programming and Node, but you don’t need to know anything at all about databases or MySQL to take the course.

You’ll learn…

What Is A Database
How To Install Node
How To Install Git Bash Terminal
How To Download MySQL
How To Install Wamp and PHPMyAdmin
How To Install the MySQL Node Module
How To Connect to Database in Node
How To Explore MySQL With PHPMyAdmin
How To Create A Database
How To Create A Table
How To Insert One Record Into Table
How To Insert Many Records Into Table
Understanding Data Types
How To Select Data From Table
How To Format Our Results
How To Use The Where Clause
How To Use The Like Clause and Wildcards
How To Use AND and OR
How To Updating Records
How To Limit and Order Results
How To Delete Records
How To Delete (Drop) A Table
And More!

I’ll walk you through all of this and more, step by step. If you have any question along the way, I’m here to answer them.

If you’ve ever wanted to understand databases or use them in your Node programs, this is the course for you.

We’ll download everything you need for this course for free, you don’t need any special tools!

I’ll see you on the inside!

-John Elder

Installing All The Tools

Introduction

First Things First: How To Get Support Fast!

Check out my student Facebook Group...

It's a great place to get fast support for this course from me, to interact with other students, to post your projects and code, and to access course announcements and extras...

Join Now!

https://www.facebook.com/groups/codemycom/

Install Node

Install Wamp

Install Sublime and Git Bash

Start Sublime and Bash

NPM Install MySQL

Creating Connections and Databases

Create a Connection

Create a Database

Create a Table

Database SQL Commands

Alter Table

Insert Into Table

Insert Many Into Table

Result Messages

Select All

Loop Thru Selected

Select Specific

Select Fields

Where Clause

And Or

Where Variables

Order By

Delete Record

Update Records

Limit Records

Drop Table

Conclusion

Bonus Lecture

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!

3.8

3.8 out of 5

134 Ratings