Intro To MySQL With Node.js - Learn To Use MySQL with Node!
3.8 (63 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,967 students enrolled

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!
3.8 (63 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,967 students enrolled
Created by John Elder
Last updated 7/2020
English
English [Auto]
Current price: $129.99 Original price: $199.99 Discount: 35% off
7 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 1 article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • 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
Course content
Expand all 27 lectures 02:05:53
+ Installing All The Tools
7 lectures 27:01

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/

First Things First: How To Get Support Fast!
00:09
Start Sublime and Bash
05:24
NPM Install MySQL
03:34
+ Creating Connections and Databases
3 lectures 20:38
Create a Connection
06:55
Create a Database
06:09
Create a Table
07:34
+ Database SQL Commands
16 lectures 01:11:54
Alter Table
03:53
Insert Into Table
05:04
Insert Many Into Table
03:47
Result Messages
03:09
Select All
05:31
Loop Thru Selected
04:05
Select Specific
03:14
Select Fields
07:05
Where Clause
06:32
And Or
04:00
Where Variables
03:14
Order By
05:24
Delete Record
04:11
Update Records
04:41
Limit Records
03:40
Drop Table
04:24
Requirements
  • A Basic Understanding Of Javasctipt Programming Would Be Helpful
  • A Basic Understanding Of Node js would be useful
  • You don't need any special tools, we'll download everything we need for free. You just need a Windows, Mac, or Linux computer
Description

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



Who this course is for:
  • Anyone who wants to use the MySQL Database with Node js and Javascript